Answered

Compare date answer MS forms with dates in Excel

(0) Share

Report

Posted on by Nico_BE

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nico_BE 23 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer. This was indeed the action I needed to do to make the flow correct.

Was this reply helpful? Yes No
Suggested answer

CU11121505-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hii

Same kind as above I do have a query that for example :

Employee name / manager name / rev name / 11th dec, 12th dec, 13th dec etc these are the column names.

And I have created a form when the response is submitted it should get updated in the excel file automatically saved in SharePoint. But here flow is working fine when it's updated manually for form responses for each day after changing.

I would like to make this form responses to get updated dynamically comparing the form submission date and the date column in my excel file??

Could you please help with the required steps I should use with conditions to be applied. Urgent

Thanks in advance

Was this reply helpful? Yes No