Unanswered

Organize the choices column view coming in from sharepoint

(0) Share

Report

Posted on by AD1990

Hi,

'Teachers' table has teacher information. In which there is a column called 'subjects' of type choice and multi select is enabled.

So, a teacher can select max 6 subjects to tuition.

Now, the teacher have a profile where they can go and change the subjects they are offering anytime.

The subjects are:

1. Chemistry, Biology

2. Biology

3. Maths, Physics

4. History, Geography

5. English Language, English Literature

6. Arts, Crafts

The data is shown in a gallery view on the teacher' profile screen. It has all the selected subjects coming in one after another.

Like:

Chemistry, Maths, Physics, Biology, History, Geography, English Language, English Literature, Arts, Crafts.

I want it to show up in in lines like above highlighted in bold(minus the numbering)

Please suggest if this is possible or not.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AD1990 It is possible. A few quesitons,

1. How do you combine these subjects. What is the logic behind it?

2. Is it always the same combination or can they change?

3. In which control do you want to show these information (Label, TextInput...)?

Some screen shots will be helpful!
AD1990 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
The table is called 'Teachers'.
Column name is subject which is a choice data type column and multiselect is enabled.
1. No combination or logic as such. The teacher goes to his/her/their profile's edit view and selects the subjects they can tuition(can be 1 or all of them) and saves them. Saving saves the form data and subjects are updated. The selection is done from a combo box selection.
2. The subjects may not change but the teacher is always free to select more or select less as per their need. So someone who was open to all subjects can go back and select only one. And someone who was offering one subject can go back and select all.
3. This information is shown in forms, galleries. I'll explain the main function through a scenario.
I am a student. I want tuition for Maths, Physics. I have a screen where I choose the subject and click on submit. It takes me to another screen which has a gallery. Now all the teacher who have 'Maths, Physics' as a subject will show up in the gallery(from the teacher who is offering only that to that teacher who is offering all subjects). The student will then select if they have an open slot and then apply for tuition.
So the main ask here is from a design perspective to be honest. Inside teacher's profile the selected subjects need to come in an order in one line after another, and not just one after another in the same line/space.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AD1990 You can use the Concat function to do that,

Concat(theTeachersRecord, subject, ", ")
AD1990 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT The problem here is the individual subjects have , in them.
Chemistry, Biology
Biology
Maths, Physics
History, Geography
English Language, English Literature
Arts, Crafts

Problem is that's business decision and we cannot go back and make it individual subjects.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AD1990 It should not add a trailing comma. See the example below,
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AD1990 Did you get it to work?
AD1990 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
I didn't get a chance to look into this. There's a weird error in my app where a button is behaving erratically for different users. It's throwing up 'Fetching items failed. Possible invalid string in filter query' for a few users. Not happening for me. I'm looking through thick and thin to solve this as this needs immediate attention.