
Announcements
I have a list from Excel uploaded to SharePoint. The problem is that a lot of fields are missing. I'm trying to make a flow that parses each entry and get info to update missing data but it's not working.
I have a list of employees with Number, Title and Department missing some data. How can I have power automate get value in column email and getuserprofile to populate the missing data.
Please help
Hi @Anonymous
Do you want to update employee's information according to email?
I set up a simple flow, you can take a try with the following screenshots to see if it helps.
Assume I have a employee list, I will update the employee's information according to their emails.
Flow in details
Save and test flow.
After flow runs, my list will be update like this:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.