Forum Discussion
Filtering a view using the "created by" department
shawn_fielding, There is a no way you can directly select a department of user from Created by field in "Filters" section of view settings.
As you know, you can get these details of user in Microsoft flow/Power Automate easily, try below steps to achieve this:
- Create a single line of text field ("Department") and make it hidden from list forms.
- Create a flow on item creation event.
- In Flow, get the department of user from Created by field and set its value to newly created Department field.
- Create a view and add filter on the Department field.
Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.
The one draw back to this solution is that it only fires on item creation.
I'd add an additional step to this to cater for records or items that are already present in the list. Use the steps below but add them to a workflow that kicks off at a scheduled time and iterates through each item in the list. When it concludes you'll have a list that's fully completed and will continue to update the Department field.
