Display text from Collection with complex content (table, record), with Distinct

[burnout62]

Hello everyone,

I need your help because I'm like 80% to complete my App and I'm blocked at one of the last step.
This forum has been very useful because it is my first app but here I'm blocked and didn't find a solution anywhere.

Ok here we go:

1. My app is build from a SharePoint list. Below is a screenshot from my list:

A: drop down list, one choice only

B: free text field

C: drop down list, one choice only

D : drop down list, one choice only

E: free text field

F: drop down list, multiple choices possible (on screenshot, you can see 2 choices seperated by coma). And same choice can be picked in different items: on screenshot you can see "[Delay for file integration:yes]" has been chosen for both items.

I built the app: objective is to display the content from SharePoint list in a Gallery, with for each item a checkbox.

If user check the checkbox, item content is added to a Collection.
Then automatically a text field at the bottom displays data of items checked (only part of the data displayed).

- gallery, with items "RTM - Asset 1" (but different impact), with checkbox for each one

- text field (below "results count") where I would like to display data from Gallery items checked

Here are the details of my checkbox:

- Text is: I just display the text I need to display, which is 'Impact Description' followed by 'Impact Description: details' (Concat is there because 'Impact Description: details' is a drop down list and can have several choices):

- OnCheck: I Collect data from the item checked. I need: Asset, Impact (the Value, because Impact is drop down list with only 1 choice possible), Impact Description, Impact Description: details:

- OnUncheck: I remove item from my collection if Asset and Impact.Value are in:

- Default: it's also with Asset & Impact.Value:

Ok all of this is working. If I check the box, the collection is populated, and ofc the "DescriptionDetails" is a complex data (table) because can contain several choices:

Now my question is:

My text field is displaying:

- first: "Description" values from Collection, row by row, with a Concat

- second: "DescriptionDetails" values from Collection.

=> here is my Problem: I do not manager to make Distinct to avoid to display choices when they are similar, but from different items.

"Asset 1 - Unavailable" is having into 'DescriptionDetails' 2 choices

"Asset 1 - Disturbed" is having into 'DescriptionDetails' 1 choice, which is already displayed so don't want to see it (see screenshot)

> [Delay for file Integration: yes] should not be displayed twice.

edit: found working solution with Split() function, check below post.
But not sure that this solution is the best way to handle it...

Thanks!!

[burnout62]

Hello,

After doing some research, I updated my formulas and partially fixed my issue.
But the main Problem is still there: see original post updated.

My problem is to display data, with Distinct, from table included in Collection (yes, weird situation...).

Thank you.

edit: I found a working solution with Split() Function today, result is here but not sure that it is the best way to handle this...See below my text field code:

Concat(colCheckboxDescription;Description;";" & Char(10))
&"."&Char(10)&Char(10)&
Concat(Distinct(Split(Concat(colCheckboxDescription;Concat(DescriptionDetails;Value;",");",");",");Value);Value;" ")