
Announcements
I 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?
Hi @Anonymous,
When you say it is maintained as a separate table create another screen and show the managers list in a gallery with an edit and delete option. On that screen, you can update the managers details.
If you don't want to go out of the screen, create a popup window on the same screen implement this logic. Show that popup by clicking on a pen icon right next to the manager dropdown.