cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Another outage / bug - Drop down lists not working any longer

There seem to be another random outage / bug created on Microsoft's side afflicting unchanged apps that have been working for months.

 

Suddenly all my drop down lists are not working any longer.

 

They are fairly simple ones connecting to an underlying Azure DB, e.g.:

 

Items = Filter('[dbo].[Status]';Active)

 

"Not a valid connector Error Response".

 

It seems like removing the Filter(), might solve the error, but historically these kind of changes just have to be reversed as Microsoft later realizes that it actually should work.

 

What's the status this time?!?

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Another outage / bug - Drop down lists not working any longer

Hello,

We recently made some performance improvements to SQL connector as a result of which we lost the ability to specify Filter('[dbo].[Status]',Active) as it translates to incorrect SQL. It is a performance tradeoff.

The right way to specify the filter here is,

Filter('[dbo].[Status]',Active=true)

Thanks!

View solution in original post

8 REPLIES 8
Highlighted
New Member

Re: Another outage / bug - Drop down lists not working any longer

Hi, since this morning we are having exactly the same issue.

Highlighted
Advocate I
Advocate I

Re: Another outage / bug - Drop down lists not working any longer

I ended up with (temporarily) removing all Filters/Sorting, which of course leaves a crappy app, but at least it works.

My experience is that Microsoft realises that was they have messed something up in a day or two and then functionality is restored, so “waiting” is of course an option if you have a lot of drop downs (and non urgent needs...).

Unfortunately this is not the first time I have experienced problem like this with PowerApps, which is far from optional in a production environment.

Highlighted
Community Support
Community Support

Re: Another outage / bug - Drop down lists not working any longer

Hi @hedborg ,

I've made a similar test but not met the same problem like your description.

Please check your connection's condition and your network's condition.

Try to recreate your conncetion and work in a good network condition.

I've reported your issue to our product team.

If there is any improvement, I will reply here.

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Another outage / bug - Drop down lists not working any longer

Hi,

 

The following Filter was suddenly not working:

 

Filter('[dbo].[Status]';Active)

 

Now I instead tried:

 

Filter('[dbo].[Status]';Active=true)

 

Now that is suddenly working.

 

"Active" is a bit in Azure SQL.

 

Amazingly similar problem to this one 6 months ago, but the opposite way around...:

 

https://powerusers.microsoft.com/t5/General-Discussion/Filtered-Galleries-are-no-longer-working-sinc...

 

What's the recommended way of handling bit? How come the logic is changed every now and then?

 

Kind regards

 

Niklas 

 

 

 

 

 

 

 

 

 

Highlighted
Advocate I
Advocate I

Re: Another outage / bug - Drop down lists not working any longer

Hi all, 

is there an Update on this? My Filters do still not work as before. It seems like the logic changed. I was trying to recreate my formulas with the new logic but it takes a while, because it seems to be more complicated than it was before. Would be nice to hear something about the status on this.

Thanks,

Nando

Highlighted
Advocate I
Advocate I

Re: Another outage / bug - Drop down lists not working any longer

Any update on this?

Kind regards

Niklas
Highlighted
Regular Visitor

Re: Another outage / bug - Drop down lists not working any longer

Hello,

We recently made some performance improvements to SQL connector as a result of which we lost the ability to specify Filter('[dbo].[Status]',Active) as it translates to incorrect SQL. It is a performance tradeoff.

The right way to specify the filter here is,

Filter('[dbo].[Status]',Active=true)

Thanks!

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Another outage / bug - Drop down lists not working any longer

There is finally a response in this thread, which basically states that a bit can no longer be used as just e.g.

Active

but has to be

Active=true

I changed my filters quite early back to this logic and they have been working since.

Kind regards

Niklas

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,954)