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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps Collection f...
Power Apps
Unanswered

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?

 

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,297 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"));

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard