How to set default value for combo box with Email ID

(0) Share

Report

Posted on by ridhan

158

Hi ALl,

I have a combobox using below code:

Office365Users.SearchUser({searchTerm:ComboBox2_4.SearchText,top:999})

I want to set DefaultSelected property of this combobox with a help of email ID getting by lookup using below code. But unale to see any email selected by default.

[{Email:LookUp(equipment_characteristics,equipment_id=ComboBox3.Selected.equipment_id,approval_group)}]

Output of above Lookup statement is:

Please help! Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Write this in the DefaultSelectedItems Property of the ComboBox

{
DisplayName: "UserName",
Claims: "i:0#.f|membership|" & Lower(First([{Email:LookUp(equipment_characteristics,equipment_id=ComboBox3.Selected.equipment_id,approval_group)}].Email),
Department: "",
Email: First([{Email:LookUp(equipment_characteristics,equipment_id=ComboBox3.Selected.equipment_id,approval_group)}].Email,
JobTitle: "",
Picture: ""
}

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

@ridhan
you can try this too
Please use this in the DefaultSelectedItems Property of the ComboBox
:Office365Users.SearchUser({searchTerm:LookUp(equipment_characteristics,equipment_id=ComboBox3.Selected.equipment_id,approval_group)})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ridhan 158 on at

Like (0)

Report
Copy link

Link copied!

Hi @developerAJ and @zmansuri - If the above lookup will show different email Id separated by ";" for ex:
ABC@gmail.com;XYZ@gmail.com.

can i use the same formula using above default selected formula?

Please help!

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

@ridhan

We need to change the formula
ForAll(Split(LookUp(equipment_characteristics,equipment_id=ComboBox3.Selected.equipment_id,approval_group),";") ,First( Office365Users.SearchUser({searchTerm:ThisRecord.Value})))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ridhan 158 on at

Like (0)

Report
Copy link

Link copied!

Hi @developerAJ - By using above code it is only selecting first email id and not all email id. Can you please help.. When i check what data is coming after ForAll then it shows all email id in separate row but only showing 1 ID is selected as email.

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

Please check the value thats returning from the lookup column i tried the formula at my end it worked perfectly fine.
You can try at you end to check.

ForAll(Split("xyz@urorganization.com;abc@urorganization.com",";"),First( Office365Users.SearchUser({searchTerm:ThisRecord.Value})))

just replace sample values with ur organization emails . ur lookup should give the similar value.

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn

Was this reply helpful? Yes No
ridhan 158 on at

Like (1)

Report
Copy link

Link copied!

Thank you for your help!
It is working now. I have used your code email values and then replaced the emails with lookup.
Appreciate your help!

Was this reply helpful? Yes No