Power Platform Community Forum Thread Details

Hi All,

I have used concat function as follows

Concat(ThisItem.grade.Value, Value,",")

the result is

Maths-Good, English- Bad, Sports- Very good, Overall- Good

Q1. Now what I want to get only the Overall- Good and show it in a label.

Q2. Also how can I seperate each text into seperate labels. eg label 1-Maths-Good label2- English- Bad Label3- Sports- Very good Label4-Overall- Good

FYI- the concat result always ends up with Overall grade, but number of grades can be vary depend on the activities particular student taken. Can have max 6 activities, studen has to select from these six pre defined actvities.

Can someone please help me on this .

Thanks.

Categories:

Building Power Apps

@Vidanaw

Q1. Now what I want to get only the Overall- Good and show it in a label.

Last(Split(Concat(ThisItem.grade.Value, Value,","),","))

Split function: It splits the values by identifying the separator comma. The result is a table.

Last function: It will give you the last value of the table.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-split

Q2. Also how can I seperate each text into seperate labels. eg label 1-Maths-Good label2- English- Bad Label3- Sports- Very good Label4-Overall- Good

As the number of values is not fixed, I recommend place a gallery on the screen and set its Items property with following formula:

Split(Concat(ThisItem.grade.Value, Value,","),",")

Then, place a label inside the gallery and set its Text property to ThisItem.Value

Please give a try and post here if you have any questions.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.