Comparing date in Excel to Timestamp

[EnochMan]

Hello @tom_riha , and anyone else who can help.

I have created a Microsoft form that fills into an excel sheet once the form is submitted.

The idea is to take the content of the excel sheet (which has been populated by the Microsoft form) and send via email to a supervisor.

How I want to do this is that, once the form is filled, I want to compare the Timestamp (Submission date) of the Microsoft form with the submission date (from the Microsoft form) filled in the excel sheet and once they match (true) it should pick that line and send the content to the people.

Unfortunately I keep getting false even though the two dates look alike. I am guessing it is a format issue or something.

The problem is that when I use the condition it comes out as false and I am not able to progress. Can you please help me as I am really behind on my schedule. Thanks a million.

[v-yetonggu-msft · Accepted solution]

Hi @EnochMan ,

Select the 'ISO 8601' format in the 'List rows present in table' control, and apply the formatDateTime('Dynamic Content','yyyy-MM-dd') formula to the dynamic content on both sides of the condition.

formatDateTime('Dynamic Content','yyyy-MM-dd')

Best Regards,

Sunshine Gu

[EnochMan]

Thanks a lot! You saved the day  @v-yetonggu-msft

[EnochMan]

Please another issue. How to I select only the true results from the condition and attach them through a Dynamic Content to Outlook to send? (i.e I want to be able to select the values of the true condition when I go to my Dynamic Content).

If that is not possible, please assist me to be able to send an email with only the values from the true condition.

Thanks in advance.

[EnochMan]

While testing the flow I made a lot of people fill it out. Unfortunately the condition comparing the excel time (which was received from the Microsoft timestamp) vs the Microsoft timestamp directly return true for all form responses within the day.

My "send an email (V2)" then sends all the various arrays that came as true to each person who fills the form. This is not what I was trying to achieve.

My idea is to find away to make the information that is filled in the excel sheet at the same time the form is filled to be lifted and sent via mail. Meaning that the one who fills the form should only receive one email containing info from the form he just filled.

I would be grateful if you could help me close this request.

[EnochMan]

Also, the reason I make the form fill the excel sheet is because I have formulas in the excel sheet which take the detail from the form filled and populate other data. It is that new data that I want the condition to locate based on the comparison between the time in the excel and the time the form was filled. 
I am trying to use the datetime info from the timestamp and the datetime filled in the excel as a unique identifier or a key to locate the row that was just filled. I resorted to ticks because I read it calculates to the minutest nanosecond but I am still not getting the desired result.