I have developed 2 apps that are integrated in a Powerbi report, therefore the end users are using the apps by accessing the powerbi report.
These 2 apps are kind of related meaning that the users have the option to check a specific box in the first app (name: Incidents) so the new item added to be visible also in the second app (Name: Action Plan). (to be more clear, the users are adding a safety incident in the first app and in the second they can see the actions to overcome that incident and all the info is added in the first app). The second app can also be used as a stand alone app, but there may be cases when the users will want to populate the second app, by filling the first app).
My issues are the following:
- for the app to be more performant, to load faster, I have used in OnVisible property of the main screen the ClearCollect function where I am importing the data that I need from a sql database
- after the user is filling all the info required and click on the submit button, the data is patched to the sql table, then I refresh the table and clearcollect again the collection
- all good until now, the new item is added and visible in my app. However, the new item added is not visible in the second app, unless I refresh the browser or add a new item by using the second app
There is any possible way to refresh the collection without refreshing the browser, adding a new button to let the user refresh the collection etc.
I would like to be user friendly and to display automatically the new item added without any action from the user.