Answered

Refresh function not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Screen that has BrowseGallery and Form on it. I would like to refresh both BrowseGallery and Form data, with one refresh button. Form has data source of SQL table, and has editable fields. BrowseGallery has also source of SQL table, but a different one.

I tried doing refresh only for a BrowseGallery on a refresh button:

OnSelect.Refresh(BrowseGallery.AllItems) Returns runtime error: Only managed connections can be refreshed

I tried doing refresh only for one datasource on screen:

Refresh('[dbo].[Table]') And also got a runtime error: Only managed connections can be refreshed

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Ok I found solution. Refreshing the datasource of BrowseGallery, and reseting the Form. And I put it both on refresh button.

Refresh('[dbo].[Table]'); ResetForm(Form)

Was this reply helpful? Yes No
alrezac Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for your follow up post! I am glad that you were able to get this resolved. Hopefully this will prove useful for future communities users who are having similar issues.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No