Answered

Refresh function not working

(0) Share

Report

Posted on by Community Power Pla...

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... on at

Like (0)

Report

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 on at

Like (0)

Report

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