I'm having difficulties with a flow to notify users when their documents hasn't been updated in the last year.
I set the recurrence to once per day
getitems sharepoint library
The expression on the get items query
Modifieddate le '
formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')'
It seems that I can't upload a pic.
Thank you for your help
Solved! Go to Solution.
Hi @omelo :
The key is that Modifieddate is not the correct field name.It's correct name is โModifiedโ
Please try this flow:
formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')
Best Regards,
Bof
Hi @omelo :
The key is that Modifieddate is not the correct field name.It's correct name is โModifiedโ
Please try this flow:
formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')
Best Regards,
Bof
Thank you for your prompt response!
I should have mentioned that modifieddate is a custom date column. (Our admins are modifying those documents and they need a custom column to trigger the notification) The name is correct!
After comparing and reviewing with no success in making it work. I decided to delete it and creating a new flow and it worked!!!
I'm marking this as solution as the expression is the most relevant part to my question. Also making sure the column name is correct is supper important!
Thank you for your help!
Have a great day
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
50 | |
36 | |
30 | |
27 |
User | Count |
---|---|
75 | |
60 | |
50 | |
43 | |
38 |