Hello,
In my PowerApp, i have a gallery that displays info from a custom CDS entity, one of the fields being a User lookup (named Physician). When I select the item, it brings up all of that item's fields so the user can edit the information.... this is where I have my problem. Instead of using the User table for my Physician field combobox, I use the Office365Users table as my Users table does not have every single user yet. After I select the item in my gallery, I cannot figure out how to set the Office365Users combobox default to gal.selected.physician.'Full Name'.
I have tried various expressions such as filter(Office365Users.SearchUsersV2(),Email=Gal.Selected.Physician.'Preferred Email')) as well as a few others and I am at a loss.
Any assistance I can get will be greatly appreciated... I have been messing with this for hours and I am DONE.. Thanks in advance
Solved! Go to Solution.
Hi @LongRiders971 ,
You will need to apply the formula in "DefaultSelectedItems" property of the Combo box.
Below is the intro for Combo box:
DefaultSelectedItems – The initial selected item(s) before the user interacts with the control.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Hi @LongRiders971 ,
Have you tried below formula yet?
Filter(Office365Users.SearchUserV2().value,Email=Gal.Selected.Physician.'Preferred Email')
Office365Users.SearchUserV2().value this is the table of all users.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Hello @v-jefferni ,
I have tried this formula and it will not auto-populate the field with my .Selected. I even tried removing the gal.selected.Approver... and I added Email="email@company.com" and it still wouldn't work and i get the red x saying there is an error. Obviously, i replaced email@company.com with a real email address.
This is driving me crazy because I know it is going to be something stupid.
Hi @LongRiders971 ,
You will need to apply the formula in "DefaultSelectedItems" property of the Combo box.
Below is the intro for Combo box:
DefaultSelectedItems – The initial selected item(s) before the user interacts with the control.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.