how to get sharepoint lookup list value in flow email?

[Anonymous]

i want to send email on sharepoint item update with lookup list value in flow.

[abm]

Hi @Anonymous,

The below is an example of sending an email when SharePoint list is updated and filtered by lookup value? If you don't want to filter then you can remove the filter condition.

Thanks

[Anonymous]

Hi @abm

i want values from another list where current list's id and title is used as lookup column.

For ex. i have Product list and product accessories list, on product update i want to send email to manager with product accessories details.

Thanks.

[v-yamao-msft]

Hi ShraddhaShah,

I create two SharePoint list according to your description, Product, Product Accessory. In Product list, there is a Lookup column looks up to the items in Product Accessory list.

Then I create a flow to send an email when an item is modified in Product list, I select all the Product Accessory related items in the Body field, and it works for me.

Hope this can be a reference for you.

Best regards,
Mabel Mao

[Anonymous]

1. product list

2. product accessories list

here is my flow.

i want current updated item's all accessories in option box.

[MarceloAP]

Have you realized how to sold that Shaddhasha? Having the same problem and couldnt fint the solution yet.

[Anonymous]

You were able to do this a little while ago but they removed the ability to select the lookup fields.

I have a flow I built before they removed this function (Jan 2017 roughly). It still works, but i'm scared that if I change it, i'll loose the function, and have to fix it some how?

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-List-fields-available-changed...