Ideally, I would love to use jQuery/js for this. I don't know how to use Powershell.
In my SharePoint Online App, I have 2 Lists
- An Item List called 'Cities', with a Title field. Each item's Title field is the name of a City.
- A Document Library called 'CityDocs'. The 'CityDocs' Document Library has a Lookup Field called 'CityId', which is populated by the 'City' Item List.
I have made a Site Page with (2) Web Parts:
Web Part 1. Document Library LVWP called 'CityDocs' (the name of the Document Library) Web Part 2. List Filter whose values are populated values by an Item List called 'Cities'
The Scenario When a City is selected in the List Filter WP, I'd like any documents that are dragged into the Document Library WP to have the value in the 'City' List Filter WP applied to the new Document's 'CityId' column.
Example The user has selects 'Charleston' in the List Filter WP. The user then drags a new document into the Document Library WP. The empty 'CityId' column is automatically populated with the value 'Charleston'
Thanks a lot!