
Hi all, I am kind of new to PowerApps so please bear with me.
I have an app in PowerApps which gathers data entered by a user. It passes this data as a parameter to a Flow. The Flow in-turn feeds this data into an Excel (Data.xlsx) which reads the data, does it's magic and injects the output into a different worksheet in Data.xlsx. Another Flow then reads the output data and displays it to the user.
Everything works as expected and the output data is written to the local copy of the Data.xlsx. The issue I have is with the local copy of Data.xlsx syncing with it's synced avatar in OneDrive. Since Flow can only interact with Excel Online and hence the OneDrive avatar of Data.xlsx, the consumers of my app have to wait for an unpredictable time for the outputs to be available in the output screen of my PowerApps app.
Am I doing something fundamentally wrong here or is this by design? It's a feature not a bug kind of situation :-).
Hi @Mandeep
Power automate (Flow) is an Async process, so time is really not predictable. We can use timer control to refresh the data once the flow is kicked off.
Refresh form or gallery every 5 seconds until you see the refreshed data. Finally, disable the timer.