cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lstan
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
eka24
Super User III
Super User III

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
eka24
Super User III
Super User III

Remove the first refresh.
Filter('[dbo].[vw_NewProducts]',Prod_ID = 19);
Refresh('[dbo].[vw_NewProducts]')
eka24
Super User III
Super User III

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

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

Thanks!

eka24
Super User III
Super User III

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

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!
eka24
Super User III
Super User III

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
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (55,574)