Create a collection with the Defaults of a SharePoint list plus a new Boolean colum

[atagios]

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

[timl · Accepted 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.

[atagios]

Hi @timl 

Thank you, It worked!