filter outputs expression

[ElMeSaFeR]

Hi, 

I have two SP lists ( A, B) 

list B contain a column name (Doc_ID) , It should be a reference for A list ID column 

A >>> ID, Title, Name, ... 

B >>> ID, Title, Doc_ID, Name, ... 

I have a flow with multiple steps, one them with name (Get Items for list B)

the next step is Compose with

outputs('Get_Items_For_list_B')

to give me all details, But I need to filter the outputs by a specific ID

I need help about the code please!

[abm]

Hi @ElMeSaFeR 

If you looking to filter the List B by specific ID then use the filter query to extract the values.

If your ID is numeric column then you don't need to use the single quotes around it.

ID eq 10

Thanks

[ElMeSaFeR]

@abm 

Thanks a lost for your reply, but I need it in code because I'm using a "Compose" outputs already

so I need to filter this outputs 

[abm]

Hi @ElMeSaFeR 

 Could you please explain what you meant by code and you using compose? Could you post a screenshot of your flow?

Thanks

[ElMeSaFeR]

Hello @abm 

this this the steps 

then this is the outputs 

I need expression like 

Outputs('GetItems') where ID = DocID 

to replace it in the (Compose 2) step

[v-bacao-msft · Accepted solution]

Hi @ElMeSaFeR ,

If you want to filter items with equal values of ID and DocID, I am afraid the best option is to use Filter array. At present, we cannot directly use expression in Compose to filter an array. There is no function can achieve this.

I noticed that the value of DocID is a string, then you also need to use int() function to convert this value.

Image reference:

Hope this helps.

Best Regards,

[ElMeSaFeR]

@v-bacao-msft 

Thanks a lot

it's working with me