Hi,
When a form is submitted I would like to have Power Automate look at the date answer in the form (user must select date) and look up this date in a table (first columm) in Excel where it will give me the data in the second column of that row to send in an e-mail.
I have trouble in getting the right formats for the dates to compare because each time the condition is false.
Thank you for your answer. This was indeed the action I needed to do to make the flow correct.
Hi , @Nico_BE
First , you need to select the "ISO 8601" in your "list rows present in a table" action.
Second , you need to check the Date return format type in your flow run history from your "Get response details" and the "list rows present in a table" action.
Then you need to use the formatDateTime() function to uniform return format for dates.
For this function, you can refer to :
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang