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条)