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 / Powerapps Collection f...
Power Apps
Answered

Powerapps Collection from Sharepoint Text Column and then Update problem

(0) ShareShare
ReportReport
Posted on by 6

Hello together,

 

I have a gallery which allows user to select via CheckBox. I collect these information with Collect(colAuditCriteria, Lbl_E_GL_AuditCriteria_ClauseNumber_A0_1.Text). Then I save it to Sharepoint List in PlanText Column by Concat(colAuditCriteria, Value & "; "). 

There is another page which includes total SharePointList. User select from Gallery to edit this item. I am trying to create the same collection by ClearCollect(colAuditCriteria,Split(GL_AuditList_A0_3.Selected.'Audit Criteria Clause Number',";")) and then user supposed to edit the item again. But I could not manage this. Because when I have created colAuditCriteria from SharePoint List, it stored under Result Column. But when I select Checkbox to add or remove items from ColAuditCriteria it store under Value column. What should I do? please help?

 

Snipaste_2022-09-14_17-07-20.png
Snipaste_2022-09-14_17-08-21.png
Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @reddragon 

    You really need no collections to do this, but if you are sticking with them for some reason, then change your formula to the following:

    ClearCollect(colAuditCriteria, RenameColumns(Split(GL_AuditList_A0_3.Selected.'Audit Criteria Clause Number',";"), "Result", "Value")

     

    I hope this is helpful for you.

  • reddragon Profile Picture
    6 on at

    @RandyHayes 

     

    many thanks. it is working now 🙂 

     

    could you please also tell me what is other solution for that= 

     

    BR

  • reddragon Profile Picture
    6 on at

    @RandyHayes 

    I have one more issue regarding this topic. Why does this formula not work with numbers? I am having ClearCollect has some invalid arguments error message.

    ClearCollect(colAuditCriteriaID,RenameColumns(Split(GL_AuditList_A0_3.Selected.'Audit Criteria ID',";"),"Result", "Value"));

     

    Snipaste_2022-09-15_08-24-40.png

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 463

#2
WarrenBelz Profile Picture

WarrenBelz 364 Most Valuable Professional

#3
11manish Profile Picture

11manish 275

Last 30 days Overall leaderboard