Forum Discussion
Get data from one list to another
hgalfre Using SharePoint default lookup column will not work in your case as person column cannot be extended using lookup.
So, correct approach will be using power automate flow like you are doing. Can you show us how you configured your flow currently?
When you use Get Items action on Regions list, you should be able to get the person column values from dynamic content.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi ganeshsanap !
Thanks for your help.
So my Sharepoint is in French, I'll try my best to translate appropriately.
I'll enclose some screenshots as well.
My power automate flow right now is:
1- When an item is created or modified (pic enclosed; capture 1)
>With the address of the sharepoint and the name of the contact list
2-Get item (capture2)
>With the address of the sharepoint (same for both lists) and the name of the region list. And the ID from "when an item is created or modified"
3-Update item (capture 3 & 4)
>With the address of the sharepoint, the name of the contact list, the ID from "Get item"
>and in the column where I want the salesman name; the link to the person column from the region list.
There are several choices (I guess because it's a person column so it can get all the company's info), I chose the one that doesn't have any word attached to it (last one). I guess I could also choose DisplayName, but that doesn't solve my problem...
When I save it, I get a warning that I may get an infinite loop.
And when I test it, I don't get any salesman name.
Thanks for your help!
- Hi ganeshsanap ! hopefully you can help me 😞
