Hello. Here is what I would like to do. When date is entered or modified in Day0If TestID contains the letters HRC anywhere in it:Update Fi

Power Automate - Building Flows

Unanswered

When a date is entered or modified in a sharepoint record, update a field showing a date showing 5 days from originally entered date

Like (0) Share

Report

Posted on 27 Jan 2022 04:40:58 by npsEDU

Hello. Here is what I would like to do.

When date is entered or modified in Day0

If TestID contains the letters HRC anywhere in it:
- Update FirstTestDue to show date Day0 + 5 days (In example below I want it to populate with 1/31/2022)
- Update SecondTestDue to show date Day0 + 8 days (Example below should be 2/3/2022)

flow table.png

Here is my flow so far:

addDays(triggerOutputs()?['body/_x0044_ay0'],5,'MM/dd/yyyy')

I'm quite new to this so any help would be much appreciated.

Thank you

I have the same question (0)

All responses (2)

Answers (0)

v-yujincui-msft on 28 Jan 2022 at 05:58:21

Like (0)

Report
Re: When a date is entered or modified in a sharepoint record, update a field showing a date showing 5 days from originally entered date

Hi @npsEDU ,

I agree with what @Mister_Shaik said, here is another way for your reference. You might consider using calculated columns in SharePoint.
https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
=IF(ISERROR(FIND("HRC",TestID)),DATE(YEAR(Day0),MONTH(Day0),DAY(Day0)),DATE(YEAR(Day0),MONTH(Day0),DAY(Day0)+5))
=IF(ISERROR(FIND("HRC",TestID)),DATE(YEAR(Day0),MONTH(Day0),DAY(Day0)),DATE(YEAR(Day0),MONTH(Day0),DAY(Day0)+8))
Result:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Mister_Shaik 1,006 on 27 Jan 2022 at 05:40:00

Like (0)

Report
Re: When a date is entered or modified in a sharepoint record, update a field showing a date showing 5 days from originally entered date

Hi @npsEDU ,

What you're doing is basically correct, but only assuming that the "FirstDueDate" and "SecondDueDate" fields are Single Line text fields.

If those fields are date fields, then you don't need to specify the format, you can just add the number of days to Day0 date and use it to update the fields.
addDays(outputs('Get_item')?['body/OData__x0044_ay0'],4)

Hope you find this helpful! 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No