Share
ReportI have a Drop Down field which list the Multiple Names of Managers within a Company. When a Manager resigns, I want to delete his name and replace with a New Manager in his place. SharePoint list have Company[Text field], Managers[Multiple Text]. I am asking the user to select a name of the Company, from a drop down list of companies, in Items property, I entered the formula - Sort(Filter('CompanyList',Status.Value="Active"),Companyname,Ascending)
then in another drop down, I am showing the List of Managers of the selected company, again drop down list.
CompanyDropDown.Selected.'Managers'
Now I want the user to select a Manager to delete from the CompanyDropDown and also add a new Manager in his place and patch the record to update the CompanyList with the replaced Manager.
How can I do that?
All responses (
Answers (
5,023
