I have an existing SharePoint list (Members List) and I added a Reference Member Code lookup column, referencing another SharePoint list (Membership List). Both list have a common column called Member Code and I want the new Reference Member Code column connected to the Member Code column in the second list. I tried to create a flow that reads all items from the Members List, and for each read, I did a search on the Membership List. But when I reached the Update item part, the Reference Member Code column was replaced Reference Member Code Id and it was forcing me to select a specific column value from the other list. Is this scenario possible? What should I do? I don't want to assign the Reference Member Code column manually.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
