The issue you are facing is known limitation that the SDK excel connector uses does not support external data connections. It sounds a lot more complicated than it is, effectively you open the local copy and one button press refreshes the data connection and saves it to OneDrive so updating the workbook and allowing PowerApps to conect to the new data.Īn elegant solution it isn't but it may be useful to some!Īfter a couple of months of getting shunted between the Office 365 and PowerApps support teams, this is what I got (precise issue detailed below): This is the importnat part - after you have made the PowerApps connection you can then copy the "_PowerAppsId_" column and add that to the local copy of the static table. My only work-around so far is to keep a local copy of the spreadsheet, create the connection then use VBA to refresh the connection, copy the updated data and paste as static values to another table then save the workbook to OneDrive. If you open the OneDrive spreadsheet in Excel and view where the connection is used from the workbook connections dialog you will find that the connection is no longer used. The spreadsheet data connection still exists and can be refreshed from power query but the tables will not update.
It appears that the link between the spreadsheet table and the external data connection is lost after the dataset is added as a PowerApps connection.
0 kommentar(er)
