Unanswered

Power Automate Flow to update Today Column in my Liste

Like (1) Share

Report

Posted on 6 May 2022 07:36:50 by Community Power Pla...

Hello,

I have built a flow so that my "Today" column is automatically updated in the list every day. This happens every day at 5:00 am. According to the flow, it updates the date every day without error. However, in my list, the day is only updated with a time delay. On 06.05 the list shows 05.05 as today's date and then on 07.05 the column shows 06.05. UTC is set to my time zone.

Has anyone had the same problem and knows a solution?

Many thanks in advance.

All responses (12)

Answers (0)

GeorgiosG 1,013 Super User 2024 Season 1 on 23 May 2022 at 13:20:38

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste

HI @Anonymous ,

could you please try to use current time and paste the variable in your "Heute" field and not utcNow().
Community Power Pla... on 11 May 2022 at 11:59:19

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste
GeorgiosG 1,013 Super User 2024 Season 1 on 11 May 2022 at 06:35:32

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste

I assume that the problem is in the update action. Could you please share the whole flow with a screenshot ?
Community Power Pla... on 10 May 2022 at 10:34:50

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste

The Flow ran successfully at 5:00 AM, but did not update the date in the SharePoint List. In my SharePoint list the date is still on the 09.05 but today is 10.05. Tomorrow it will change to the 10.05, so it is always one day behind.
Community Power Pla... on 10 May 2022 at 10:33:00

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste
GeorgiosG 1,013 Super User 2024 Season 1 on 09 May 2022 at 18:14:31

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste

Hi @Anonymous ,

what exactly did not work ?
Can you loop in the run history and check the starting date of the flow?
Community Power Pla... on 09 May 2022 at 06:26:54

Like (0)

Report

Re: Power Automate Flow to update Today Column in my Liste

Hi,

unfortunately it didn´t solve the issue. Any other ideas?

Many thanks.
Community Power Pla... on 06 May 2022 at 13:01:37

Like (2)

Report

Re: Power Automate Flow to update Today Column in my Liste

Hi,

many thanks for your help.

The regional setting in SP is my time zone.
The flow only runs one time a day, no double runs.

I inserted the starting time, I will check if that worked.
GeorgiosG 1,013 Super User 2024 Season 1 on 06 May 2022 at 08:10:05

Like (1)

Report
Re: Power Automate Flow to update Today Column in my Liste

For the delay problem can you please insert a Starting time, as this is a known issue.

To solve this insert in Starting time field in your reoccurrence flow:
2022-05-06T05:00:00Z
GeorgiosG 1,013 Super User 2024 Season 1 on 06 May 2022 at 07:58:16

Like (1)

Report

Re: Power Automate Flow to update Today Column in my Liste

Can you make sure that your Regional Settings in SP is also et to the same timezone ?

On 06.05 the list shows 05.05 as today's date and then on 07.05 the column shows 06.05.

This sounds to me like your flow run a second time.
Can you double check that in your run history of the Flow ?

Do you have versioning enabled for your list ?
If so can you check the versions of this item and see if there have been changes to this column ?