2.) The flow creates the sharepoint item, then at the end of the flow there is a look up where the flow checks which module is used and then checks the additional sharepoint list, to see who is assigned to the Module.
3.) Mail gets send to the responsible persons (keyusers) of the module (In this case a mail to Person A and B)
Our current solution looks like this:
After the Sharepoint item is created, we use the "get items" as well as the selct function to get the content of the sharepoint list with the responsible Keyusers.
Afterwards we use the filterarray function to get only the Keyusers of the module which is related to the forms request
Next step is the Compose Action where we extract the mail of the Keyuser of the module
Lastely we send an email to the Output of the compose Action
The problem with that flow is, that it does not send on joined mail, but it sends out 20 (amount of moudles in the list) mails to the responsible Keyusers.
How do we need to adjust our flow, so that we are just sending out one email to 2,3,xyz Keyusers who are listed in the sharepoint responsible list.
Best regards,