A single email to all users in multi-select person column, unless empty.

[AB4N]

Hi all,

I'm trying to create a flow that will send one single email to all users in a multi-select person column on SharePoint Online. The flow should only do this if the column is not empty.

At the moment my flow will successfully send the email to all, however, if there isn't anyone selected in the column then the flow fails.

I've messed around with it so much now that I'm not sure any of it even works now! I've tried "null" in the condition 2 box but that gave the same failed response. Anyone have an any suggestions?

[abm]

Hi @AB4N 

Do you want to check the multi select column SharePoint is null or not?

Thanks

[AB4N]

Hi, yes I think that is what’s required.

[abm]

Hi @AB4N 

You need to use the length. 

length(items('Apply_to_each')?['Courses']) > 0

[abm]

Hi @AB4N 

You can also use empty function

empty(items('Apply_to_each')?['Courses'])

[abm]

Hi @AB4N 

Do you need further help on this? If the suggested solution is working as expected then please mark it as solution accepted. This will help others in the community looking for solutions.

Thanks