Unanswered

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Hi @jimi_hendrix ，
Please try:

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

Best Regards,
Tina

Was this reply helpful? Yes No
jimi_hendrix on at

Like (0)

Report

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??

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hardtime 11 on at

Like (0)

Report

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

Was this reply helpful? Yes No