Customer experience | Sales, Customer Insights,...

Making a "Smart view"

(0) Share

Report

Posted on by Jfolsom

So I currently have two tables, users and documents. I am looking for a way to pull the users department and only show documents that have been identified to belong to that department. I have over 25 departments so making an individual view for each department is not something I want to do. So far I can I can only search on user name and not any other user attribute a user account has. Is this even possible or should I think of a different way to archive this.

All responses (2)

Answers (0)

Jfolsom 5 on at

Like (0)

Report

RE: Making a "Smart view"

let me try and clarify my question I mean ticket not document. So when a user creates a ticket using dynamics and selected a certain department I want a view to automatically pull the current logged in users department and show what tickets have tagged their department. Does that make sense?
Suggested answer

Abdul Wahab 12,083 Moderator on at

Like (0)

Report
RE: Making a "Smart view"

Hi Jfolsom,

I was facing similar issues... I created tables for all the departments. Let suppose:

Department A

Department B

Configured SharePoint integration from CRM.

In SharePoint configure access according. Let's say the user of the department can see the department folder.

On creating the record using power automate I configured the appropriate folder.