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
Dual Super User
Dual Super User

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
Dual Super User
Dual Super User

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,499)