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

[Bri]

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) 

[Eickhel]

Hey,

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.

[v-micsh-msft]

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

Regards,

Michael