Duplicate a collection, changing values in one column

[FinePilsner]

Situation: I have Collection1 with several rows/columns:

ID | Group | Date

01 | ABCDE | <blank>

02 | FGHIJ | <blank>

03 | KLMNO | <blank>

I eventually need to write this data back to a SharePoint list, but before doing so, I need to change all the records in the collection to today's date. However for display purposes in the PowerApp I need to leave Collection1 alone, so I need to create a new Collection2 with this change:

ID | Group | Date

01 | ABCDE | 07/31/2019

02 | FGHIJ | 07/31/2019

03 | KLMNO | 07/31/2019

I've been messing around with ClearCollect, ForAll, Patch, Update and can't get this right!

[RezaDorrani · Accepted solution]

@FinePilsner

col1 - your original collection

col2 - your new collection

ClearCollect(col2, col1);UpdateIf(col2,IsBlank(col2[@Date]),{Date:Today()})

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FinePilsner]

@RezaDorrani -- excellent once again...

I actually need to overwrite non-blank values as well, so what I used was this:

ClearCollect(col2, col1);UpdateIf(col2,true,{Date:Today()})

This seems like a slight misuse of UpdateIf but it's working perfectly anyway! Thanks again!!