Skip to main content

Notifications

Power Automate - Building Flows
Answered

Compare date answer MS forms with dates in Excel

(0) ShareShare
ReportReport
Posted on by 23

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.

 

 

Nico_BE_1-1714675067901.png

 

 

Nico_BE_0-1714675022349.png

 

  • Suggested answer
    CU11121505-0 Profile Picture
    CU11121505-0 2 on at
    Compare date answer MS forms with dates in Excel
    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 
  • Nico_BE Profile Picture
    Nico_BE 23 on at
    Re: Compare date answer MS forms with dates in Excel

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

  • Verified answer
    Re: Compare date answer MS forms with dates in Excel

    Hi , @Nico_BE 

    First , you need to select the "ISO 8601" in your "list rows present in a table" action.

    vyueyunmsft_0-1714698466866.png

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard