Splitting items from a Choice Field.

(1) Share

Report

Posted on by KWelsh

Hello all,

I have a sharepoint list that stores all our bespoke sessions. In it is a field called Subject which is a choice field. We can select more than one subject that a session was about (e.g. SharePoint and OneDrive) I am trying to get my app to read through and count how many times a subject comes up so I can display that data in a gallery. I had something working when just checking a text field in the list but have issues with this choice field.

I have tried many things including the below code which is meant to pull through and put all the subjects into a collection so I can count them but again, this isn't seperating any where multiple subjects have been picked.

ClearCollect(
    colSubjectsList,
    ForAll(
        Filter('SHAREPOINTLISTNAME', !IsEmpty(Subject))
        ,
            {
                subjects: Concat(Subject, Text(Value), ", ")
            }
        )
    
);

Example of the output.

Could anyone help me sort this out please.

Categories:

Building Power Apps

All responses (1)

Answers (0)

Suggested answer

developingteal 392 on at

Like
a
(0)

Report
Copy link

Link copied!

split(string, 'character to split on(,)', 'character to replace with')

I think this fits your needs.

An alternative and roundabout method is to push the data to an automate flow which parses it, maybe uses the above function, and rebuilds an array back to powerapps.

If the above function does not work, I can walk you through the automate method.