Answered

How to make the formula refresh automatically once a day at midnight

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I have a question, what can I do to refresh the information in two fields every minute after midnight, where I download data from the database to the gallery and then from the gallery to the field. how to make the information in this field refresh.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

What is the DataSource and why type of field are you refreshing and why 🙂

this sounds like a Power Automate solution but i just want to check
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Table in dataverse is a source, i want refresh dateonly and text field.
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to refresh the data source every minute for some time period after midnight?
I have made a test for your reference.
1. Create a flow.
utcNow()
addHours(startOfDay(utcNow()),6)
2. Create a App.
3. Add a Timer Control and apply the following formula on its OnTimerStart property as:
Set(var_status,flowname.Run().var_refresh)
4. Add a new Timer Control and apply the following formula on its OnTimerEnd property as:
If(var_status="true",Refresh(DataSource));Set(var_status,"false")

Best Regards,
Charlie Choi