I am trying to create a solution without using Power Automate to send emails. The emails must come from a select group of users. Since I can't pull the users from a permission group without the use of Power Automate, I instead created a list that contains rows for the type of email to send and a column in each row for the users who need to receive the email.
In the OnStart property of the app, I added the following:
Set(NewRequestsEmailCollection, Lookup(Emails, ID = 1, Recipients);
This works and creates the variable which is a collection containing all the details for each user entered in the Person/Group field. Now I just need a semicolon delimited string variable of their email addresses to use as the To: in an email. I cannot find any information on how to get all the values from a specific column in this collection out of it and into a new variable in the needed format.
Any help is appreciated!
