Answered

How to use Collect function to collect complex data type (string multiline)

(0) Share

Report

Posted on by Makerapps

Hi there,

Is there any way to set multiline data type (string multiline) in a powerapps collection so that these can be collected as a regular string and not through tables?

I use the office 365 user connector to filter my Office user gallery based on their skills which is a complex data (string multiline).

I’ve attempted to collect their skills into a collection and then use that collection in a combo box to filter my user gallery.

The Clearcollect function I’ve called worked quite well (ClearCollect(CollUserskills; {UserSkills:GalleryUsers.AllItems.LabelUserskills}) but I can’t reuse this collection in a combox because of the way skill data has been collected into my collection.

Do you have any idea how I can work around this problem?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

sayyed007amir 357 on at

Like
a
(1)

Report
Copy link

Link copied!
Some suggestions:
1. Click on table in collection and see what property it is showing, same you can use.
2. While collecting data try to collect with Last, First functions.
Can you try with adding
.Value or .Name
in last.
If not solved then please more specify your issue with more screenshots and code.
Thanks
Makerapps 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi sayyed007ami,

Thanks for your tip, using first function helped me a bit to come closer to the result that I looking for but not exactly.

I aim at letting my app user to filter by skills (using a combobox) a gallery I used to display o365 users.

To do that I though about collecting all users'skills display in my gallery and then user that collection in a combobox to filter my user gallery.

So far I've faced issues to collect all my users'skills in a collection at once. On top of that, user'skills are stored in a multiline fields.

Do you know any alternate to get all user'skills in a collection and than use this collection in a combobox?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Makerapps ：
Do you want to get the data of the table nested in the collection in the picture?
There are two ways: Ungroup Or ForAll
For example:
My Data source:

ClearCollect( CollUserskills, { UserSkills: Table( {Skill: "Skill1"}, {Skill: "Skill2"} ) }, { UserSkills: Table( {Skill: "Skill1"}, {Skill: "Skill4"}, {Skill: "Skill4"} ) }, {UserSkills: Table({Skill: "Skill2"})} )

Case1:Ungroup

Ungroup(CollUserskills,"UserSkills")

Case2:ForAll
Add a button and set it's OnSelect property to:

ForAll( CollUserskills, ForAll( UserSkills, /*Traverse all records in UserSkills*/ Collect( newcollection, /*Create a new collection to store the data*/ Skill /*Save all records in UserSkills to a new collection(newcollection)*/ ) ) )

In addition,If you want to remove duplicates.Using the distinct function is a good choice.
Best Regards,
Bof
Makerapps 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello v-bofeng-msft,

Thank you for your help, I've tested your solution but it did not work while using the Office 365 user connector.
I created a nested gallery to list each user's skills. The user gallery is labeled GalleryUsers et the nested gallery is labeled GalleryUserSkills
Then I used the following ClearCollect function to collect all users' skills but the 'CollUserskills collection came up empty.

As an alternate I used the contact function in a label (label1) to display each user's skills (Concat('Office365user'.UserProfileV2(id).skills.Value;Value).
The ClearCollect function worked but user's skills are not displayed like yours as you see on the pict I added. ClearCollect(CollUserskills; GalleryUsers.AllItems.Label1)

Do your have idea how to play around that data format issue?

Thank for your help
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Makerapps :
Do you want to traverse the id in GalleryUsers.AllItems to get a single column table consisting of the values of Concat (Office365Users.UserProfileV2 (id) .skills.Value; Value))?
Please try this code:

ClearCollect(CollUserskills;ForAll(GalleryUsers.AllItems;Concat(Office365Users.UserProfileV2(id).skills.Value;Value)))

Best Regards,
Bof
Makerapps 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thank a lot for your tips, it worked very well. My app has now :
- an office 365 user gallery = 'Office365users'.SearchUser()
- For each user, a label displaying the user's skills(Label2) = Concat('Office365users'.UserProfileV2(UserPrincipalName).skills.Value,Value,", ")
- a combobox filled with all users'skills, thank to those formulas = Filter(Distinct(Ungroup(CollUserSkills,"Value"),Value),Result<>Blank())

I've also tried to filter the user gallery using my combobox but I still have error message, can you please help me figure out what is wrong with my argument below? = Filter('Office365users'.SearchUser(), Label2.Text in ComboBox1.SelectedItems.Result)

Thanks a lot