Updating an item (person) based on lookup into another list

[JAX_ND]

Hi Everyone,

I am kind of new here, and excuse my english.

Basically I have a 1st sharepoint list named listA containing 2 columns : Codes (text column) and Approver 1 (person column).

My second sharepoint List (list B) contains a list of all codes with related approver also in 2 columns which

What I want to know is if it is possible when in listA I select a code, that a lookup or an update is done based on the approver name which was initially defined in List B, for that code ?

Many thanks for your help

[manuelstgomes]

Hi @JAX_ND 

I don't think you need a Power Automation to do that. Just configure SharePoint with the List B being a lookup to the Column "Code" in the list A and you'll have it automatically updated. Something like this:

If you want you can even define it to allow for multiple values, so you have multiple lookups to SharePoint A.

Do you think this helps you solve your problem?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[JAX_ND]

Hi
Many thanks for your feedback.
In fact it seems a Look-Up column cannot be combined with a person column.
The approver column is not just a name. It is in fact the profile of a person (email, etc..)
Really sorry but I am not really an IT guy.

Regards

[manuelstgomes]

Hi @JAX_ND 

No worries at all :).. Let's figure this out.

I was thinking that you needed to link both SharePoint using the Code column hence the lookup.

I think I have a solution for you...

It's based on 2 parts:

1. Trigger when there's a change
2. Update the listB with the values.

Here's a mockup. Sorry I'm not providing an example with an actual Code column but I'm using a test SharePoint instance. But I'm sure you'll understand the logic

Where you see "Title" think in your SharePoint as your "Code".

Basically we're triggering when there's a change in SharePoint A and check all items in SharePoint B that have that code to insert the person. You get the "Code" and the "Person" field to filter from the and update all of them in the "Apply to each"

Does it make sense?

If not please let me know and I'll try to detail further.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[JAX_ND]

Hi,

Many thanks for your feedback, I have tried your solution but the Person / group columns to update are not even displayed in the Update item action.

Did it work with person columns on your side?

Regards

[manuelstgomes]

Hi @JAX_ND 

You need to check in SharePoint if the Person/People are being displayed in the view. If not add them, save the view and you'll see them in Power Automation.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[v-litu-msft]

Hi @JAX_ND,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu