Forum Discussion
Solved
Filtering a view using the "created by" department
Hi all, I have a weird one for you. In a list, I want to create a view by filtering when the department of the creator of an item is equal to a specific department. And I want to get the value of the...
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.
Unfortunately no there is no way to get this info in the view options. One approach you can try is built a Flow and fill out the value when new item is created. Then create a view that group by the department column. Hope this help.