Forum Discussion
Haniel Croitoru
Aug 02, 2016Learn Expert
Using SharePoint List Choice field in PowerApps
Hi all, If you've tried to create a PowerApp that filters or searches on a choice field in a SharePoint list, you may have found that it doesn't work. This is because today, PowerApps expects the...
Anderson_BR
Copper Contributor
Hello All...
I solved it using .Selected.Value to check the text of the choice field.
My DataCardValue8 have 2 options ("Option Visible" and "Option not Visible"). If user choose Option Visible the code set the variable FieldOptionVisible = true Else it is false. Then I use the variable FieldOptionVisible in the visible property of the field FieldOption.
To do that in "OnChange" event of DataValueCard8 I put the code:
If(DataCardValue8.Selected.Value="Option Visible",Set(FieldOptionVisible,true),Set(FieldOptionVisible,false))
My DataCardValue8 have 2 options ("Option Visible" and "Option not Visible"). If user choose Option Visible the code set the variable FieldOptionVisible = true Else it is false. Then I use the variable FieldOptionVisible in the visible property of the field FieldOption.
To do that in "OnChange" event of DataValueCard8 I put the code:
If(DataCardValue8.Selected.Value="Option Visible",Set(FieldOptionVisible,true),Set(FieldOptionVisible,false))
Hope it can help someone else.
yoyop50
Oct 16, 2022Copper Contributor
Anderson_BR Before I put the code on the "OnChange", do I need to something else? I have a choice column with dropdown menu (Yes, No) on Sharepoint list. I created an edit form based on this list but the dropdown menu didn't work. Any helps are appreciated. Thank you.