Answered

Filter Sharepoint List by Comma Delimited values (job numbers) from a column in another table

(0) Share

Report

Posted on by LeeEPMTS

Hello, Power Apps gurus!

I have been struggling to get this one sorted out. I have a SP List with users assigned to distinct job numbers. My requirement is to Filter that SP List by a dynamic set of job numbers stored in another table. To retrieve all users assigned to the current job selected. All column types are Text.

SP List

Dynamic Table

I have been trying Concat with Split, DropColumns and AddColumn but keep getting stuck with the Filter statement wanting a single text string (as opposed to a table of values)...

I'm sure this is a simple task, I just haven't been able to break it down.

Thanks in advance for any/all help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LeeEPMTS

Have you try using the function First.
Spoiler (Highlight to read)
The First function returns the first record of a table.
The First function returns the first record of a table.

First(Filter(tblUserJobAssignments, <filterField> = JobNumber)).JobNumber

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LeeEPMTS 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe

Unfortunately, the table being created needs to have all matching records (Job Numbers) (not just the First record) so First won't do the trick here...

Thank you though!

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LeeEPMTS

Something like this:

Filter( tblUserJobAssignments, Not( JobNumber in <SharepointList>.JobNumber ) ).JobNumber

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LeeEPMTS 37 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe

That solution returned the following:

I am looking for the Distinct Records associated with the matching Job Numbers in the SP List.

Thank you for your help! Maybe a For All, to iterate through each job number and add the matching records to varTestTable?

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Based of what you have it shoud look like:

Set(varTestTable, Filter( Distinct('User Job Assignments', Jobnumber), Result in tblUserJobAssignments.JobNumber ).Result )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LeeEPMTS 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmmm. @SpongYe that solution throws an error, maybe I am missing something in the syntax

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Try this one:

Set(varTestTable, Distinct(Filter( 'User Job Assignments', Jobnumber in tblUserJobAssignments.JobNumber ).Jobnumber), Jobnumber).Result )

Was this reply helpful? Yes No
LeeEPMTS 37 on at

Like
a
(0)

Report
Copy link

Link copied!

That syntax shows invalid number of arguments, received 1 expected 2

Was this reply helpful? Yes No
Verified answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

I created something similair to my first suggestion that works for me:

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LeeEPMTS 37 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, @SpongYe

I was able to solve this with the following code:
Set(tblTestTable, Distinct(Filter('User Job Assignments', JobNumber in varTeststring), 'User Full Name'))

Using another variable (varTestString) that was concatenating the Job Numbers. This gave me the Distinct User Names I was looking for.

Was this reply helpful? Yes No