Filter array returning empty in update flow

Like (0) Share

Report

Posted on 30 Nov 2020 03:12:06 by FranzRoss

Hi guys!

I have the following two Sharepoint Lists:

In the list A01-CONTACTOS the field SERVER is filled up automatically with a formula applied over the field EMAIL_CORP.

I'm trying to setup a flow that will trigger when a new entry is created in A01-CONTACTOS or when an existing one is modified. The flow would lookup the corresponding RUT_ORG in the list A02-SERVIDORES according to the value for SERVER and update the field RUT_ORG in A01-CONTACTOS. The flow I made is as follows:

Then the following condition applies:

However, the flow keeps on failing. On inspection of the test results I noticed that the output of my Filter array is returning empty [], as shown below:

It must be something simple that I'm missing, but I can't find my mistake.

Can you give me a hand? any help is highly appreciated.
Regards!

Francisco

All responses (1)

Answers (1)

Verified answer

Expiscornovus 32,169 Most Valuable Professional on 30 Nov 2020 at 09:25:38

Like (0)

Report
Re: Filter array returning empty in update flow

Hi @FranzRoss,

I am seeing an item() in your Filter Array, however I don't see an apply to each loop, do you want to loop through that list? Or are you already filtering your Get Items by using an expression in the Filter query?

If you already have a filter query in the get items, you could use this expression to get the first item of your list of the Get Items and use that in your Filter array action.
body('Get_Items')['Value'][0]['SERVER']

Hope this helps a bit.