cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Form deleting data from columns

I set up a flow to update a row in Excel from an MS form. However, when it updates a column in the specified row it deletes everything else in the row except for the one piece of data that is input on the form. The form is regularly going to be used to update one "column" of data in a specified row. Is there a way to make it update the column/row without deleting the rest of the data in the row? Here some screenshots of the current flow. (Ignore the filter array, post a message part).

chrome_Ueldoqr9Md.pngchrome_RFx4h1U4rO.pngchrome_Ey1Z6UlH3h.png

 

 

 

 

3 REPLIES 3
powercorner
Super User
Super User

Hello @Anonymous 

 

you could read the row first, update it in the flow and then write it to the excel again.


With regards
Kevin

Anonymous
Not applicable

Can you give me an example? I am fairly new to this.

powercorner
Super User
Super User

Hi @Anonymous ,

 

yeah you could use the get row action first and use the output to fill in the update row action:

powercorner_0-1622742896019.png

 

With regards (likes allowed 🙂 

Kevin

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,859)