Power Platform Community Forum Thread Details

Hi all,

I need your support on the following flow.

I have two sharepoint lists.

List A includes: Employee name and the department (the information comes via a Forms response (flow already works).

List B includes: Department, name of department manager and the email from the department manager.

Now I want that as soon as a new entry is created in list A, the name and email of the department manager from list B is added (like a vlookup in Excel).

I have been able to transfer the data to list A, but only the last entry from list B is used and it is not checked in which department the employee is.

Can you help me with this?

Thanks!

Categories:

Building flows