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

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
Highlighted
Community Support
Community Support

Re: Autopopulating a field or using lookups to another list

 

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.
Highlighted
Helper IV
Helper IV

Re: Autopopulating a field or using lookups to another list

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,458)