cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
David0094
Frequent Visitor

Calculated Data not shown in Power Automate

Hi everyone,

 

I am having an issue. In Sharepoint, I created a calculated date field, briefly we will calculated the next valid asset exchange date based on staff entry for example one month after current date or one year after current date.

Once the date is calculated, I would like to trigger an approval process.

 

The issue now is, in approval process, I am not able to populate the information from calculated field. For example, today is 22/11/2021, on one day after in calculated is 23/11/2021.

However, in power automate, despite I select the calculated field, when approval email triggered, it show the date was 22/11/2021 instead of 23/11/2021.

 

May I know how to solve this? 

1 ACCEPTED SOLUTION

Accepted Solutions
mahoneypat
Solution Sage
Solution Sage

It might be a UTC datetime issue.  SharePoint stores datetimes in UTC and it may be displaying local.  Depending where you are, a datetime of midnight might show as the day before.  I would look at the executed flow to see what the raw datetime value looks like.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

It might be a UTC datetime issue.  SharePoint stores datetimes in UTC and it may be displaying local.  Depending where you are, a datetime of midnight might show as the day before.  I would look at the executed flow to see what the raw datetime value looks like.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thank you Pat. yea, it was due to UTC issue. I managed to solved it after convert the time zone. much appreciated

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,415)