Forum Discussion
How to assign a value based on another column?
Dear Experts,
I have two SharePoint lists like so:
If in list A, I enter values for the columns: Country, Color, GB
then list B will be updated with corresponding values.
Can you please share with me how to assign value in List B based on another column from List A?
Thanks a lot!
ROSE
You need to do this with a flow in Power Automate.
2 Replies
I agree with Rob_Elliott, but I'm not entirely clear on your use case. l wonder if lookup columns might be useful to 'connect' your lists dynamically.
Some info for you to consider:
https://support.microsoft.com/en-us/office/create-list-relationships-by-using-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632
https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/You need to do this with a flow in Power Automate.
