Jul 24 2020 11:40 AM
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 department attribute directly from the "Created by" element. I thought I could use the "contains" value, but that can only be used on non-indexed fields. Is there a special syntax I can use to access this attribute of the creator in the filter by field? Perhaps I am out of luck, but since Flow can access those attributes, I thought I might be able to use something similar on filter.
Jul 24 2020 04:26 PM
Jul 24 2020 10:17 PM
Solution@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:
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.
Jul 27 2020 02:38 AM
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.
Jul 27 2020 03:58 AM
Jul 24 2020 10:17 PM
Solution@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:
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.