Populate combobox with selected gallery item

(0) Share

Report

Posted on by la09

Hi,

I have a canvas app which includes a gallery populated by a collection.

When the user selects view item, it populates a form with the item selected, however all the items that are a combo box aren't populating with any value. If they aren't viewing from the gallery, the form is set to New, in which case the combo box should be blank.

Any ideas would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @la09,
Can you please share the formula you are using.
Try using the formula in DefaultSelectedItems property of combobox.

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

I have tried a few, the latest one was on the DefaultSelectedItems and it was:
If(varViewRequestAdmin,
gal_myapprovals_myrequests.Selected.'Job Title',
Parent.Default)

however it gives the error 'Expected Table Value'

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @la09 ,
What type of column is 'Job Title' it in the datasource - single line of text, choice - single or multi select, person/group, etc.?
Can you also share formula written in Item property of form control.

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

Job Title is the Title column in SP, however the others are a mix of Multi Line and people columns, and the way it is built is the combo box is what the user uses to select the item, and then the data card sat underneath is populated based on the value in the combo box

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Hi @la09 ,
Try using below formula -

[If(varViewRequestAdmin, gal_myapprovals_myrequests.Selected.'Job Title', Parent.Default)]

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

Perfect, thank you!

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

Sorry, it works for the other fields, but not the people fields, any idea why? they stay blank but dont error

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

@NandiniBhagya20 Sorry, do you know why the people field isn't working?

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Hi @la09 ,
The format used to set and update people field is a bit different. Try using below formula in DefaultSelectedItems property of people field is single select -

If(varViewRequestAdmin, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & gal_myapprovals_myrequests.Selected.UserColumnName.Email, DisplayName: Office365Users.UserProfile(gal_myapprovals_myrequests.Selected.UserColumnName.Email).DisplayName, Email:gal_myapprovals_myrequests.Selected.UserColumnName.Email ,JobTitle:"",Picture:"",Department:"" }, Parent.Default)

You will have to replace "UserColumnName" with people/person type column name in your datasource.

Was this reply helpful? Yes No
la09 90 on at

Like (0)

Report

Thanks, it is single select, however the above formula still keeps the field blank instead of pulling the data through

Was this reply helpful? Yes No