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 Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 343 members 6,100 guests
Please welcome our newest community members: