Hi
I'm building a flow to process employee PTO requests. The PTO approvers are our consultants' project manager(s) which are located in a SP List; if a consultant has multiple PMs, the consultant is on multiple rows in the List with each PM on a separate row. Most consultants have only one project manager, but some (and possibly more in the future) have multiple project managers who all need to approve PTO.
The problem: I'm able to retrieve the PMs' email addresses from the SharePoint List, but I am unable to join them to the string array (variable "PM") with a semicolon separating the PM email addresses. WHen I look at the output from the Compose action, the email addresses like this:
name1@company.comname2@company.com
rather than
name1@company.com;
name2@company.com
What am I doing wrong? Thanks in advance! I'm new to this (self-taught) and Google and YouTube have not been able to help this time.
Here is the flow I currently have: