Unanswered

Populate sharepoint column based on second sharepoint list

(0) Share

Report

Posted on by pauleast77

I am capturing data in a sharepoint list from a form. For one of the fields (person's email address) I want to look up an alias for them from a different sharepoint list so it automatically adds the alias name to the first list. The lookup function doesn't really do what I want as I need the alias to be added to the original list.

Is there a way to do this in the list? Or is there a Power Automate flow that will populate the alias column by referencing the second list and its common column?

Thanks
Paul

All responses (3)

Answers (0)

srduval 1,663 Super User 2025 Season 1 on at

Like (0)

Report

Re: Populate sharepoint column based on second sharepoint list

Google power automate sharepoint odata filters. It's under advanced settings.
pauleast77 2 on at

Like (0)

Report

Re: Populate sharepoint column based on second sharepoint list

Hmm, not sure I know what you mean. Is there a video online or something that explains?
srduval 1,663 Super User 2025 Season 1 on at

Like (0)

Report

Re: Populate sharepoint column based on second sharepoint list

if it's a 1:1 relationship, you can do a get items and pass an odata filter to find the specific email address and then you'll have access to the column with the alias