cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Return all values from collection

Hello,

 

I think what I am looking for is relatively simple, if I find the correct syntax/function to use... 

 

Essentially I want to:

1. Filter a collection to the point where I need it (works)

2. Return all values now listed in the 'Profile title' column - so if the collection returns multiple rows i want the profile titles of all rows, ideally concatenated in a 'return' field as shown below. 

 

Capture.JPG

 

I tried something like this, but am missing the syntax to return all profile titles:

 

 

If(
CountRows(CollProfiles1)=1,
Set(VarReturn, LookUp(CollProfiles1,Length = Min(CollProfiles1, Length),'Profile Title')) , Set(VarReturn, [????Return all profile titles in a string????] ) )

 

Any suggestions? 🙂

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Return all values from collection

My Collection name is Employees.

The column I want to return is FirstName.

 

 

Concat(Employees, FirstName)

 

 

Does that do what you want? Sorry, I don't exactly understand the question but I think this is the ballpark?

 

If you need to filter Employees you can. 

 

 

Concat(Filter(Employees, ID = 1), FirstName)

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Return all values from collection

My Collection name is Employees.

The column I want to return is FirstName.

 

 

Concat(Employees, FirstName)

 

 

Does that do what you want? Sorry, I don't exactly understand the question but I think this is the ballpark?

 

If you need to filter Employees you can. 

 

 

Concat(Filter(Employees, ID = 1), FirstName)

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Anonymous
Not applicable

Re: Return all values from collection

Thank you ! 🙂

 

That is what I meant yes. In addition, in case others need this solution, I added ; as a delimiter in this way:

Concat(Employees, FirstName, ";"

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,757)