cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Refresh with Filter

Hi,

 

I'm trying to refresh a SQL Server View using a filter:

Refresh(Filter('[dbo].[vw_NewProducts]',Prod_ID = 19));

The error I'm getting is: "Only managed connections can be refreshed".

This View gather a lot of data from the many tables. Is there a way to refresh only a part of it?

 

Thanks a lot!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Refresh with Filter

Kindly look at this link
https://googleweblight.com/i?u=https://powerusers.microsoft.com/t5/PowerApps-Forum/Refresh-not-worki...

May be due to filtering a view with refresh instead of a Table.
You could also consider clearcollect On visible of the screen to handle the filter.

View solution in original post

6 REPLIES 6
Highlighted
Community Champion
Community Champion

Re: Refresh with Filter

Remove the first refresh.
Filter('[dbo].[vw_NewProducts]',Prod_ID = 19);
Refresh('[dbo].[vw_NewProducts]')
Highlighted
Community Champion
Community Champion

Re: Refresh with Filter

if only refresh, use
Refresh('[dbo].[vw_NewProducts]')
Highlighted
Frequent Visitor

Re: Refresh with Filter

@eka24, it takes 25 seconds to refresh the whole view. That's why I'm trying to filter only a part of it.

Thanks!

Highlighted
Community Champion
Community Champion

Re: Refresh with Filter

does it answer your question. If yes do accept as resolved
Highlighted
Frequent Visitor

Re: Refresh with Filter

The simple Refresh is working but it's taking too long.
I don't want to use it like this. I was thinking of a Refresh with Filter, but is it possible?
I might need a managed connection for this, as the error says, but how can a managed connection be defined?
Thanks!
Highlighted
Community Champion
Community Champion

Re: Refresh with Filter

Kindly look at this link
https://googleweblight.com/i?u=https://powerusers.microsoft.com/t5/PowerApps-Forum/Refresh-not-worki...

May be due to filtering a view with refresh instead of a Table.
You could also consider clearcollect On visible of the screen to handle the filter.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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