Choice function not working

(0) Share

Report

Posted on by mayaministr

Hi,

I want to add a radio buttons, and add the values from the choice column from Sharepoint list.

I am using the choice function in item property of the radio buttons, but it is not working.

Choices(Sharepointlist.choicecolumnintheSPL)

Powerapps doesn't offer me the choice column name at all after typing a period after the SPL.

Please, help me.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (25)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I have tested this and it working fine on my end. If you want ALL the choices available to that column it is

Choices(SPListName.ColumnName)

If you want only the choices currently selected for a record in the list it is(If the item is located in a gallery)

ThisItem.ColumnName

or for the First Item (not in gallery radio by itself)

First(SPListName).ColumnName

or to return specific records choices via LookUp

LookUp(SPListName, ID=3,ColumnName)

Was this reply helpful? Yes No
wsmith3675 49 on at

Like
a
(0)

Report
Copy link

Link copied!

I am having the same issue. Were you able to find a workaround ?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@wsmith3675 my answer above works for referencing a choice columns choices.

what happens when you type the dot after your splist name, does it give you columns an you just dont recognize any of them as your column name? If so, go to the list, in upper right hand click the gear icon, click list settings, on the settings page click the name of this column, then once on its page look at the address bar and look at the end of the address for what follows the =, this is the reference-able column name

Was this reply helpful? Yes No
wsmith3675 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying

Once I type in the SpList Name and then the dot it doesn't show me any of my field names

I've done it Choices(SPlistName. ) but none of the fields populate

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Just tested on my side, also was not showing up behind the dot as usual BUT I jsut typed the name of the column and closed it and it worked as expected see below

So go ahead and just type i tlike this

Choices(SharepointList.Column)

and don't worry about it not autopopulating, then close it and it should show as expected. I f you are unsure of where to find the correct name of your column see my prev comment

Was this reply helpful? Yes No
wsmith3675 49 on at

Like
a
(0)

Report
Copy link

Link copied!

It gives me this error. I am using the same Department field in the gallery (Legal and Compliance)

Thanks again for your assistance!

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I know it's redundant but can you go verify in the http address bar of this column in list settings that it is showing there same as you have written it? sometimes it chanegs itself when column is changed etc over time

Was this reply helpful? Yes No
wsmith3675 49 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem, this is how it shows on the bar
=Department_x0020_2

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
so yah it was 'Department 2' originally which gets refereced as seen in your example you just shared. so what you want it to read now is

Choices('Contract Management (Mock)'.Department_x0020_2)

can also try,

Choices('Contract Management (Mock)'.'Department 2')

depending on its mood.

In future, just to be safe, try and plan column names ahead of time, and never put a space in one

Was this reply helpful? Yes No
wsmith3675 49 on at

Like
a
(1)

Report
Copy link

Link copied!

That was the issue! Thanks so much, now I can add this back to filtering my gallery

Was this reply helpful? Yes No