You’re offline. This is a read only version of the page.
14
Hello,
I have a flow where I would like to update a list called Maintenance Requests from another list called Maintenance Time Off Lookup. Employee Name on the Maintenance Request is a lookup field and I would like to update Title, Supervisor Name, Foreman Name, and Department. The issue I'm having is the Maintenance Request list is not filtering correcting on the Lookup list, it only updates the last rows in the list no matter who submits a request. Any help would be appreciated. Thank you
Flow
Lookup List
Request List
The request is entered, Gets Items from Sharepoint list, but does not filter. It will only return the value in the last rows on the Sharepoint list. I would like to filter by Title and fill in the rows across.
Request Entered
Lookup List
Request Returned
Flow
In the mainanance time off lookup is there multiple rows that the filtre returns. I asumed there would be only one record that would be returned. I may not understand the issue and screenshots may help.
I created an approvers table as pictured and I added the pictured flow to the bottom of the previous pictured flow.
I first used the "Get Item" action to get the updated department value then "Get Items" to lookup the approvers from the new approver list. I used the Approver people column from that list to populate the approver email on the approval action.
If this is what you were looking for please mark it as the answer. thank you
Yes, but instead of a switch I usually setup a list that maps who the approver is based on the department. You would add one more "Get items" action to the flow that would lookup this list for the correct approver. This way if the approver changes you only have to edit the list and you do not have to touch the flow. Also if you added more departments down the road you do not have to worry about adding more to the switch.
Hello spsolutionsgrp,
Once the employee selects their name from the Request list it would populate the supervisor name, foreman name, Title, and department from the lookup list. further down it would have a switch condition on the Department Name, Maintenance, Projects, and Office for an approver. I hope this help explains better the condition of the flow.
Thank you,
BSD
Not sure I undersand completly. I thought we were looking up information from the Mainenance Time Off list based on Employee Name. How does the department fit in? Is that a seperate lookup or something that needs to be changed on this current "Get items" action to filter it down farther?
I think you may just be missing the correct value in the filter query. Should be something like the image provided.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
