Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Autopopulating a field or using lookups to another list



I have 2 lists.


  • List 1: A bunch of emails of REGULAR people and what city they are from.
    • E.g Email:  City: United Kingdom
  • List 2: A bunch of emails of TRAINERS and what city they are from. 
    • E.g. Support Email: City: United Kingdom


What I want to do is when an email arrives in a mail box, create a new sharepoint item in a list with the contents of the email.

My list contains:

  1. Email address of sender
  2. Subject of email
  3. Body of email
  4. City
  5. Trainer assigned

I need help getting 4 and 5 please. 

  1. What I want to do is Look up the persons name/ email address on List 1, if they exist on List 1 then populate the City field with their city on the sharepoint list using MS Flow


Please do you have any thoughts on how to do this look up/ auto-populate step? Below is a step by step run through


  1. John emails saying he has an issue
  2. Flow autopopulates basic fields in a sharepoint list, e.g. the subject + body
  3. Flow would then search list 1, which contains a list of all users names and their city. If the person exists on that list then flow will take the persons city and populate the city field in the sharepoint item.

I can provide more info if needed. All my flow now is get an email and create an item on a SPO list.. 

I also saw this thread. 



Community Support
Community Support


Hi @jay312 ,


You could use a combination of Get items-Filter Query to get the specified item and get the field value contained in the item.

Please refer to the following blog and see if it helps:


Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,311)