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

I have the same question (0)

All responses (3)

Answers (1)

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Bhanes22 103 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (1)

Report
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?

Was this reply helpful? Yes No