filter outputs expression

(0) Share

Report

Posted on by Sharif Alhennawy

157

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!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: filter outputs expression

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

Was this reply helpful? Yes No
Sharif Alhennawy 157 on at

Like (1)

Report

Re: filter outputs expression

@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

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: filter outputs expression

Hi @ElMeSaFeR

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

Thanks

Was this reply helpful? Yes No
Sharif Alhennawy 157 on at

Like (0)

Report

Re: filter outputs expression

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: filter outputs expression

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,

Was this reply helpful? Yes No
Sharif Alhennawy 157 on at

Like (0)

Report

Re: filter outputs expression

@v-bacao-msft
Thanks a lot
it's working with me

Was this reply helpful? Yes No