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)
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:
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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?
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights