Hello @v-yamao-msft,
Yeah sure. So, I've made an app on PowerApps that is linked to a Sharepoint List. The app is basically a form with some extra features, here is an image of the form as seen by the user:
There are some fields from the sharepoint that I've made specially to identify the SLA and the days on which the flow needs to send the email. Those fields are hidden in the form, but are visible in the sharepoint list. Also, these fields are calculated based on a formula made within the app. These fields are:
DateVF: integer division of the difference between the date on which that case was created and today
Escalamiento: difference between the date on which that case was created and the SLA defined (in this case it was defined to be 15 days from the day the case was created).
So, DateVF would alternate between numbers 0 to 5, when the number is 0 the flow would send the email to the address specified in the form:
The issue I'm having is that for those two fields to refresh I have to do it manually entering every case on the sharepoint list and saving that case every day, otherwise, these fields wouldn't update to the formula and stay fixed to the last time that case was modified.
So, my question is: Is it possible to refresh the sharepoint list automatically every day so these fields would update instead of having to do it manually?
