Hi,
I'm building an app that uses Excel files as data source, using Excel Online (Business) connector.
This Excel file has several tables in it. The users insert data to these tables through forms, and this is working properly.
On the same file, there is a table that uses information from the other ones and have some columns with formulas.
Some screens in the app uses these calculated columns.
But here is the issue. The data on these screens, that comes from these calculated columns, only update after I manually refresh the Excel source (or if I open the app again).
I tried changing to OneDrive connector but it does not allow formulas in the table.
Is there a way to force a refresh on the Excel file after new data is inserted (clicking a button after the data insertion, for instance)? I'm trying to find a way with Power Automate but couldn't find yet.
Thanks in advance!
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2