cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted

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

Highlighted

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.

Highlighted

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

Highlighted

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.

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (10,373)