How to Patch all records within one column of Collection to a single record of a column of SharePoint list

[Ahmad322]

Dear All,

I am fairly new to the PowerApps. I am building an app to help users to log issues related to industrial assets which they were previously logging on a paper base checklist. In the hard form, there was a multiple choice option that I needed to put in the PowerApps application. I used the following approach:

1. Inserted a blank gallery
2. Add desired multiple options of choice in the gallery items by using xthis table formula.   Table({Issue:"Passing Issue"},{Issue:"Stucking Issue"},{Issue:"Gland Leakage"},{Issue:"Actuator Leakage"},{Issue:"Diaphragm Replacement"},{Issue:"Body Leakage"},{Issue:"Bonnet Flange Leakage"},{Issue:"Inspection & Overhauling"},{Issue:"Other"})
3. Inserted a checkbox inside blank gallery 
4. In the text property of checkbox I typed "Thisitem.issue"
5. In the Oncheck property of checkbox ,I asked it to made a collection called"colIssue" using the function "Collect(colIssue,ThisItem)"
6. Now for every checkbox the user will select, it will put it in the collection and on uncheck remove it from the collection

Now I want to patch all the checkboxes in that collection to a SharePoint column called "Issues"., but while doing so I am facing a problem. First of all, the function wont let me simply put collection name in the patch formula, I  have to use Last or First functions with collection name to push it to the SharePoint list column (look at the last argument of patch function in the 3rd attachment). This results in only one value (first or last) which makes sense.

Is there a way that I can patch all the selections of checkbox inside my collection to a single column of SharePoint list.

I hope I make sense and am able to convey my problem.

Thanks in advance  

[v-xiaochen-msft · Accepted solution]

Hi @Ahmad322 ,

You can use Concat() to combine the contents of a column into a single string.

Here is the test I did:

Create a list with 'Title' and 'Issue' columns. The 'Issue' is the text column.

Create a gallery where users can create a collection by using a 'checkbox'.

Add a button to submit the data, set 'OnSelect' to the following formula.

Patch(Issue,Defaults(Issue),{Title:TitleInput.Text},{Issue:Concat(colIssue,Issue,",")})

After clicking the submit button, the data is in Sharepoint.

Best Regards,

Wearsky

[Ahmad322]

Dear @v-xiaochen-msft thank you so much. Concat function solved everything.