Power app to get latest Excel data
Hi all,
new to power apps. I have made a very basic app (with the help of copilot) that takes data from an excel which is shared on onedrive. The app works great, it shows a list of records (rows in the excel) in a gallery and when i click on one it populates a form with the relevant data.
However the app does not seem to be showing the latest data. It only shows data up to the point when i created the app. How can i make sure that the app pulls the latest data from the excel? The excel is not big and will never have more than a few 100 entries but its an excel which is used by other flows and apps.
Any help appreciated please.
EDIT: ok so i realise that copilot simply extracted the data from the excel at the time of creating the app, rather than 'connecting' to the excel file if that makes sense. So what would i have to do to make sure the data is taken from the online excel file in real time as opposed to importing the data once when i create the app?