cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mattthew
Advocate I
Advocate I

Update cell value in Excel

How would I update the same cell of an excel table every time a button is pressed.

 

I have a template built in excel (as a table).  

I was trying to use update a row in flow but it looks like this requires a key value so I wouldn't be able to overwrite each time from what I understand. 

 

Cell value header: Work Order

Cell Value: 

 

Button is pressed and cell value updates to work order selected on powerapps.  New work order is selected and cell value changes to new work order without creating new row. 

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks @v-xida-msft but what I ended up doing is building a flow that updates that row in excel based on a unique key value.  This seemed to do the trick.  Appreciate your response. 

 

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

HI @mattthew ,

Could you please share a bit more about the data structure of your Excel table?

How do you select the Work Order within your app? How do you list your Excel table records in your app? Using Gallery?

 

I suppose that you use a Gallery to list all Excel table records within your app, is it true?

If you use a Gallery to list all Excel table records within your app, and want to update the work order value based on the selected item in your Gallery, I have made a test on my side, please take a try with the following workaround:

Add a Gallery control (Gallery1) within your app, set the Items property to your Excel table. Set the OnSelect property of the Button to following:

Patch(
          'YourExcelTable',
           Gallery1.Selected,
           {
             Work_x0020_Order: "New Cell Value"
           }
)

More details about Patch function, please check the following article:

Patch function

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-xida-msft but what I ended up doing is building a flow that updates that row in excel based on a unique key value.  This seemed to do the trick.  Appreciate your response. 

 

View solution in original post

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,352)