I have a SharePoint list with 3 columns: Title (Text), Employee (Person), and EmployeeName (Text). Every time someone creates an entry by filling only the first two columns, I want to create a flow which automatically extracts the 'DisplayName' of the Employee, and updates the EmployeeName column of the item. Note it's important that Employee column allows multiple values.
I created a flow where when an item is created, it grabs the item and updates it, like so.
This works fine when there's only one item in the Employee column, and when there's multiple items it only grabs the last Employee to update the EmployeeName column. How can I update the EmployeeName column using all Employee entries in that item?
