Collect filtered from Gallery and only visible

(0) Share

Report

Posted on by Diggerr

I have collection ColumnHeaders which is dinamically always changing
Header:"Name"
Header:"Surname"
Header:"Phone"

Also same columns i put into Gallery and added modern control Checkbox
Now i want collect All visible items from Gallery where checkbox is checked

ClearCollect( 
 Filtered 
 ,Filter( Gallery1.AllItems , Checkbox_Each_Imone.Checked = true)
);

collect not only visible columns fro Gallery but all trash from sharepoint list columns, such as Author, Modified, {FilenameWithExtension},{FullPath},{HasAttachments},{Identifier},{IsFolder},{Link},{Name},{Path},{Thumbnail},{VersionNumber} and etc

So how to do something like

ClearCollect(
	Filtered 
	,Filter( 
		Gallery1.AllItems 
		, Checkbox_Each_Imone.Checked = true 
		& Gallery1.ColumnName in ColumnHeaders.Header 
	) 
);

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Diggerr,

Actually, Column name expects literal text, which means that you could not refer to it from another collection.

You need to specify it using a literal text by double quotes as below:

ClearCollect(Filtered,ShowColumns(Filter(Gallery1.AllItems,Checkbox_Each_Imone.Value ),"Name","Surname","Phone"))

Was this reply helpful? Yes No