cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AnthonyPhan
Level 8

Clear columns inside collection

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)

1 ACCEPTED SOLUTION

Accepted Solutions
AnthonyPhan
Level 8

Re: Clear columns inside collection

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()})

 

View solution in original post

1 REPLY 1
AnthonyPhan
Level 8

Re: Clear columns inside collection

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()})

 

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,538)