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?
