Auto assign user to items

(0) Share

Report

Posted on by brk108

Hi all,

Using power automate needs to assign a user to items automatically.

There will be two tables in Dataverse.
First table have company and users as 2 columns.

Second table have case,company,date received,Assigned to as 4 columns .

Now we need to design a flow . It will auto assign cases to users who belong to same company as case.

For example: In first table Ashok, Krishna belongs to process CAS and Suresh, Ramesh belongs to HPL
In second table there will be 4 cases.
Case1 belongs to CAS
Case2 belongs to HPL
Case3 belongs to CAS
Case4 belongs to HPL

Now our flow will get all cases where assigned to column is blank.

Now based on first table it will assign user to that particular case .

For eg: case1 and case3 will be assigned to Ashok and krishna as they belongs to CAS cases.

please help on this

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just use Company in Table 2 to filter Table 1 (filter query where Company eq 'xxxx', where xxxx is the dynamic content for "Company" from the submission), and retrieve the associated Person. Then, update Table 2 with the associated Person which will now be accessible dynamic content from Table 1, People column,

Was this reply helpful? Yes No
brk108 68 on at

Like (0)

Report
Copy link

Link copied!

Thanks for reply. Can I get this in Power automate flow. Please. Since I am beginner

Was this reply helpful? Yes No
Shilpa99 2 on at

Like (0)

Report
Copy link

Link copied!

I have a similar query, any help would be highly appreciated
I have 2 tables
1. Client Table: Client table with client name and users who will be working on that particular client, 1 client can have different users associated to it
Client 1- User 1
Client 1- User 2
Client 1- User 3
Client 4- User 1
Client 5- User 1
2. Work table: Case created for clients from client table
Case1 - Client 1
Case2 - Client 1
Case3 - Client 1
Case4 - Client 1
Case5 - Client 1
Based on the client for which the case is created it should get auto assigned to users
eg. in the above case all 5 cases are of client1 soo it should be allocated to User1, user2, user3 (2 cases for user 1, 2 cases for user2 and 1 for user3 )
Is there any way via flows this can be implemented?

Was this reply helpful? Yes No