Power Platform Community Forum Thread Details

Hi,

I have 2 SharePoint Lists say-

List 1 with columns ClientType, IndustryType, Location, and Owner all are text fields and mandatory.

List 2 with columns Client, Industry, Location and ResponsiblePartner.

In these lists column Client, Industry and Location fields have same set of data.

I have added column OfficalContact to List 1 and need to populate it with value in ResponsiblePartner from List 2 based on or corresponding to mapping

ClientType = Client AND IndustryType = Industry AND Location = Location. - >

Solution I am trying to achieve -

when an item in SharePoint List 1 is modified or updated -> look for the match that satisfies the AND conditions in List 2 -> return the resulting ResposiblePartner -> Populate List1's item with ResponsiblePartner's entry in OfficalContact.

Please advise if this can be achieved using automated flow or not. If Yes then how.

Thank you.

Categories:

Building flows