Answered

Powerapps Collection from Sharepoint Text Column and then Update problem

(0) Share

Report

Posted on by reddragon

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:

Using Apps Using Formulas

Snipaste_2022-09-...

All responses (3)

Answers (1)

reddragon 6 on at

Like (0)

Report
Re: Powerapps Collection from Sharepoint Text Column and then Update problem

@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-...
reddragon 6 on at

Like (0)

Report

Re: Powerapps Collection from Sharepoint Text Column and then Update problem

@RandyHayes

many thanks. it is working now 🙂

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

BR
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: Powerapps Collection from Sharepoint Text Column and then Update problem

@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.