DefaultSelectItem in a combobox

(0) Share

Report

Posted on by beniwal

120

Hi,

I am using a combo box with following formula in its items.

formula : Office365Users.SearchUser({searchTerm: toEmail_1.SearchText})

And I have a gallery of emails.

So, I want my combo box to select all users whose email is present gallery.

Tried setting the following formula in "DefaultSelectedItems" of combobox.

formula: Gallery3_5.AllItems.email (

Note: I have some other data too in my gallery. So, I am just taking the email. )

Please suggest any solution.

Thanks In advance

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @beniwal

Can you try to use the below expression in the defaultselecteditems of your combobox control:

Filter(Office365Users.SearchUser(), Mail in Gallery3_5.AllItems.Mail)

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
beniwal 120 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @yashag2255

Thanks for your reply

But filter function needs 2 arguments, that's why its throwing error.

we are passing 2 arguments, I don't know why it's not working?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @beniwal

The above formula already has two arguments, first is the name of data source and second is the Condition specified, these are separated by comma.

Can you try the below expression, there are certain difference in syntax because of the select regional languages.

Filter(Office365Users.SearchUser(); Mail in Gallery3_5.AllItems.Mail)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
beniwal 120 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @yashag2255

Still not working

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @beniwal

Are you getting any error? If yes, please more details around this error, maybe through a screenshot.

Was this reply helpful? Yes No
beniwal 120 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @yashag2255

No error but nothing is getting as selected!

Formula: Filter(Office365Users.SearchUser(),Mail in RecipientsGallery.AllItems.Result)

RecipientGallery: contains 1 email
.

combobox : Nothing is selected by default

Thanks,
Mohit

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @beniwal

Can you share more details about this Gallery control, what are its items and control type? From the Name it suggests to be a gallery but as per your latest comment, it looks like a combobox.

Lets debug few things, can you try to create a temporary button which you can remove after carrying out this test.

Place this expression on the "OnSelect" property, and check if this is returning the email address that you are expecting out of your gallery control?

Expression: ClearCollect(MyTestCollection,RecipientsGallery.AllItems.Result)

This should return the email address to work properly, if this is not returning proper data we may need to look for something to update this gallery.

Was this reply helpful? Yes No
beniwal 120 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Ni, it's a vertical gallery, which I designed to look like Combobox.

Tried your suggestion to test and it's working fine.

Was this reply helpful? Yes No
beniwal 120 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Thanks for your replies.

However, the issue is not solved yet. Can you please suggest something else?

And also Please let me know how to highlight the post. So that other users can also reply

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @beniwal

Can you verify the items property of your combobox control is set to use the same schema datasource? I carried out a test on my side with setting the default value as expected but changed the Items to another data source, in that case the result was not auto-populated.

Items: Office365Users.SearchUser()

Follow the below screenshot and verify if the configurations are same for your combobox:

Not sure what you mean by highlighting the post, you can definitely start a new thread or tag folks whom you want to check this out.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No