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 : ymv+J9D7KgVHUVpl8TGXzK
Power Apps - Building Power Apps
Unanswered

Update an entire column using a collection

Like (0) ShareShare
ReportReport
Posted on 18 Jan 2023 20:31:35 by 8

I just want to start off by saying thank you for taking the time to read and or help. 

 

I have two lists on Sharepoint. LIst one is the Entity as seen below.

Screenshot 2023-01-18 at 3.20.47 PM.png

List two is some made up names.

Screenshot 2023-01-18 at 3.21.30 PM.png

I have my power app application. 

Screenshot 2023-01-18 at 3.22.25 PM.png

When I click Randomize the fake names are shuffled. This part is working.

Screenshot 2023-01-18 at 3.23.15 PM.png

Screenshot 2023-01-18 at 3.23.59 PM.png

I want to take the title of the scrambled collection and add it to the Fake name field on my list. I have been looking at the set function, then came across the Patch function. I have had no luck in getting it to work. Is there a simpler way of achieving this? I don't even mind if its the same button called generate. Or, do I have to perform a loop to pass the name in? I do not like the loop idea, because I would have to change it everytime I add more names. Again, thank you. I know that this is a noob question, but I have found that I could spend 4 more hours searching, or someone can just say hey that sounds like the [insert the correct function name]. Last week, I was learning flutter/dart and spent two days trying to learn to put a navigation bar on the side, to find that it was called a navigation rail. But again, Thank you in advanced

-John

Categories:
  • summersjs Profile Picture
    8 on 24 Jan 2023 at 01:01:12
    Re: Update an entire column using a collection

    Screenshot 2023-01-23 at 7.59.45 PM.png

    I've tried creating two collections, and then just write the new collection to a new list.. However, the ungroup is not working right now

  • summersjs Profile Picture
    8 on 19 Jan 2023 at 00:15:56
    Re: Update an entire column using a collection

    I've tried something like this,

    Screenshot 2023-01-18 at 7.15.34 PM.png

    I feel like I am on the cusp of a break through.

  • summersjs Profile Picture
    8 on 18 Jan 2023 at 22:34:06
    Re: Update an entire column using a collection

    I'm getting closer, I added the UpdateIf function. but it made all the records in the Fake Names column the same. 

    Screenshot 2023-01-18 at 5.33.55 PM.png

  • summersjs Profile Picture
    8 on 18 Jan 2023 at 22:23:30
    Re: Update an entire column using a collection

    So, I added this line of code

    ForAll(scrambled As updates,
    {
    FakeName: updates.Title
    })

     

    and it looks like it is working, 

    Screenshot 2023-01-18 at 5.22.36 PM.png

    As, i ts showing the FakeName field as the proper names. However, it is not saving/writing to my list in Sharepoint, or populating on the Table in the App. 

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete