Hello
I'm trying to build a flow to collect data into an Excel.
When there's a new response is submitted in Forms.
Then :
"add a row into a table" to Excel.
When there's a approval response submitted, add the message into the last column of this row.
I chose "update a row" to add this extra data into the last column.
However I test several times, no row was found when update a row.
Do you have any suggestions about this?
Thanks
Solved! Go to Solution.
Hi @iiintro ,
It maybe cause the issue and the excel data time in Microsoft will has a different type.
I suggest that you could choose another column as the key column instead of the time column.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @iiintro ,
Could you please share the screenshot of the Start and wait for an approval action in the flow?
Could you please share the run history of your flow?
Please take a try to remove the Apply to each in the flow and add the Update row action directly under the Start and wait for approval action to see if your issue could be fixed.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I need add the response information into the row, so I cannot delete the apply to each step.
Please fine picture for more information
Hi @iiintro ,
You need to check if the special row exists in the excel table:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yeah that's what confused me most.
I add the same information into the row. And it shows different format in the Excel. Not sure if this cause it cannot be found.
Hi @iiintro ,
It maybe cause the issue and the excel data time in Microsoft will has a different type.
I suggest that you could choose another column as the key column instead of the time column.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
that maybe the best solution. Thanks your help!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
26 | |
24 | |
23 | |
14 | |
10 |
User | Count |
---|---|
57 | |
55 | |
29 | |
27 | |
24 |