cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,056)