web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding Values from a m...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Bluenose

49

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,975 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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) ) )

Was this reply helpful? Yes No
Bluenose 49 on at

Like
a
(1)

Report
Copy link

Link copied!

@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. 👍

Was this reply helpful? Yes No

Join the conversation