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
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,859)