Hi @alie4hunt
Good Morning!!
Apologies "-) you keep saying linking Forms, but you don't link forms, you link lists (Directly or Indirectly) however I believe I understand what you want.
If I understand correctly, you want a user to use a Microsoft Form, to submit a request for leave. You want them to be able to select their Department and in doing so, you can use the Department selected in the request form, to find the proper Row in the Department List in SharePoint, and use that Manager's Details (from the Approvers Column) to kick off the Approval, correct?
Ok I would do this
1. Add a Choice field on the Request form that matches the String value(Title) in your matrix
2. Trigger the Flow (as you already have)
3. Use Get Response Details
4. Verify that the incoming "Choice Value" is not null / Blank
5. Use a Get Items (SharePoint), List (Department Matrix), and in the Filter, do
Title eq 'Insert Choice Text from Form'
6. Add a Condition to validate that the Length(Add Dynamic value property of Get Items here ) > 0
Now you should have the Row which has your correct approvers.
7. Use your People column to populate the Who it goes too
and done
If I understood what you wanted.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
