Filter query with values from previous steps

[Stefaniebc]

Hello

I'm trying to create a filter query based on the value out of a previous step. 

The goal is the following:
In a member list, payments must be adjusted daily for the existing members. The information that comes in for the payments includes new order number, first name, last name, street, payment date and amount paid. So there is no specific ID anywhere with which you can link.
The member information also contains, for example, a member number. previous order number, first name, last name, street, payment date, amount paid, place, ...
To make the automatic action for the adjustments (changes/update) easier, I first load the information that comes in for the payments into a sharepoint list.
Then I set up an automatic flow starting with the trigger: 'When an item is created'. This starting with the list of information coming in for the payments.
Then I create a next step: 'Get items'. This from the member list. My goal is to indicate in the filter query that it should only search for the item whose first name, last name and street matches with the outputs from 'When an item is created'.

I just don't know how to write this filter query syntax correctly.
I find a lot of information if you have a fixed value for, for example, the first name, but not if you cannot provide it in advance.
Does anyone know how I can achieve this?
Kind regards
Stefanie

[ManishSolanki]

Hi @Stefaniebc 

You can use the below filter query to get the records with same name, last name and street and excluding the item which is newly created:

name eq '@{triggerOutputs()?['body/name']}' and lastname eq '@{triggerOutputs()?['body/lastname']}' and street eq '@{triggerOutputs()?['body/street']}' and ID ne @{triggerOutputs()?['body/ID']}

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[abm · Accepted solution]

Hi @Stefaniebc 

See here 

What you need to do is  clear the value 0

Then place your cursor. You can see Dynamic value and Add an expression icons

Click the first icon then you can see the previous steps Dynamic Values.

Thanks

[Stefaniebc]

Goodmorning

I tried the formula, but it gives an error message:

When I try with the experimental version, for some reason de dynamic content doesn't want to appear. I keep on pressing the buttons for dynamic content or Expression, but nothing happens.

Any idea why this could happen?

Gr

Stefanie

[Stefaniebc]

Goodmorning

As I wrote down that I couldn't get the dynamic content, I tried the same steps in Chrome. 

And it works!!!!

Yes!

Thank you.