Forum Discussion

Haniel Croitoru's avatar
Haniel Croitoru
Learn Expert
Aug 02, 2016

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 filtered/searched fields to be text fields.

I found a simple work-around for this by using a Calculated field in SharePoint for the choice field as PowerApps treats calculcated fields as text fields.  In the example below, the field I'm interested to search on is a choice field called bugStatus.  Instead, my PowerApp uses bugStatusValue in its search field.

 

PowerApps
SharePoint
  • Raouf Harbeg's avatar
    Raouf Harbeg
    Copper Contributor
    Apr 13, 2017

    Append you field with .Value and It'll work.

     

    CountRows(Filter(YourList, YourChoicefield.Value = "OK"))

     

     

    Thanks

    • Frederick Gonzales's avatar
      Frederick Gonzales
      Copper Contributor
      Aug 29, 2017

      Thanks Raouf!

       

      Just what I was looking for. This worked great! No need for an additional column.

    • Deleted's avatar
      Deleted
      Dec 23, 2017

      I've tried both the ChoiceColumn.Value and Calculated Column alternative and both indeed work for me except I am getting the blue dot/blue squiggly line warning about delegation. As I understand it, it works in test now, but when the list grows over 500 records, it will break. So I need an alternative. The only one I can think of it to use a workflow to copy the Choice field into a text field in SharePoint and put an index on that field. That will certainly work and avoid delegation, but is smacks of a hack. Are there any other solutions? For those who need to see code to understand, this is the phrase that is causing the delegation issue for me. 

      Filter('Store Task Template',Status.Value="Complete")
      • rodney martin's avatar
        rodney martin
        Copper Contributor
        Jan 26, 2018

        Curious if anyone has revisited this since December.  I tried the calculated column trick.  When I do it, I get the blue dot, PLUS the filter doesnt work!

         

        Additionally, if you use the .VALUE trick, it just says invalid name, and doesnt even let you use it. 

         

        Did something change?

        Deleted wrote:

        I've tried both the ChoiceColumn.Value and Calculated Column alternative and both indeed work for me except I am getting the blue dot/blue squiggly line warning about delegation. As I understand it, it works in test now, but when the list grows over 500 records, it will break. So I need an alternative. The only one I can think of it to use a workflow to copy the Choice field into a text field in SharePoint and put an index on that field. That will certainly work and avoid delegation, but is smacks of a hack. Are there any other solutions? For those who need to see code to understand, this is the phrase that is causing the delegation issue for me. 

        Filter('Store Task Template',Status.Value="Complete")

         

  • Deleted's avatar
    Deleted
    Aug 02, 2016

    Can PowerApps write the value back to the Choice Field at all?

    • Craig Debbo's avatar
      Craig Debbo
      Brass Contributor
      Aug 02, 2016
      Maybe add a comment on the 'powerapps' user voice site. There are still large gaps between SP and 'powerapps' even though the public integration is being released this month.
    • Scott Mckenzie's avatar
      Scott Mckenzie
      Iron Contributor
      Sep 30, 2016

      The other way I've found doing it, is using a new Entity within the CDM and use that as the choice field. When filed is updated in PowerApps, write the value back into SahrePoint Text Field.

  • Christopher Florian's avatar
    Christopher Florian
    Iron Contributor
    Mar 21, 2017

    Using the web editor I can't display a SharePoint Choice column on the browse screen.

    I used the Calculated Column trick and it worked. 

    And technically the CHOICE field IS TEXT...  What the HECK!

     

    I also had to do the same trick to get the app to sort by date.

     

    Thanks for the trick!

     

  • Anderson_BR's avatar
    Anderson_BR
    Copper Contributor
    Oct 22, 2019

    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))
     
    Hope it can help someone else.
    • yoyop50's avatar
      yoyop50
      Copper Contributor
      Oct 16, 2022

      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.

Resources