Combining Multiple Sharepoint List columns into ComboBox & searching

(0) Share

Report

Posted on by lg270492

133

Hi All,

I have searched for the answer to this but have been unsuccessful so I am hoping someone can help please 🙂

I would like to have a combobox displaying the order # column and freight order # column from my sharepoint list displayed in a double field layout, and having both #'s searchable within the combobox. I can search and view just one column by having the following:

Distinct(
'Sales Order Tracker',
'Blackout Order #'
)

Is there a way to combine both into the same combobox whilst maintaining the search function?

Appreciate any help you can give on this one!

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

There may be a smarter way to do this but one solution could be to consolidate both #'s into a collection or a new SharePoint list.
I think you will have to get them into the same column in order to search both at the same time.
Note that if you have a large amount of records a Collection may not be viable.

Was this reply helpful? Yes No
lg270492 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I was thinking I may have to do that to be fair. Only problem I have is that based on a set VAR I pre populate other fields in the form based on the Order #.

If I just duplicated my combobox and referenced the freight order # is there a way to populate the other fields based on that IF the order # combobox isnt used?

Thanks in advance

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
If I understand you correctly you could maybe do something like this

If(IsBlank(Order#.Text), Value1, Value2)

To populate a field based on selection in the box

Was this reply helpful? Yes No
lg270492 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry let me try explain a little better..

So on my combobox I have set the following:

OnChange = Set(BlackoutVar,LookUp('Sales Order Tracker','Blackout Order #'= OrderNo_Combo.Selected.Result))
Items = Distinct('Sales Order Tracker','Blackout Order #')

On my pre-populate fields I have the following (using material description column as an example):

Default = BlackoutVar.'Material Description'

If I input another combobox with the following:
OnChange = Set(BlackoutVar2,LookUp('Sales Order Tracker','Freight Order #'= OrderNo_Combo.Selected.Result))
Items = Distinct('Sales Order Tracker','Freight Order #')

Then its also searchable using the freight order column in my sp list. But is there a way to say IF I select an item from the Sales Order # list using the new combobox then pre populate based on that value rather than the Blackout Order # number in the original combobox?

Hope this brings some clarity to my question.

Thanks again for your help so far!

Was this reply helpful? Yes No