0

I am trying to create a dashboard in PowerApps, whose fields will get populated from the data stored in multiple Excel files from a single folder in a SharePoint site. This is what I have connected the SharePoint library (folder) to the dashboard in PowerApps through SharePoint connector. It is successfully listing all the excel files in the drop-down created in the dashboard.

Problem: Even though the Excel file names are visible in the dashboard, the data is not getting populated even if I select the required file from the drop-down. My goal is for the dashboard user to select a file from the dropdown to see the data from the selected file in that dashboard

Questions:

  1. It is doable in PowerApps.
  2. If it is doable, what could be going wrong?

Other points:

  1. Data in all the Excel files are in table format and have the same column names.
  2. All the files in the same SharePoint site.
  3. Columns in the Excel sheet is correctly mapped to the respective fields in the dashboard.
  4. I am using PowerApps(V2) to trigger in PowerAutomate flow.
Improve this question

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.