replace text fields with dropdowns and/or comboboxes

(0) Share

Report

Posted on by davyjones

124

hello all!

This one should be fairly easy, and I have seen it done before, but for the life of me, I cannot figure out where I am going wrong. I have a new app, that is using the form control and is populated with not only the main sharepoint list (which gives me all of my fields) but also sub-sites that contain pre-made lists that I want to use to populate the dropdowns.

I have my fields (below) and I want to now delete (or change) them with the sub-lists. Where do i change things?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@davyjones

In your form, edit the fields. If you have NOT unlocked the datacard for the fields you want to change to dropdowns, click on the field in the edit fields list and change the Control Type to Allowed values.

If you have already unlocked the datacard, then remove the field from your form and add it back in and then change the control type.

Then, in the AllowedValues property of the datacard (this will only appear once you have changed to an Allowed Values control type), set your formula to get the items you want. You will provide a single column table of Value columns. So rename the column that you want to be the value.

For example:

RenameColumns(yourList, "system", "Value")

All the rest will be done for you (in regard to updating and re-displaying values).

I hope this is helpful for you.

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(0)

Report
Copy link

Link copied!

okay! no red x's on that, so things appear to be okay. Not sure how to test it, as I am only now putting the form together. As you can see from the below, I have updated the code as you have suggested. Now comes the harder part. Depending on what they pick in the first dropdown, it will affect what is in the second dropdown, as you can see from the same sub-list. Suggestions?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@davyjones

The easiest thing to do is to change your AllowedValues formula on the system dropdown to:

RenameColumns( GroupBy('CV&S BRT_System_Module', "system", "_modules" ), "system", "Value" )

Then on the Modules dropdown AllowedValues property, set the formula to:

RenameColumns(yourSystemDropdownControlNameHere.Selected._modules, "Module", "Value")

That would provide what you are looking for.

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay, so far so good! I do appreciate all of your help!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@davyjones

Happy to help!

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe I have the syntax wrong, but I tried to replicate your solution with another group of dropdowns:
Region and Country. I am getting red x's on both boxes, even though I used the same syntax as before, just changing the names.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@davyjones
When you group by, the first parameter is your source table. The second to x-1 parameters are the fields you want to group on. In your case, only one - "Region". The last parameter is the name of the column you want to create in your result table that will contain all the records that match the group criteria. So, in your case, the _country column will contain all the records that match a distinct Region. It would be 1 to x number of records in that _country table.

SO..,.you don't want to rename the _country column as it will be a table. It is the column of that table that you want to rename.

Your allowed values would specify the table of Value records you want.

Anyway, your formula on the first Allowed Values property is good.

The second one should be:

RenameColumns(DrpRegion.Selected._country, "<nameOfColumnYouWantInYourListHere>", "Value")

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the continued assistance! However, even though you said that the first bit of code is okay, I am still getting red x's on that one, and I changed the second to what you see below (because 'Region' goes with 'Country') and I am still a red X on that one too.

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Good morning, @RandyHayes !!

Just wanted to say that I have been using your 'splitting forms' view, and it works great with the newest app that I am building, so thank you so very much!

However, your solution for the dropdowns not only is still giving me red x's on most of the fields, but the ones that it doesnt dont give me any information when i click on the arrow. Like, its just not doing anything. am i doing this wrong?

Thank you,

Dave

Was this reply helpful? Yes No
davyjones 124 on at

Like
a
(0)

Report
Copy link

Link copied!

I think that I found the issue. The first column in both SharePoint lists is still under the 'title' column (even though its named differently elsewhere), so when I used that in the code you suggested, it all works now!

While I have you, how can the default be a 'blank' choice?

Was this reply helpful? Yes No