Showing results for 
Search instead for 
Did you mean: 
Level 8

Can no longer use UpdateIf(), or Collect() on a SQL datasource

So i had one SQL datasource connection where i was able to use, the command below without any issue.

Collect('[Access].[TABLE1]', SOME_COLLECTION)


We then had to move our data to another SQL server and i updated the datasource connection in the app and started to change the code for the new db name, however when i updated the same commands I now get the following error: "The first arguement of 'collect' should be a collection"


I am running the exact same commands with the exact same data source type, why am i getting these errors now?

Collect('[dbo].[TABLE1]', SOME_COLLECTION) 

Level 8

Re: Can no longer use UpdateIf(), or Collect() on a SQL datasource



It should be working with the example you're giving but can I ask you where did you have this code? maybe OnStart?


I've been having some issues lately running ClearCollect from OnStart.

Community Support Team
Community Support Team

Re: Can no longer use UpdateIf(), or Collect() on a SQL datasource

Hi @Bri,


What is your current situation?

To have the Collect(DataSource, Collection) work, you need to make sure they have the same schema.

You may first take a check of the schema of the TABLE1 with the formula below:

ClearCollect(SchemaCheck, '[dbo].[TABLE1]')

Compare it with the SOME_COLLECTION which you would like to save into the database table.


For how to use the collect () function, see:

Collect, Clear, and ClearCollect functions in PowerApps




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!


Power Apps Community User Group Member Badge

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


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

Top Solution Authors
Top Kudoed Authors
Users online (6,216)