Error when connecting PowerApp to Excel source on SharePoint

[GenericoName]

Hi again everyone,

When trying to connect my PowerApp to an Excel source on SharePoint I get the following error:

A value must be provided for data set
clientRequestId: fc2224c4-d1a0-4245-ae29-3eaa841d97bb

Session ID: 5937f847-1190-47a3-b32f-6fc592fc26dc

I found another post on here with the solution being to get rid of any formulas on your table, but my table doesn't have any formulas so I'm not quite sure why it's not working. It works with OneDrive just fine, but the PowerApp is going to be used by multiple people across different organisations so OneDrive is impractical.

[v-qiaqi-msft · Accepted solution]

Hi @GenericoName,

Do you want to access the data from the Excel file storing on the SharePoint Document Library?

Could you please share a bit more about the scenario?

Actually, PowerApps could only get access to a SharePoint list or Library metadata like Created. So, if you want to connect to the Excel file stored on the SharePoint site, I am afraid that there is no way to achieve this in PowerApps.

The Excel file data could be accessed using OneDrive rather than the SharePoint site.

Here is a similar idea you can vote for:

Create App from Excel file stored on SharePoint - Power Platform Community (microsoft.com)

Hope it could help you.

Regards,

Qi

[GenericoName]

Yes, I was planning on accessing data from the Excel file. Thank you for your response.