Using a Combobox ins a form there is no data

(0) Share

Report

Posted on by nshaw75

440

Hi again I am seeking advice on what is probably a rudimentary task.

I have added a Combobox(DataCardValue1) on a form to select from the 'Category' column in my SharePoint list 'Contractor list'. This column is a Choice column and can have multiple selections. The formula I am using is

Choices([@'Contractor List'].Category) which is the default Custom Card. I know that the Combobox is limited to retrieving specific entries ie text only, or date etc. I have been wracking my brains for most of the day asto what I need to do.

As usual any help is appreciated.

Thanks You

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

WarrenBelz 153,415 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @nshaw75 ,

From what you have posted, If Category is a Choice column (whether it is multi-value or not) in your SharePoint List 'Contractor List' if you put

Choices([@'Contractor List'].Category)

in the Items of a Combo Box, assuming you have coded some choices in SharePoint, then they should display. Is there something inaccurate about what I have assumed ?

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Many thanks for taking the time out to reply.
This is one of the main things that frustrates me as after watching a few videos etc and reading through forums. I thought this would work too. However, it only worked when I have the Combobox outside of the form. IN the screenshot below, the smaller combo box is within the form and comes back empty when I press the chevron. The larger box is in a separate part of the page, and comes back full. Yet exactly the same code, the one you have in your reply.

Was this reply helpful? Yes No
WarrenBelz 153,415 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nshaw75 ,

Try with a Classic Combo box (to eliminate the Modern control as the issue)

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

I am assuming that I will need to set the form out manually to do that because by default, this is the combobox they place in the form for the choice column.

Was this reply helpful? Yes No
WarrenBelz 153,415 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@nshaw75 ,

Yes if (I assume you are developing in Teams) that is the default, you will need to change it. Modern controls still have a way to go to match the facility and stability of Classic items.

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,
I seem to be lost now. Although we will be able to use the app in Teams I thought I was creating it in Powerapps, a separate entity. Is this because I am using the make.powerapps.com website to create this?

Was this reply helpful? Yes No
WarrenBelz 153,415 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @nshaw75 ,

The only reason I mentioned Teams was that Modern Controls seem to be the default there. The rest of the post regarding trying Classic controls is still relevant.

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks again for taking time to look. I think I am going to shelve this for the time being, and go and open a nice cold beer as the sun is shining and the weekend is here 😎🍺

Was this reply helpful? Yes No