Combobox Default Selected Items - Condition

(0) Share

Report

Posted on by aorro933

Hello,

I am facing the following problem in power apps:

In a combobox I have as items:

Office365Users.SearchUser({searchTerm:Self.SearchText})

By default, the control displays the customer's mail that matches a selected item in the gal_0_Orders gallery:

Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer})

I need to add a new condition, as the client may have an external email. When that happens, it should show that external email by default. I have tried the following, but it gives me an error because it is not a table value, but a record value:

If(
!IsBlank(
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer}));
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer});
{DisplayName: LookUp(External_Customer;Mail=gal_0_Orders.Selected.Customer).Mail})

External_Customer is a Dataverse table where I store the external emails of customers.

Does anyone know how I could solve this?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

@aorro933

Can you try using IsEmpty please.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Thank you so much for your reply. I've tried the following:
If(
!IsEmpty(
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer}));
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer});
{DisplayName: LookUp(External_Customer;Mail=gal_0_Orders.Selected.Customer).Mail})

But I'm getting the error:
"Expected a Table value. This control's property expects Table values. The rule generates Void values, which is incompatible."

Also tried the next and getting the same error:
If(
!IsEmpty(
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer}));
Office365Users.SearchUser({searchTerm:gal_0_Orders.Selected.Customer});
LookUp(External_Customer;Mail=gal_0_Orders.Selected.Customer))

Do you know what else I could try?

Thanks

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!
Hello again,

I made some changes in property DefaultSelectedItems:

If(
!IsEmpty(
Office365Users.SearchUser({searchTerm: gal_0_Orders.Selected.Customer})
);
Office365Users.SearchUser({searchTerm: gal_0_Orders.Selected.Customer});
Filter(External_Customer; DisplayName= gal_0_Orders.Selected.Customer)
)

Now I'm not getting any error but the default item is empty (shouldn't be).

The other properties of the dropdown are:

Thanks in advance.

Was this reply helpful? Yes No