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.
Solved! Go to Solution.
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.
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:
Best regards,
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
214 | |
205 | |
86 | |
58 | |
38 |
User | Count |
---|---|
322 | |
260 | |
130 | |
86 | |
55 |