sharepoint online - Coding document reminders in power automate - Stack Overflow

I am struggling with this code and not sure where to go.In summary - I am trying to create a code that

I am struggling with this code and not sure where to go.

In summary - I am trying to create a code that pulls the information from a SharePoint folder, checks the "Expiry Date" Column and compares it to todays date, then creates a list of every document that has a date of today or before today, then email me that list.

I have figured out how to have power automate email me the list but it emails me ALL of the documents not just the ones I want because I'm not sure how to separate out the documents that are "expired"

I do have a condition to compare the date to TODAY but I haven't been able to get it to work, the date in SharePoint is in MM/DD/YYY format but everything online says I should have the variable in ISO 8601 which also didn't work. I have the condition set to send me an email for true or false for testing

Date Variable:

formatDateTime(variables('CurrentDate'), 'yyyy-MM-ddTHH:mm:ssZ')

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744786890a4593679.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信