Hi Guys,
Would appreciate a hand with a flow I can not work out.
I have created a "when a new response is submitted" triggered flow. In the MS Form that triggers the flow, Question 1 is in check-list format and asks the user to select who is the sender of the form. The answer to that question will determine what data to use in a row in an excel table to later populate the email signature in the email. The flow is successful but it sends multiple emails from all senders listed in the excel table instead of only the one I selected in the form.
I have asked ChatGPT many times and can not solve the problem. It seems to revolve around the Filter Array. ChatGPT tells me to add a Compose, but doesn't resolve the issue.
Note: Currently the email comes from my email account, but that is just for testing until I iron this out.
Please see screen shots of the flow in edit mode and the actions details:
Would appreciate some help. :)