Forum Discussion
Solved
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 plea...
You need to do this with a flow in Power Automate.
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/