cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SpaceNudeln
Frequent Visitor

Sharepoint list: check Title for a match of user°s input

Hello! Again haha.
Long story short. Im making a PVA and i want to help my HR-Manager to perform Vacation Days changes. All Vacation Days Data is stored on Sharepoint list (first screenshot) 

4.png

 and everytime HR Manager wants to add days to the column "VacDaysUsed" (the amount of days that have been consumed during this year) he will first need to check if there is an employee named (for example) Employee 1. If there is such employee, PVA will ask HR manager how many days should be added and if NOT PVA will answer: Error, User is not found (last screenshot). 
How can Power automate check all the whole column Title (first one) and detect if there is any equal match (screenshot 2 and 3)?
I have tried by myself but everytime i enter valid Employee name it gives me back False results. 

This is my Power Automate flow 

1.png

2.png


This is my PVA Flow 

3.png



Would be very grateful if someone could help me 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
SpaceNudeln
Frequent Visitor

Ok, i figured this out by myself, thanks to the video of this guy. 
The answer is to put a Filter Query. In my case its Title eq 'Employee to be Checked' (users Input from PVA)
and also just before condition part u need to create Get item and fill this one as usual. 
Hope this will help someone 🙂 

View solution in original post

1 REPLY 1
SpaceNudeln
Frequent Visitor

Ok, i figured this out by myself, thanks to the video of this guy. 
The answer is to put a Filter Query. In my case its Title eq 'Employee to be Checked' (users Input from PVA)
and also just before condition part u need to create Get item and fill this one as usual. 
Hope this will help someone 🙂 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,573)