Answered

ComboBox with text field value autofill with defaultselected items

(0) Share

Report

Posted on by Bhanes22

103

I have a combobox that is helping to filter a gallery and it is based on a text field in SP. I want to be able to autofill this combobox when a user comes to this screen while they are in edit mode for a project. I have tried this and its returning a table, but nothing shows.

Here is my code for the items property of the CB:

Filter(Distinct('External Person or Entity'.'State/Province','State/Province'),!IsBlank(Result))

And here is my current defaultselecteditems property

If(!IsBlank(LookUp(Transactions,'Request ID' = var_selectrequest_id).'External Person/Organization'),
Filter('External Person or Entity',EPO_Search.Text in Title).'State/Province',Blank())

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Please try this code just used "=" instead of "in"
If(!IsBlank(LookUp(Transactions,'Request ID' = var_selectrequest_id).'External Person/Organization'), Filter('External Person or Entity',EPO_Search.Text = Title).'State/Province',Blank())

Tried a simple filter from my side, seems to be working
Bhanes22 103 on at

Like
a
(0)

Report
Copy link

Link copied!

This is still not working for me, and its because of the distinct function I have in the items property, any thoughts on getting around this?
Verified answer

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I think you might be right, let try another way

If(!IsBlank(LookUp(Transactions,'Request ID' = var_selectrequest_id).'External Person/Organization'), RenameColumns(Filter('External Person or Entity',EPO_Search.Text = Title).'State/Province',"State/Province","Result").Result,Blank())

Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/
Want to support me! Buy me a Cup of Coffee?