cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iiintro
Helper III
Helper III

How to add the extra data into a row

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?

 

Thanksupdate1.png

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

6 REPLIES 6
v-alzhan-msft
Community Support
Community Support

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 informationerror.pngupdata2.pngupdate3.png

Hi @iiintro ,

 

You need to check if the special row exists in the excel table:

1.png

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.

 

update4.png

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!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,523)