Unanswered

Power APP-cascade drop-down from lookup list showing just 1 Item

(0) Share

Report

Posted on by Ranp34

I have a Contract Sharepoint List (Main List) which has multiples columns, the importances ones are Group Owner and Email Address Owner, both are Lookup Columns for a secondary list (Owner List) and i have a third List named Groups with a single line text column where i upload all the groups.

* Group Owner - "Grupos" on the secondary List - Lookup column, data is coming from the third List.

* Email Address Owner - "Email" on the secondary List- Single Line Text

Now I have created power app form on the Main List, if a user selects any Group Owner corresponding emails should be load in Email Owner column so user can select any of the emails (if there are multiple for that group).

I tried multiples workarounds to make this work, however the closer aproach just it is showing me 1 item.

Filter('Owner List', ID = cbGroup.Selected.Id)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Ranp34

Do you want the Owner Email combo box items depend on the selected Group in Group Owner combo box?

If you do, please follow the two steps below:

1\ Set the Group Owner combo box Items property to:
Choices([@Owner].Group)

2\ Set the Owner Email combo box Items property to:
Filter(Owner, Group.Value = cbGroup.Selected.Value) // or Id instead of Value if you look up Id of Groups

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Ranp34 10 on at

Like (0)

Report
Copy link

Link copied!

OMG it works. Thank You

Was this reply helpful? Yes No
Ranp34 10 on at

Like (0)

Report
Copy link

Link copied!

An Update, the combox works great on the Powerapp Panel.

However, when I saved the record, it refuses to save the field. All other fields are saved correctly. So, that field stay empty on the list.

Someone could help me?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Ranp34 ,

Could you please share your formula of saving?

Best regards,
Community Support Team _ Jeffer Ni

Was this reply helpful? Yes No
Ranp34 10 on at

Like (0)

Report
Copy link

Link copied!
The Update Formula on "Owner Email" Datacard is:
ddEmail.SelectedItems

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Ranp34 ,

Sorry for my delay. Have you solved this problem?

If not, as per your screenshots above, I assume that the Owen list's Email column is single selection, thus:
1\ The combo box need to be set to false of "Allow Multiple selection".
2\ The Update of the Data Card need to be set to:

ddEmail.Selected.Text

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Ranp34 10 on at

Like (0)

Report
Copy link

Link copied!

Hello jefferni,

No it does not work yet, the owner list email is a multiple selection lookup column, screenshot:

Basically they user should be able to select a group and then the emails related, he will be interest in select 1 or more emails. I dont know if how i tried to create this is feasible.

Was this reply helpful? Yes No