cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
oscaramv
Level: Powered On

ClearCollect update error

I'm using the ClearCollect function to create a new group of collections, from azure sql database, ex:

 

//Colecciones de datos
ClearCollect(colViewTicketsDBO;'[dbo].[Tickets]');;
ClearCollect(colRolesUsuario;'[dbo].[Usuarios]');;
ClearCollect(colPrioridades;'[dbo].[Prioridades]');;
ClearCollect(colIngenieros;'[dbo].[Ingenieros]');;
ClearCollect(colTecnologias;'[dbo].[Tenologias]');;
ClearCollect(colEstatus;'[dbo].[Estatus]');;
ClearCollect(colContactos;'[dbo].[Contactos]');;
ClearCollect(colClientes;'[dbo].[Clientes]');;
ClearCollect(colTiposServicios;'[dbo].[Tipos_Servicio]');;
ClearCollect(colTiposSolicitud;'[dbo].[Tipos_Solicitud]');;
ClearCollect(colHorarios;'[dbo].[Horarios]');;
ClearCollect(colNivelesIngenieros;'[dbo].[Niveles_Ingenieros]');;
ClearCollect(colTemplates;'[dbo].[Plantillas_Mail]');;
ClearCollect(colAsignados;'[dbo].[Asignado_Tck]');;
ClearCollect(colViewEstatus;'[dbo].[View_Estatus_Tck]');;
ClearCollect(colCancelMotiv;'[dbo].[Cancel_Motiv]');;

 

On the first run, all work perfectly. But if I need to Refresh or Update a collection using the same expression ClearCollect, the App doesn't do anything, doesn't respond.

 

Updating Sentence:

ClearCollect(colTemplates;'[dbo].[Plantillas_Mail]')

 

Last week everything was working without errors.

 

The question is: Is an internal problem? Is it a new feature? Has anyone experienced something similar?

 

Thanks

5 REPLIES 5
Eickhel
Level 8

Re: ClearCollect update error

Hey,

 

Is this code running in the OnStart method? there is an issue that's waiting for a fix.

 

https://powerusers.microsoft.com/t5/General-Discussion/BUG-SharePoint-Forms-Not-Loading-after-Publis...

oscaramv
Level: Powered On

Re: ClearCollect update error

Thanks, bro. But I know about this issue and I put all my collects in buttons or icons in the OnSelect method.
Is a very strange issue because last week all the app was working perfectly.

Eickhel
Level 8

Re: ClearCollect update error

There has been some weird issues with PowerApps lately but thankfully they're being fixed.

 

What about refreshing the datasource just before the ClearCollects?

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-refresh

oscaramv
Level: Powered On

Re: ClearCollect update error

Thanks, bro. Refresh is a good solution when you have a direct connection to the database, but this usually makes the app very slow (DB write/read). Using collections I improve the App performance but now I have this bug. For now, I'm rewriting all my App (32 screens) using Collec & Patch to solve the problem. I was using ClearCollect because is very fast to update a collection.
Thanks.
We'll still wait for a good solution to those issues.

KroonOfficeSol
Level 10

Re: ClearCollect update error

Hi oscaramv,

 

Turn on the option 'Render in Classic Mode' in the App Setting - Advanced Settings. This wil restore the functionality that you can tricker a toggle control with a global variable, like you're probably doïng.

 

I escalate this issue with the new User Edit experiance already to the PowerApps team and they are working on a fix.

 

Meanwhile support my Idea on adding stand alone Functions/methods to PowerApps, so we can call these from everywhere in our app and preform this logic in there. Follow this link Idea - Stand Alone Function/Method

 

Greatings,

 

Paul 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 55 members 3,323 guests
Please welcome our newest community members: