I have a flow that isn’t working as expected. Essentially, I want to trigger an alert 120 days before a specified date based on a column in SharePoint called ‘DataFim.’ If there’s an item in the list with the same date, I want to send a message via Teams.
Compose: formatDateTime(addDays(utcNow(), 120), 'yyyy-MM-dd')
expression condition: formatDateTime(items('Apply_to_each')?['Datafim'],'yyyy-MM-dd')