Update cell value in Excel

(0) Share

Report

Posted on by mattthew

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
Verified answer

mattthew 65 on at

Like (1)

Report

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.

flowquestion.PNG

Was this reply helpful? Yes No