Unanswered

Combine 3 separate email addresses after checking for null values

(0) Share

Report

Posted on by tagustin2020

Hello,

I'm new to Power Automate and have a fairly tricky request I'm wondering if you can advise me on. I have 3 separate single line of text fields in my SharePoint list.

Record Owner Approver Email
Business Management Approver Email
Quality Approver Email

I'm told that there will sometimes be only one approver (e.g. Record Owner or BM or Qual), sometimes there will be 2 (e.g. Record Owner and BM) or all 3 emails will be filled in.

I figure I need to check the fields for null values and then concatenate the strings that are not null separated by a semi-colon before I can then insert the string (or array?) variable into my 'Start and Wait' for an approval step.

I've been scouring the internet and haven't been able to find out how to do this combination of steps. If someone in the community could help guide me through it I would be super grateful. Thanks!

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (1)

v-liwei-msft on at

Like (2)

Report
Hi @tagustin2020

Please try:

concat(if(empty(items('Apply_to_each')?['RecordOwner']),'',concat(items('Apply_to_each')?['RecordOwner'],';')),if(empty(items('Apply_to_each')?['BM']),'',concat(items('Apply_to_each')?['BM'],';')),if(empty(items('Apply_to_each')?['Qual']),'',concat(items('Apply_to_each')?['Qual'],';')))

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@tagustin2020

What you can do is that you can initialize an Emails Variable as below and then sequential condition to check if the value of an email field is not null then you use the Append to an array variable, you can repeat this for all of your 3 fields and then pass the variable to the wait and approve step

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@Mira_Ghaly
@v-liwei-msft

Hello Mira and Levi,

Thank you both for your kind support! I think both suggestions are great. I'm marking Mira's as the solution as it might be a little a little easier to avoid syntax mistakes using the method she proposed. That being said, I will definitely be saving both approaches in my notebook as I'm always keen to increase my expression writing skills.

I hope you both have a wonderful weekend!
Teresa

Was this reply helpful? Yes No