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

Filtered Galleries are no longer working since this morning

Hi,

 

Since this morning (or night) all my galleries using filters have stopped working. A simple gallery filter like this for example:

 

Filter('[dbo].[ContactsImport]';imported_status=false)

Under Data > Data Source it suddenly says "No data source selected" and even if I reselect / refresh it still will not work.

 

Temporary problem with PowerApps or some major changes done lately?

 

Kind regards

 

Niklas

 

1 ACCEPTED SOLUTION

Accepted Solutions
hedborg
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

Hi,

 

It seems my bit-columns (Azure SQL) are treated differently since this morning:

 

This no longer works:

 

Filter('[dbo].[ContactsImport]';imported_status=false)

 

But this does (and required "" around the 0):

 

Filter('[dbo].[ContactsImport]';imported_status="0")

This no longer works:

 

&&!Deleted

 

This does:

&&Deleted="0"

Interesingly enough one would have thought that a Patch() would require the same logic:

 

{imported_status:"1"}

 

But this is not the case. Then PowerApps still require:

 

{imported_status:true}

Actually, it also allows...

 

{imported_status:1}

Without the ""....

 

At least my app is up and running again.

 

View solution in original post

7 REPLIES 7
t19670
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

I'm having the same problem, my filtered SQL views have stopped working overnight.

 

hedborg
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

Hi,

 

It seems my bit-columns (Azure SQL) are treated differently since this morning:

 

This no longer works:

 

Filter('[dbo].[ContactsImport]';imported_status=false)

 

But this does (and required "" around the 0):

 

Filter('[dbo].[ContactsImport]';imported_status="0")

This no longer works:

 

&&!Deleted

 

This does:

&&Deleted="0"

Interesingly enough one would have thought that a Patch() would require the same logic:

 

{imported_status:"1"}

 

But this is not the case. Then PowerApps still require:

 

{imported_status:true}

Actually, it also allows...

 

{imported_status:1}

Without the ""....

 

At least my app is up and running again.

 

View solution in original post

t19670
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

Thanks hedborg, I will try that out.

 

It would be nice if we were pre warned about this.

 

t19670
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

It does work but it is warning of incompatible type. With one being a boolean and the other as text type i.e.  the "0"

So it can't be evaluated correctly. 

 

This isn't a fix.

hedborg
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

Well, I am very happy for finding at least a "dirty fix". 

 

I fully agree that the logic behind how bit / boolean is treated by PowerApps is clearly missing...

 

Having said that my users can finally work again after three hours of down time.

t19670
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

Yes I agree. 

 

Although this issue needs to be fixed. 

hedborg
Level: Powered On

Re: Filtered Galleries are no longer working since this morning

For those checking in later than the 21st of December 2018. 

 

This was a temporary fix to a temporary problem.

 

Microsoft have now changed something back... and this solution is no longer needer, nor does it work any longer...

 

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

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
Users online (5,075)