@ks_automate When using the MS Form trigger or actions—I'd recommend using the Classic Designer. The New Designer is still buggy. Tip: Rename your action to keep your flow organized!
I would also recommend using a Manual Trigger to trigger your flow while you are building and testing your flow. I cover how to do this in this section of my YT Tutorial.
Compose Unique ID
This is optional, however for troubleshooting purposes I recommend putting your Unique Id into a Compose action.
Filter Array
You need to use the Filter Array action to filter the values returned from the the List Rows Present in a table action. For more information on how to use the Filter Array action watch this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?
Putting the Filter Array inside an Apply to Each loop is incorrect. Reason is that you are running the Filter Array action each time the Apply to Each action loops through. You might be interested in this YT Tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow
Return Item Count
Whenever I use a Filter Array action, I always like to return the count of items/rows returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow. Insert a Compose action.
Add an Expression. Use the length() function.
Select the Dynamic content tab and insert the body dynamic content from the Filter Array action into the length() function.
Run a test. Review the output of the Compose action. If a matching ID is located in your Excel table, it should return a 1.
Condition Check
Add a Condition action. Insert the output from the Compose action storing the number of rows returned in the first value field. Change the operator to is not equal to and enter a 0 in the second value field.
In the Yes branch you can add the action(s) that you want the flow to run if an item is found in your Excel Table. Insert any actions you'd like to run if there aren't any items returned into the No branch.
You might also be interested in a new YT Tutorial I recently uploaded: How to Get a Microsoft Form RSVP Response into a SharePoint List
I cover the following in this video tutorial:
✅ How to get a Microsoft Form Response into SharePoint
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form response
✅ How to Build a Microsoft Form with Conditional Fields
✅ How to used Branching in Microsoft Forms
✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✅ How to parse a Microsoft Form multiple choice response as string of text
✅ How to convert a text response to a number
✅ How to use the Switch action
✅ How to create a custom email confirmation for a Microsoft Form submission
✅ How to Create a Custom View in a SharePoint list
✅ How to use the Compose Action
✅ How to write Power Automate Expressions
Hope this helps!
