Autopopulating a field or using lookups to another list

[manuelstgomes]

HI @jay312 

A simple OData query will do the trick. Here's how to do a Get Items and only get the items that you need:

I'm using a button trigger just to have values to test, but you can use the values that you get from the email.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[manuelstgomes]

Hi @jay312 

Yes indeed. I just tried to explain how to do the queries in the lists. Then you can use the same strategy to query multiple lists and cross-reference the information between them.

Just a sidenote. I made a mistake in the screenshot. When you do the comparison, since it's a string, you need to encompass the values in '. So it should be "City eq 'cityField' "

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[manuelstgomes · Accepted solution]

Hi @jay312 

Let's try to go from the beginning. First, you get the "Normal People" details (in my example, I use a manual trigger to test), and try to find a trainer in that city. After that, you attribute it to the person based on another list of trainers. 

Lists:

Normal People

This list has a lookup to the trainer's list, and I configured it as follows:

Here's the lookup

Trainers

This list is more straightforward. Here it is:

Power Automate

You have four steps:

1. Trigger getting the information of the "Normal People"
2. Find a trainer in that city
3. Check if one exists
4. If yes, assign it to the person.

Here's the result:

Let's break it down into steps. 

Get the trainers for that city

For that, you need an OData query, but it's just comparing the city:

Check if I have at least one:

You can check the length of the array and see if you have one value:

The formula is as follows:

length(body('Get_All_Trainers_for_that_city')?['value'])

Fetch the trainer's ID

This is necessary so that you can insert it in the next step. The formula is the following:

first(body('Get_All_Trainers_for_that_city')?['value'])?['ID']

Insert the data

Now get all the data that you have and add a new record in the "Normal People" list. 

Hope this helps!

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[manuelstgomes]

HI @jay312 

I think your condition is correct. Is your first "Get Items" from the Trainers list? If so your condition is correct as long as the city that you compare on the right side comes from the Customer. Then you'll match the customer's location with one Trainer in that location.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[jay312]

Hello @manuelstgomes 

Yes, the Get items is from the list which has the users + city 

[manuelstgomes]

Hi @jay312 

Then I don't understand the issue, sorry. If you follow the flow before, it should work as you like. I tested it on my side, and it's filling correctly.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[jay312]

Hi again @manuelstgomes 

I recreated everything from scratch just to replicate your pictures.

So I have 2 lists. 

1) Normal People 

2) Trainers 

[manuelstgomes]

HI @jay312 

In the "Get Items," the city inside the quotes needs to be selected from the "Dynamic Content".

Attached you can find a template. You can import it and run it yourself combined with the instructions that I wrote previously.

If you have questions in how to import a template just go here and I explain everything in detail:

https://manueltgomes.com/microsoft/flow-how-to-import-a-flow-template/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[jay312]

Delete

[jay312]

Solved