Unanswered

Filter a list based on another list

(0) Share

Report

Posted on by gasilva8

I have 2 lists and I'm trying to filter one of them based on another and then join the filtered column to the LIST 1 to create a HTML table. I'm comparing Question ID column of two lists.

The lists have the following structures:

LIST 1 (Answers)

Checklist ID Question ID Answer

LIST 2 (Question's item and its ID)

Question ID Question

This is my flow:

What I wanna do is to join question and answers on the same table. I don't know how can I compare If an item matches the other to join the tables. The final table should have this structure:

Question ID Question Answer

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@gasilva8

Is the question ID of type lookup on List 1?

Was this reply helpful? Yes No
gasilva8 64 on at

Like (0)

Report

@Mira_Ghaly,
No, question ID it is not a lookup column. The column is filled by Power Apps.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Hi @gasilva8 ,

Please use following approach as mentioned in below url :

https://sharepains.com/2020/03/20/create-joins-in-power-automate/

Thanks

Was this reply helpful? Yes No
gasilva8 64 on at

Like (0)

Report

Thank you @ManishJain!
I'm working on what you suggested.

Was this reply helpful? Yes No
Verified answer

gasilva8 64 on at

Like (0)

Report

Hey @ManishJain

Thanks for the tip.
With some adjusts it worked.
Here is the flow:

Was this reply helpful? Yes No