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:
Solved! Go to Solution.
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.
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
Hi @v-yuazh-msft,
thank you for answer, screenshot in attachments. I can't choose format for Key column
Guys, any ideas?
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
43 | |
18 | |
15 | |
14 | |
12 |
User | Count |
---|---|
77 | |
38 | |
29 | |
20 | |
19 |