Hi everyone,
I'm trying to create Flow to get data from Flow and find this row in excel with this row 🙂
The problem is when I use datetime for "Key Value" it says that value is not found, I've tried to change date format but it didn't give result,
any ideas?
I use this formula to convert data:
I found solution, Excel return date in number format, means that for 23/12/2018 it will be 43457, in same time Form gives date in timestamp. So, to get result you need to convert nuber 43457 to timestamp format.
Guys, any ideas?
Hi @v-yuazh-msft,
thank you for answer, screenshot in attachments. I can't choose format for Key column
Hi @mikhail_matveev,
Could you please share a screenshot of the configuration of your flow?
If you compare the response submit time (with Precise time, minute and second) with a date time in the excel table, I afraid that no date time in the table would meet the same Precise time, minute and second.
You could take a try to compare the response submit time (with Precise year,month and date) with a date time in the excel table.
Best regards,
Alice