Power Platform Community Forum Thread Details

Hi all,

I am trying to make a leave approval using forms but I need help on how to make sure that the name filled in the form is in the employee master list that I have setup for verification purposes. Hoping for your help.

Categories:

Building flows

Since you don't provide details on what you're doing or show your flow, I need to guess. With that in mind, if your employee master list is in SharePoint, use a Get items action with a filter query on the field in the list that aligns with your question in the form. You can then use a length expression to see if any items were returned (ideally just one if each employee is in the master list once and you don't have more than one person with the same name).

Here is a good post on how to use a filter query on a get items action: How to Use Power Automate Get Items Filter Query + 8 Examples - Enjoy SharePoint

And here is a post on the length expression: Power Automate length() Function [How to Use] - Enjoy SharePoint

If this isn't what you need, please provide more details in your post and show what work you've done so far in your flow.