Combo Box

(0) Share

Report

Posted on by AndrewJRoberts

I have a couple of questions around the uses of Combobox's

I have created a 3 SharePoint Lists

a. Sales - lists all Customer Orders and what they have ordered etc

b. Parts List - list of all parts

c. Customer list - list of all Customers

1. Firstly I want to use a combo box to filter for all a Customers Orders, which I will work on but I cannot see all the fields in the SharePoint list especially the one named "Customers" so cannot start

2. on the edit form I want a combobox to point to parts list and a second one to Customer List for data Entry.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

KrishnaV 5,023 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @AndrewJRoberts ,

Please follow the below steps:
Add all the 3 lists to the APP
Add combo box set the items with the below formula

Sort(SampleList,Customer,Ascending)
Repeat the same for the other columns.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@AndrewJRoberts,
Now let's tackle your problems one by one.
1/ I agree with @KrishnaV, please make sure you have connected all the three SP lists to your App.
What is your 'Customers Orders' column type? Is it a Choice or a Text?
If it is a Choice column, add a ComboBox and set the Items property as below

Choices(Sales.'Customer Orders')

If it is a Text column, add a ComboBox and set the Items property as below

Distinct(Sales,'Customer Orders')

What's more, if you want to do some filtering based on the ComboBox selected, you need a Gallery and set the Items as below

Filter(Sales,'Customer Orders'=ComboBox1.Selected.Result)// Result could be replaces based on the 'Customer Orders' column type

2/ Could you please share more about your App configuration?
@AndrewJRoberts wrote:
Hi
2. on the edit form I want a combobox to point to parts list and a second one to Customer List for data Entry.
Does this second one mean a second ComboBox or a TextInput?
If you need 2 ComboBoxes to filter the options within the corresponding fields, you can refer to the solution provided for the first question.
Please share more about your App, a screenshot would be great.
Best Regards,
Qi

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AndrewJRoberts ,

I see you liked my reply, is there anything I am missing to mark my reply as a solution?

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
AndrewJRoberts 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You Krishna, I was trying and failing to multi-task, I added the 3 lists as suggested and got the Combo Box working. I have made some changes to my naming of Columns in the sharepoint tables ie. removing spaces etc.

I have a long way to go with this App so I will be shouting out.

Was this reply helpful? Yes No
AndrewJRoberts 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
I have had a bit of success, and I have made a few changes to the SharePoint list "Sales"
Firstly I changed the "Customer" Column to "Purchaser" and made it text and not a choice.

So I ensured that all 3 lists were showing in the app as suggested by @KrishnaV,
I changed from a combo box to a dropdown box, all ok, so I thought I would get clever!
In BrowseScreen1
OnVisible - ClearCollect(collectallcustomers,{Result:"ALL"});Collect(collectallcustomers,Distinct(Sales,Purchaser))

In the Dropdown Box
Items - collectallcustomers

Success that all works
In BrowsGallery1
Items - If(cmbSearch1.Selected.Result="ALL",Distinct(Sales,Purchaser),Filter(Sales,Purchaser=cmbSearch1.Selected.Result))
The filter works but no text is shown

Andy

Was this reply helpful? Yes No