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)
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.
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
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |