I try to refresh and the error is "only managed data sources can be refreshed." But any changes to the Excel table are not picked up in the App. I have a SharePoint list form as the primary data source, with an Excel table as a secondary. In flow I use Excel Online as the connection to read and update the same table, but in PowerApps it's Onedrive. It might be the same for SP but Onedrive (business) or something along those lines. Anyway, the data source in PowerApps isn't Excel Online, it's Onedrive. That difference may or may not be significant. I'm using an Excel table as a data source in an app, but the Excel file is in Onedrive not SharePoint. Subject: Is there any way to refresh an Excel data source stored in SharePoint?
0 Comments
Leave a Reply. |