Answered

Power Automate shows a wrong date that differs from sharepoint list

(0) Share

Report

Posted on by Aliceinsg11

I created a flow to auto populate MS word file and email out according to my sharepoint list. The dates of 3 calculated columns are shown correctly in sharepoint list. Out of 3 dates, there are 2 dates are captured wrongly under Power Automate, i.e 'last day of probation' & 'form submission date'. The date under sharepoint is 6 Dec 2023 but Power Automate shows 11 Jul 2023. Sincerely hope someone can teach and help with this issue. Thank you very much.

Categories:

General topics

Power Automate Wr...

I have the same question (0)

All responses (10)

Answers (2)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

You cannot access calculated columns in Power Automate unless something has recently changed. You will need to use an expression that does the same thing your calculated column does in SharePoint. You can then use the result of the expression to populate your Word document.

Was this reply helpful? Yes No
Aliceinsg11 16 on at

Like (0)

Report

Hi David,

Thanks so much for your time and kind reply.
For my case, I have 3 calculated columns and only 1 of the columns shows the correct date. Meaning actually Power Automate actually can read calculated columns. I also thought of calculating days in Power Automate. However, seems it not able to calculate futher date by months, i.e. 3 months from a specific date. Will be highly appreciated if you can share with me the expressions that able to do so.

Thank you so much!

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
If I understand correctly, you want to add 90 days (3 months) to a date from your SharePoint list. You can use the following expression:

addDays(triggerOutputs()?['body/Created'], 90)

Just replace the body/Created value with the actual date field from your SharePoint list.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Don't know about the bug that the calculated fields are not working correct when viewing them in Power Automate but it's possible because there are a lot of bugs out there.

For the calculation I would use "addToTime". This way you can add months as it should be.

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Was this reply helpful? Yes No
Aliceinsg11 16 on at

Like (1)

Report

Hi David. thanks for your suggestion. I thought that before. But the problem is that there are certain months not just 30 days and I need to get an exact date after ‘3 months’. So that expression won’t able to solve my issue. Thanks.

Was this reply helpful? Yes No
Aliceinsg11 16 on at

Like (0)

Report

Hi Matthy79, I have the same thought but couldn’t find those bugs.
I’m quite new to Power Automate, could you advise the if ‘addtotime’ requires any other expressions to work together in order to get 3 calculated dates and insert those calculated dates into both Microsoft Word and email content? The 3 calculated dates are based on 1 date the user input in sharepoint list, and 3 dates will be 1 month before input date, 4 months after input date and 1 day less than 4 months after the input date. In short, user input staff joining date, and power automate calculates performance review date (3 mths after join date), confirmation date (4 mths after join date) and last day of probation (1 day less than 4 mths). Should I use ‘condition’ to calculate 3 dates concurrently? Do I need to use ‘apply to each’ or ‘array’ function? Appreciate very much if you can guide me. Thanks so much.

Was this reply helpful? Yes No
Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Aliceinsg11

Here is the documentation of addToTime.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#addToTime

You could use it in a compose action or directly when using them. In your case I would use 3 compose actions (don’t forget to rename them) and after that use it while creating the word file and sending email.

Was this reply helpful? Yes No
Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

I always forget that there is an action that can do what you want. You can use the Add to time to achieve this:

For the base time you can populate it with your date from your source. If you need to go back in time, enter a negative interval.

Was this reply helpful? Yes No
Aliceinsg11 16 on at

Like (0)

Report

Dear Matthy79, thanks so much for your advice. My issue is solved perfectly. It will save lots of my time. Thanks again.

Was this reply helpful? Yes No
Aliceinsg11 16 on at

Like (0)

Report

Dear David_MA, thanks so much for your kind reply. I have used this function and it solved my issue perfectly. Thanks so much for your help. Appreciate.

Was this reply helpful? Yes No