cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
venseben
Level: Powered On

Filter galley with combobox

Hi all. I realy need some good answers on this issue.

 

I have a Combobox that gets data from a SharePoint list. Now I want to filter the data only to show certain items, but everytime I try to filter on the yes/no values, I get this error:

 

"Incompatible type. We cannot valuate your formula because the values that are compared in the formula are not the same type".

 

Can anyone explain to me how to fix this? The Yes/No fields, and it seemes that no matter how I set up the filter, I can only show all the items in the combobox, or none 😞

 

I need somehow to change the value from Yes/no to text. If I make it as a gallery, it changes to true/false, but this is also impossible for me to filter on.

 

Hope anyone has some good sugestions.

 

/Frank

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filter galley with combobox

This is a bug with PowerApps and SharePoint Yes/No columns. You may have to change the column type in SharePoint to get around this

Check out the blog of for more details. https://rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/

And go vote for this issue to be solved
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/1...

—-
Please Accept as Solution if this post answered your question so others can find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Filter galley with combobox

This is a bug with PowerApps and SharePoint Yes/No columns. You may have to change the column type in SharePoint to get around this

Check out the blog of for more details. https://rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/

And go vote for this issue to be solved
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/1...

—-
Please Accept as Solution if this post answered your question so others can find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

venseben
Level: Powered On

Re: Filter galley with combobox

@mdevaney THX so much. I have not been able to find out that my self. Thanks for link to the articel 🙂

 

/Frank

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,346)