cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bluenose
Frequent Visitor

Adding Values from a multi-select column collection to another collection

Hi,

 

I'm trying to add some items from a multi-select column in a collection to another collection. For example, I thought that this would work:

 

ClearCollect(colWebDocs, colBasicInfo.webDocs);

 

However, the webDocs column (which is a Table format) specified in the example does not work.

 

Any advice would be greatly appreciated. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Bluenose,

 

Do you have a reference column like ID? 

 

With an ID column it should be possible to lookup the correct values and add the column into a new collection. As far as I am aware a table format should also work.

 

Below is an example of that approach:

 

ClearCollect(
    NewCollection,
    AddColumns(
        colWebDocs,
        "webDocsColumnCopy",
        LookUp(colBasicInfo, ID = colWebDocs[@ID], webDocs)
    )
)

 

View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @Bluenose,

 

Do you have a reference column like ID? 

 

With an ID column it should be possible to lookup the correct values and add the column into a new collection. As far as I am aware a table format should also work.

 

Below is an example of that approach:

 

ClearCollect(
    NewCollection,
    AddColumns(
        colWebDocs,
        "webDocsColumnCopy",
        LookUp(colBasicInfo, ID = colWebDocs[@ID], webDocs)
    )
)

 

View solution in original post

@Expiscornovus Thanks for your input on this issue. Yes it does work, however, I forgot to mention in my original post that webDocs is a multi-select checkbox control, which resides within a gallery. So I used the following simple solution to obtain the same data:

 

ClearCollect(colWebDocs, ThisItem.'Website Docs');

 

You're solution would have worked as well, so thanks for your valued input. 👍

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,912)