How to get all the datas from a column in collection.

(0) Share

Report

Posted on by Community Power Pla...

Hi guys, I want to get all data from a column in collection.

Title	TableName	theID
1	Name1	1
2	Name2	2
3	Name3	3

I want to get the data from TableName so I could inform the users which table has been changed.

ClickabuttoninPowerAppstosendanemail.Run(LookUp(
 ProvidedAccess,
 true,
 email
 ),"Updates on PowerApps", "I have updated or add a record/records <br>" & Filter(ChangesList,LookUp(ChangesList, true, TableName));

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

rsaikrishna

3,703 on at

Like (1)

Report

@Anonymous

Title	TableName	theID
1	Name1	1
2	Name2	2
3	Name3	3

I am assuming above collection name is "colTableValues"

To get all the values from TableName column, you can use following formula:

Concat(colTableValues,ThisRecord.Value.TableName,";")

Output:

Name1;Name2;Name3

Please give a try and let me know.

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.