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)
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
This is my PVA Flow
Would be very grateful if someone could help me 🙂
Solved! Go to Solution.
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 🙂
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 🙂
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
50 | |
29 | |
28 | |
24 | |
20 |