Hi all,
I am still somewhat of a newbie when it comes to Power Automate, so do forgive me if I ask weird things 🙂
The scenario is the following.
I receive a csv file which contains amongst others an username (column is called orderbegeleider in Dutch).
With the help of Power Automate, the output of the csv file is submitted to a sharepoint list with the create item function.
That list contains a column Emailadress, which is however blank since I don't receive the emailadress in the CSV.
I do however have a 2nd Sharepoint List which contains the user name and emailadress.
So e.g.
CSV file contains a record with username Person A
CSV file contains a record with username Person B
CSV file contains a record with username Person C
Sharepoint list for the emailadress contains two columns, username and email.
Username: Person A Email: personA@gmailetc.
Username: Person B Email: personB@gmailetc.
Username: Person C. Email: personC@gmailetc .
What I would like to achieve is that in my Create Item I can push the result of the lookup from the field emailadress.
So if in the CSV a record contains username PersonA, I fetch the accompanying mailadress from the 2nd sharepoint list which is personA@gmailetc and use that as input for my create item. See below for screenshot.
Most likely I first need to store the usernames/email via Get Items Sharepoint from the 2nd list so I can later reuse that but I am struggling how to proceed. Hope this makes sense and looking forward to a way to approach this.
Topic can be closed, not sure how I can close myself or remove post.