Answered

Filtering a gallery from a comma delimited string of values

(0) Share

Report

Posted on by jimi_hendrix

As the title outlines, looking to filter a dataset from a sharepoint list using a comma delimited string that is of any number of items. These items should be compared to the same sharepoint column. Any suggestions.. I was looking at ForAll loops within a filter but it doesnt work.

Thanks in advance

Categories:

General Questions

All responses (4)

Answers (1)

Hardtime 11 on at

Like (0)

Report

Re: Filtering a gallery from a comma delimited string of values

Tried to copy this but the ".ID" part isnt recognized, can I have a bit more explanation about that @v-hanytian-msft ?
Verified answer

v-hanytian-msft on at

Like (0)

Report

Re: Filtering a gallery from a comma delimited string of values

Hi @jimi_hendrix ,

We made a simple for you.
Data source:

OnChange of TextInput:
ClearCollect(Col,ForAll(Split(TextInput1.Text,","),Filter('SP List',Value = ColumnName).ID))

Items of Gallery:
ForAll(Col.Value,LookUp('SP List',ID in Value.ID))

Hope this will help you,

Best Regards,
Tina
jimi_hendrix on at

Like (0)

Report

Re: Filtering a gallery from a comma delimited string of values

Thanks @v-hanytian-msft , so that gets me a table of tables in a single column.. You can go into each table and the records that match are there but how do I put all of these tables that have results for each forall and put them into one table to display into a gallery??
v-hanytian-msft on at

Like (0)

Report
Re: Filtering a gallery from a comma delimited string of values

Hi @jimi_hendrix ，
Please try:

ForAll(Split(Text,","),Filter('SPList',Value = ColumnName))

Best Regards,
Tina