web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : j/t4rEEoE4aHeuayC6qTbJ
Power Apps - Building Power Apps
Answered

Clear columns inside collection

Like (0) ShareShare
ReportReport
Posted on 5 Feb 2018 03:06:19 by 284

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)

Categories:
I have the same question (0)
  • Verified answer
    AnthonyPhan Profile Picture
    284 on 05 Feb 2018 at 14:54:12
    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()})

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 892 Most Valuable Professional

#2
Power Apps 1919 Profile Picture

Power Apps 1919 356

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 310 Super User 2025 Season 2

Last 30 days Overall leaderboard