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