Get dates in sharepoint

(0) Share

Report

Posted on by VikasNagaraj

318

Hi,

Hope you are well.

I have a sharepoint List where a document can be added for approval, it has Approval Date, Review Period & Review Date.

Review Period is a choice column.

I want to display the Review Date based on the Review Period selected.

ie:

Approval Date + Review Period = Review Date.

Since Review Period is choice i do not know how to achieve this flow, could you guide me through please. Thank you.

Categories:

General topics

All responses (16)

Answers (1)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@VikasNagaraj try something like this

formatDateTime(addDays(utcNow(),180), 'yyyy-MM-dd')

instead of utcNow() pass the value of Approval Date and can update 180 to 365 etc. etc. to get other dates.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

@jinivthakkar
Thanks for the reply, i am not that good at flow, what are the steps that i should follow to achieve this? could you help me ? or is there a document or reference i can go through?
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

@jinivthakkar
Could you please help me with this? what would be the steps in flow that i should perform? Thank you
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

@jinivthakkar please help me with this? i tried my best to do everything i am not able to achieve this.
hemrhk 361 on at

Like
a
(0)

Report
Copy link

Link copied!
Since your review period is a choice column, it should be checked in condition within the expression. Based on the Review period selected Review date should be calculated.
Replace triggerBody with the "Review Period" and utcNow with "Approval Date"

if(equals(triggerBody()['text'],'3 months'),addDays(utcNow(),90), if(equals(triggerBody()['text'],'6 months'),addDays(utcNow(),180),addDays(utcNow(),0)))

For Power Platform related stuffs,
Follow this blog 365stack
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, could you guide me through steps please? if i am right the first step would be
Sharepoint - When a file is created or modified (properties only) under this i will map the the site and everything, after this step what should i use, i am really sorry not that good with powerautomate.
@hemrhk
hemrhk 361 on at

Like
a
(0)

Report
Copy link

Link copied!

Create a compose action and put this expression.
Pass the output of the compose action to the update item action.

For Power Platform related stuffs,
Follow this blog 365stack
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

@hemrhk
Is this how the expression should like ?
it says expression is invalid.
if(equals(triggerOutputs()?['body/ReviewPeriod'],'3 Months'),addDays(triggerOutputs()?['body/ReviewDate']),90),if(equals(triggerOutputs()?['body/ReviewPeriod'],'6 months'),addDays(triggerOutputs()?['body/ReviewDate'],180),if(equals(triggerOutputs()?['body/ReviewPeriod'],'12 months'),addDays(triggerOutputs()?['body/ReviewDate'],365),if(equals(triggerOutputs()?['body/ReviewPeriod'],'18 months'),addDays(triggerOutputs()?['body/ReviewDate'],548),if(equals(triggerOutputs()?['body/ReviewPeriod'],'24 months'),addDays(triggerOutputs()?['body/ReviewDate'],730),addDays(utcNow(),0)))
hemrhk 361 on at

Like
a
(0)

Report
Copy link

Link copied!
All the if conditions are nested so appropriate closing parenthesis should be added.

if (equals(triggerBody()['text'], '3 months'), addDays(utcNow(), 90), if (equals(triggerBody()['text'], '6 months'), addDays(utcNow(), 180), if (equals(triggerBody()['text'], '12 months'), addDays(utcNow(), 365), if (equals(triggerBody()['text'], '18 months'), addDays(utcNow(), 548), if (equals(triggerBody()['text'], '24 months'), addDays(utcNow(), 730), addDays(utcNow(), 0))))))

For more Power Platform related stuffs,
Follow this blog 365stack
VikasNagaraj 318 on at

Like
a
(0)

Report
Copy link

Link copied!

@hemrhk
I am still getting as expression invalid