hello all,
I have a sharepoint list with the below main columns:
I would like a flow to send a reminder email to someone for an item that is past due the "assignmentduedate" with 2 days.
the flow which I have is:
thank you
Solved! Go to Solution.
hi @kouliscon what you need to do is add an expression, the expresion is addDays('YOur value from Sharepoint',2)
Proud to be a Flownaut!
hi @kouliscon what you need to do is add an expression, the expresion is addDays('YOur value from Sharepoint',2)
Proud to be a Flownaut!
thank you @ChristianAbata but can you elaborate a bit at the formula as I am not so familiar like the one below?
hi @kouliscon you are doing it well but in the first part you need to select the dynamic content value, please change the tap from expresion to dynamic content and then select your colum value
Proud to be a Flownaut!
thanks @ChristianAbata but there is no Dynamic Content at the "Get Items" "Filter Query"..
any other ideas..
oh @kouliscon thats because you are getting lots of results, please create a compose action and inside add your column sharepoint value then try again with the expression and user the compose output.
Proud to be a Flownaut!
@ChristianAbata I am missing something here as I did the below
@kouliscon what is assignmentduedate for you? is not a column sharepoint?
To di what I suggest you you need to frist get items then before that you can add days
Proud to be a Flownaut!
@ChristianAbata assignmentduedate is a SharePoint Date column
what query I need for Get Items? I think there is the problem
Did you ever solve this? I am looking to do the same.
certainly this worked, below is the flow:
where the expression is: formatDateTime(addDays(utcNow(),-2),'yyyy-MM-dd')
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
27 | |
26 | |
13 | |
12 |
User | Count |
---|---|
58 | |
51 | |
30 | |
27 | |
27 |