I am trying to send out a weekly calendar notification to a few emails every Monday. The email will just list the names of the people who are on vacation for the week. I am able to query the list from Monday-Friday only, but my problem is that the query returns a list of names in their raw "person or group" form. So I get a ";" delimited list of people that looks like:
i0#.t|ttcperson1;i0#.t|ttcperson2;i0#.t|ttcperson3 etc...
Normally, to display the persons name without all the junk, I would set a new "person or group" variable equal to the list variable and choose "display name", but in this case there are many names.
My first idea was to loop through this list and at every index set a variable to be the display name of the current index but I have not had any luck with this.
Any ideas would be amazing!
