Hi
I trying to figure out the following:
Create a collection with the Defaults of a SharePoint list plus a new Boolean column.
Eg Collection creation: ClearCollect(ColWeekPrjHoursLine,Defaults(WeeksPrjHours));
And to this collection add a new column “LineBtnSave” type Boolean
I have tried modifying the collection creation command as follows:
ClearCollect(ColWeekPrjHoursLine,AddColumns(Defaults(WeeksPrjHours)," LineBtnSave ",true));
But this way I get an error that “The function ‘AddColumns’ has some invalid arguments”
Can someone help me with this?
Thanks
Andreas
Solved! Go to Solution.
Hi @atagios
The defaults function returns the record. Therefore in this case, you would call patch, rather than AddColumns. The formula you would use would look like this.
ClearCollect(ColWeekPrjHoursLine,
Patch(Defaults(WeeksPrjHours),{LineBtnSave:true})
)
This will add the column LineBtnSave, with a value of true.
Hi @atagios
The defaults function returns the record. Therefore in this case, you would call patch, rather than AddColumns. The formula you would use would look like this.
ClearCollect(ColWeekPrjHoursLine,
Patch(Defaults(WeeksPrjHours),{LineBtnSave:true})
)
This will add the column LineBtnSave, with a value of true.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
185 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
241 | |
74 | |
71 | |
69 | |
65 |