Unanswered

Perform CRUD operations on a data verse table columns with look up type referencing from AAD User table

(0) Share

Report

Posted on by KrishR

431

I was building a Power Automate on data verse tables. I created a look up column referencing AAD User table in multiple lists. I'm looking to update these columns using power automate. When I try to update those columns with Email address of the user, says invalid path, odata...... . Can anyone please help me with performing CRUD operations on the columns that are referencing from AAD User table. Below are the actions I want to perform on those columns.

1. Update that column with column value from another list( column in another list is also a look up type created from referencing AAD User table)

2. Update that column with a specific user value from automate (Like Update the column with Adam@example.com)

3. Empty the column value during the flow in Power automate.

Any suggestions or help on this please?

Thank you so much in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KrishR ,

Only read operations are supported with the AADUser virtual table, see documentation here: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/aaduser-entity

If you are looking to update data that is referenced by the AADUser virtual table through flow then you would need to utilize Graph API directly in Power Automate through HTTPS connector or utilize the Azure Active Directory connector (https://powerautomate.microsoft.com/en-us/connectors/details/shared_azuread/azure-ad/) to update the data.

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @dpoggemann ,

Thanks for the quick response and that's a great relief. Was trying to find the solution for this fix.

What would be the best approach if I want to update a column that is created referencing AAD User table?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KrishR ,

The most flexible approach would be to utilize the graph API, following something like: https://social.technet.microsoft.com/wiki/contents/articles/53583.power-automate-flow-calling-ms-graph-api.aspx

This will take more work though then utilizing the pre-built connector identified above.

Was this reply helpful? Yes No