Group Ranking then moving specified number of each group to new sharepoint list

Like (0) Share

Report

Posted on 7 Jun 2023 21:12:31 by aking11

hi there! i am new to the power automate platform and am looking for guidance on where to start with this... i think it is possible, but would love some expert advice.

I have a sharepoint list that houses employee location transfer requests. I want to create a flow that will do the awarding of the requests for us. For example, an employee requests to transfer to Seattle from Anchorage, and so do 5 other employees. We determine position on the list by employee seniority. So, if I created a power app to input the number of 'openings' in each employee location can i build a flow to award that number of employee requests based on their seniority? So, lets say we have 3 openings in Seattle and 5 people on the waitlist. We would award the 3 openings to the 3 most senior employees and then the remaining 2 would stay on the list until there were more openings.

Can you point me in the right direction to begin building this flow?

Thanks for the help!!!