Answered

Prepopulate EDIT(Form) Based on Selected Item in Gallery (the FORM feeds the excel table and The Gallery fed by Excel Table)

(0) Share

Report

Posted on by AhmetOz

Hey Everyone,

I have created a single form to fill (Combo boxes - Drop Downs and Free Texts) in order to feed a "Excel Template".

When I click on to see the detailed View and click to EDIT for specific Gallery Item. It only returns the values in "FREE TEXT" text description. You can see the screenshots example below.

Could you please tell me how I can make it possible for "DROP DOWNS" & "Combo Boxes" to return the values selected in that form?

Thank you,

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Silvester. Akakpo 783 on at

Like (0)

Report
Copy link

Link copied!
Hi @AhmetOz ,
For the dropdown, go to the default property of the dropdown, and try this
Default = LookUp( Choices(DataSource.ChoiceColumn), Value = Gallery.Selected.value )
Accept this as a solution if it works for you. Kindly give it a thumbs up as well

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AhmetOz,

Have you solved your problem?

Do you want to display the default selected item within the Combo Box when you edit the item?

Could you please tell me how you set the Items property of these Combo Boxes?

Since you have excel table as your data source, I just assume that you populate the Combo Box with General columns, if you set the Combo Box Items property as Table1.ColumnName or Distinct(Table1,ColumnName), please set the DefaultSelectedItems property of the Combo Box as below:

[Gallery.Selected.ColumnName]

Note that if you have a Combo Box, you should set the DefaultSelectedItems property where expects a table value.

Was this reply helpful? Yes No