cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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)

 

 

Una.png

 

2.jpg

5 REPLIES 5
Highlighted
Microsoft
Microsoft

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.

Highlighted
Frequent Visitor

OMG it works. Thank You

Highlighted
Frequent Visitor

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?

Highlighted

Hi @Ranp34 ,

 

Could you please share your formula of saving?

 

Best regards,

Community Support Team _ Jeffer Ni

Highlighted

The Update Formula on "Owner Email" Datacard is:

ddEmail.SelectedItems

 

Save.jpg

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,009)