I am creating a 3 screen app.
I have set ONSTART changed to ClearCollect( NewGUID, ForAll( [ 1 ], GUID() ) )
from set( NewGUID, GUID() ) )
In the first screen OnVisible property, a collection:
ClearCollect(collect1, {username : User().FullName, sessionid : NewGUID, creationdate : Now()} )
Here I have a Login button. OnSelect property is
Patch('[dbo].[GRV_Details]',collect1)
The patch is giving me error : "Invalid Argument Type (table).
The collection of GUID is causing an issue. It is working fine with global variable. The database is updated at Login button.
Secondly, the GUID must get resetted at database update. How to achieve that? I thought in clearcollect will work and I will be able to clear the entry in collection to reset GUID value.
Regards,
Naresh R
Hi Naresh,
collect1 actually is a table (although it only has one entry), which is probably why you're getting the error. To get the first entry from the collection, you can do: First(collect1)
Also note that the collection collect1 is only local to your app and distinct from the data source -- it will not affect the data source implicitly. So clearing the collection will have no effect on the data source, for instance. To change the data source you will need to do so explicitly using functions like Patch() or other functions that allow you to manipulate data sources.
Here are some docs for some of these data source functions, if you want to read more:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-remove-removeif
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
70 | |
50 | |
46 | |
20 |
User | Count |
---|---|
253 | |
120 | |
84 | |
79 | |
68 |