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

Autopopulating a field or using lookups to another list

Hi,

 

I have 2 lists.

 

  • List 1: A bunch of emails of REGULAR people and what city they are from.
    • E.g Email: John@sfsfss.com  City: United Kingdom
  • List 2: A bunch of emails of TRAINERS and what city they are from. 
    • E.g. Support Email: dsdsad@yhadd.com 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 Help@sdsdd.com 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. https://powerusers.microsoft.com/t5/Building-Flows/lookup-values-from-2-lists/td-p/235739 

 

 

2 REPLIES 2
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:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

 

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

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (7,751)