You’re offline. This is a read only version of the page.
Hi,
I have an invoice approval workflow which permits up to four separate approvers. What I want to do is send an email once per day to anyone who has invoices pending approval.
Through a series of select and compose functions, I can get the following (valid) list of people who should receive an email reminder. What I can't work out is how to extract the addresses for use in the 'To:' field of a 'Send Email' step. Any assistance would be appreciated.
This would normally be very easy, but the naming of elements within your array are different throughout the array (E1, E2 etc). So you have to use an expression. This does what you want:
In the select action the "From" should be the compose that contains your email addresses. Then put the select into text mode, use this expression:
Share
Report
All responses (
Answers (
replace(substring(string(item()),7), '"}', '')This is going to give you back a simple array that looks like this:
[
"Dxx@xxxxxxxxxxx.org.nz",
"axxxxxxxx@xxxxxxxxxxx.org.nz",
"Rxxxx@xxxxxxxxxxx.org.nz",
"fxxxxx@xxxxxxxxxxx.org.nz"
]You can then use a compose action on the output of the select:
join(body('Select'), ';')which will produce output like:
Dxx@xxxxxxxxxxx.org.nz;axxxxxxxx@xxxxxxxxxxx.org.nz;Rxxxx@xxxxxxxxxxx.org.nz;fxxxxx@xxxxxxxxxxx.org.nz;Dxxxx@xxxxxxxxxxx.org.nz;axxxxxx@xxxxxxxxxxx.org.nz;nxxx@xxxxxxxxxxx.org.nz;Hxxxx@xxxxxxxxxxx.org.nz;fxxx@xxxxxxxxxxx.org.nz;Hxxxxx@xxxxxxxxxxx.org.nz;nxxx@xxxxxxxxxxx.org.nz;axxxxxx@xxxxxxxxxxx.org.nzWhich you can use to email everyone at the same time.
Blog: tachytelic.net
YouTube: https://www.youtube.com/c/PaulieM/videos
If I answered your question, please accept it as a solution 😘
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
