How to get AAD attribute into CRM user record using flow

(0) Share

Report

Posted on by claudiarosina

Hi,

I am pretty new to Power Automate and I would need some help.

Currently, users in D365 CRM are created by putting them into an AAD group and assigning a CRM license. So far everything works perfect. My predesessor also created a flow to add the manager attribute from AAD to CRM. Works fine as well.

Since this manager flow works well, I was thinking of automating another (custom) attribute (text only) I currently add manually when a new user in CRM is created.

I thought of something like: When a User is created in CRM and Field "ERP ID" is empty, get AAD User, take attribute "XY" and put it in "ERP ID" field. It would be sufficent to update the table once during the night ...

I tried to set it up but did not succeed, since I could not figure out the correct syntax and connectors. Could anyone help me, please? Thanks in advance 🙂

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @claudiarosina

Please find my video for getting data from Office 365 Admin portal.

https://www.youtube.com/watch?v=k7X9e4cZSSU&t=7s

Let me know if you have more queries.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

There is now a new virtual Dataverse Table where AAD users are stored.
Announcing the AAD User Virtual Table – Find and add any AAD user to your records. | Microsoft Power Apps

Was this reply helpful? Yes No
claudiarosina 12 on at

Like (0)

Report

Hi, thanks for the tipp. I had a look into this table - unfortunately the attribute I need is not in this table.

Was this reply helpful? Yes No
claudiarosina 12 on at

Like (0)

Report
Hi, thanks very much for the video. After some trial an error I updated the value on the sandbox (hurray)

I still have some questions, though:
Right now the flow works but I want to limit the List of rows, where the update is applied. Right now the flow would update the value to all users every night.

How do I write the correct query at "filter rows" in List Rows next step?
I wanted: List all records where A is empty and User is enabled. My guess was
and(fieldnamea eq null, isdisabled eq 0)
but it did not work.

A good alternative would be to query "List all records of Table XY that have been created today".

Any suggestions?

Thanks in advance 🙂

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

I assume all columns are text. If so then the filter rows should be - fieldnamea eq null and isdisabled eq '0'

Was this reply helpful? Yes No
claudiarosina 12 on at

Like (0)

Report

Firstone = text, isdisabled = boolean
Unfortunately it does not work.

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (1)

Report

Ok this works for me.
cr0be_boolean eq true and cr0be_name eq ''

Please mark as Answer if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
claudiarosina 12 on at

Like (0)

Report

Thanks, I figured the filter out.
Now I ran into another problem. Maybe you can help me again.
I have 13 rows returned and would like to insert the value "nickname" from AAD user into the user table in crm. I tested my design and I cancelled after over 1h running time. What did I wrong?
Any ideas?

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (1)

Report

You have the Apply to Each nesting incorrect. I suggest you try something like this:

Was this reply helpful? Yes No