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

(0) Share

Report

Posted on 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

All responses (2)

Answers (0)

v-yujincui-msft on at

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
Mister_Shaik 1,006 on at

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.