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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Transfer Collection Da...
Power Apps
Unanswered

Transfer Collection Data to Single Sharepoint Column

(0) ShareShare
ReportReport
Posted on by 2

Newbie here! Hi Everyone!

 

So I have a Sharepoint List and a customized form via PowerApp.

 

On PowerApp, I have a collection that collects data (user information). So for example, it'll collect, name, company, phone, email. This is just an example. I also understand that the collection collects data in the form of a table. 

 

I want to be able to transfer the collection (name, company, phone, email) and transfer it to my Sharepoint List into an existing column (just one column) and format it in a way where it would be:

 

Name

Company

Phone

Email

 

Sharepoint list has a "User Info" column, and hoping to transfer the collection data to this column.  All the other columns are already populated with the data collected from the form, except for "User Info". 

 

Anyone know if this is possible? Appreciate any insight/guidance. 

Categories:
I have the same question (0)
  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @JJV0004 , You can use JSON function. For JSON check below:

    ANB_0-1710617637018.png

    You can also use Concat function too. Check this:

    https://powerusers.microsoft.com/t5/Building-Power-Apps/convert-a-collection-into-a-text/td-p/502089

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-Collection-as-Single-Text-Field/td-p/1283477

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


     

  • JJV0004 Profile Picture
    2 on at

    Thanks! Where would I input this JSON function? Thanks for your help!

  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    @JJV0004 It could be the same button where you want to patch that in to SP list or on same button where you are creating a collection.

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 294 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 169

Last 30 days Overall leaderboard