Answered

Edit multiple in gallery and save to excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm having some trouble with getting the gallery I build to update to excel, I am not sure what to code the save button as, each time I try to use patch I get an error. I would like to select the list based on this home screen, then edit this gallery to save to excel based off track position in the first column.

Each track will have it's own screen and save in a different excel table. Tracklist home screen.PNG Tracklist Edit.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I was able to make the car number column work using this patch function, but can not make the patch on the dropdowns update, any ideas?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to use a drop down to update a text field?

If so, please try this formula:

Patch(Table1,ThisItem,{Car:TextInput1.Text,full/empty:Drop Down1.Selected.Value})

I suggest you know more about drop down,here's a doc about it for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-drop-down

Best regards,

Was this reply helpful? Yes No