Relation master-detail-detail

%3CLINGO-SUB%20id%3D%22lingo-sub-2119118%22%20slang%3D%22en-US%22%3ERelation%20master-detail-detail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119118%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20three%20sharepoint%20lists%3A%20continents%2C%20states%2C%20cities.%3CBR%20%2F%3EA%20continent%20can%20contain%20multiple%20states%20and%20a%20state%20can%20contain%20multiple%20cities.%3CBR%20%2F%3EIn%20the%20states%20list%20I%20have%20a%20lookup%20field%20that%20allows%20me%20to%20specify%20the%20continent%20associated%20with%20that%20state.%3CBR%20%2F%3EIn%20the%20city%20list%20I%20have%20the%20lookup%20to%20the%20states.%20In%20this%20list%20of%20cities%2C%20when%20I%20choose%20the%20state%20I%20would%20like%20it%20to%20be%20automatically%20displayed%20in%20another%20field%20the%20continent%20associated%20with%20that%20state.%20The%20objective%20is%20to%20have%20in%20the%20list%20of%20cities%2C%20the%20state%20associated%20with%20the%20city%20and%20therefore%20the%20continent.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20without%20using%20power%20automate%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2119118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119135%22%20slang%3D%22en-US%22%3ERe%3A%20Relation%20master-detail-detail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F621339%22%20target%3D%22_blank%22%3E%40ms-jaft%3C%2FA%3E%26nbsp%3Byou%20can%20have%20cascading%20dropdowns%20in%20a%20Power%20Apps%20customised%20SharePoint%20form.%20So%20I'd%20investigate%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I have three sharepoint lists: continents, states, cities.
A continent can contain multiple states and a state can contain multiple cities.
In the states list I have a lookup field that allows me to specify the continent associated with that state.
In the city list I have the lookup to the states. In this list of cities, when I choose the state I would like it to be automatically displayed in another field the continent associated with that state. The objective is to have in the list of cities, the state associated with the city and therefore the continent.

 

Is it possible without using power automate?

 

Thanks

 

 

2 Replies

@ms-jaft you can have cascading dropdowns in a Power Apps customised SharePoint form. So I'd investigate that.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thank you. I will follow your suggestion