Looking up a value from another Sharepoint List

(0) Share

Report

Posted on by smodkins

Hi everyone,

I am hoping you can help.

I have a flow which is currently triggered from a sharepoint list by selecting an item, clicking automate and then the name of the flow.

The flow's initial action is then for a selected item with some input questions. The input questions are then added to the relevant column in the sharepoint list.

What I am looking to do:

Check the Sub-Department column in the sharepoint
Lookup this value in another separate sharepoint list
Return this value of administrator when a match is found*

*Currently this is a person field and can have more than one value in it. Ideally I would want to return their e-mail addresses so I can CC them into an e-mail which happens later in the flow.

Thank you so much in advance

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@smodkins you can use Get Items action with filter query to fetch the items from another list based on sub-department value.

Was this reply helpful? Yes No
smodkins 85 on at

Like (0)

Report

Thank you Anna. I have added in the filter query where 'Sub_x002d_Department eq' the dynamic field.

When I go to add the administrator to the CC of the e-mail it wraps the email in an apply to all so I think I am missing some steps. Can you help?

Was this reply helpful? Yes No
smodkins 85 on at

Like (1)

Report

I have managed to figure this out using this resource 🙂

https://powerusers.microsoft.com/t5/General-Power-Automate/how-to-extract-email-address-from-a-sharepoint-person-or-group/td-p/124642

Thank you Anna for getting me on the right track and knowing what to search for.

Was this reply helpful? Yes No