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!
Solved! Go to Solution.
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
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
@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!!
User | Count |
---|---|
183 | |
105 | |
89 | |
44 | |
44 |
User | Count |
---|---|
226 | |
106 | |
106 | |
68 | |
67 |