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...
leechynuts
Copper Contributor
All,
I recently have started to see this issue, again. I fixed it by using the calculated field trick, but my list got too long,and thus crashed it. Now, for another list, I am searching through an actual choice column; which somehow hasn't crashed, or thrown any errors.
Has anybody got a better fix than random miracles?
Alan Marshall
Apr 09, 2019Steel Contributor
I use a Flow to solve this. When item is updated I write the text value to a text field and then in PowerApps filter on the text field. It can mean a lot of Flow runs so watch your allocation. Also add another field for last updated by Flow and compare that to updated or you will get a looping Flow as the update will trigger the Flow again.