
Announcements
I am thinkin of a use case where I have folders and nested folder in a document library with many columns with data.
For example my folder and subfolders path structure is NorthAmerica/USA/Texas/Dallas.
Documents exist in 'last subfolder Folder : Dallas, this Doc Library have columns(Country, CountryID, State, StateID... etc) with metadata.
Now I have a sharepoint list with codes for Country, state etc.. USA and Texas(101 and 102) etc...
So now if I choose country USA in Doc Library column(country), I should be able to call a flow which populate the value from sharepoint list as 101 in Doc Library column CountryID, same for State, if Texas is choosen, StateID column should get data from SP list as 102..
Could anyone have a great idea? 🙂