Hi All,
I have a colletion called 'Collection1'. I wold like to clear 'Column5", 'Column6" and 'Column7" of that collection whilst maintaining the data in the other columns. What is the best way to do this?
I have triead Dropping the collumns and readding them but the powerapps will complain that the columns already exist and throw an error.
NOTE: the rows of the collection do not contain a UID (if that makes any difference)
Ok the solution i came up with was using the UpdateIf function as it allows you to modify one or more values in one or more records. I hope this helps others.
UpdateIf(Collection1, true, {Column5: Blank(), Column6: Blank(), Column7:Blank()})