Allowing multiple selections (people) breaks my flow

[olliehiggins]

I have built an audit action tracker in SharePoint Lists, and built a flow to send out monthly notifications asking the action owners to update. In some instances, there will be more than 1 "owner" who needs the monthly notification. If I allow multiple selections in the action owner column, the flow does not work. The error msg is on the 'Get items' element i.e., right at the start: "Encountered internal server error. The tracking Id is '655b32cd-f5df-4531-ab61-34b4439cc922'".

A manual workaround I have at the moment is to add a second column: secondary action owner and I've built a secondary flow which sends out an email to this secondary action owner as per the original flow. But then my issue is that this flow doesn't work if there are blanks in the secondary action owner column, so for actions where there is only 1 action owner, i have had to insert the same action owner in both columns in order to get the flow to work. This sends out 2 emails then - some people will receive the same email twice, which isn't the end of the world, but not ideal. Another manual workaround i thought of was to create a dummy email account to send the secondary action owner emails where there isnt a secondary action owner... but this feels like manual workarounds on manual workarounds - is there something obvious i'm missing?

[v-liwei-msft]

Hi @olliehiggins 

Could you please tell me:

Is your situation that when there is only one action owner, the secondary action owner is empty, and the empty field causes the flow to report an error? 

You can add a condition to check if the secondary action owner is empty, send an email to the action owner if it is empty, and send it to the secondary action owner otherwise.

I have made a test for your reference:
1.

2.

Best Regards,

Levi

[olliehiggins]

Thanks - yes you have described the situation accurately. The above solution hasn't quite worked though, as I now end up sending loads of emails, instead of just the one summary email.

Someone people have multiple actions on my action tracker, so rather than send 1 email per action, the flow i've created effectively isolates the unique email addresses and sends each action owner their total actions, in a neat table, summarised by overdue, due in the next 30 days and due in the next 90 days. I've screenshotted the full flow below in case it helps; it's a bit unwieldly and i appreciate this might not be the most efficient way of getting to this point as i'm a self-confessed novice of Power Automate: