Assigning Records to Dataverse teams and users

(1) Share

Report

Posted on by Farhanftp

Hi All,

I am trying to assign records in Dataverse table to Users and teams. I was able to find Team and User lookup columns created by default, but not able to edit that.

Anyone have done this before?

It would be great if I can do the same from the Power Apps as well.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

D_D 107 on at

Like (1)

Report

Hello Farhanftp,

you can edit the data in Excel using the Microsoft PowerApps Office Add-in. Maybe you have to install it first. There you can set the values for e.g. the Owning Team (Lookup) by selecting a Owning Team (Lookup) cell and then selecting a ownerid or Team Name. I'm not sure if ownerid or Team Name should be used. Then you can publish your changes to dataverse. Be careful when using the Office Add-in! I suggest to test it first with a new created table and get sure everything works like you want.

--------------------------------------------------------------------------------------
If this helps you or solved your question, please like or mark this as an answer.
Best regards, David

Was this reply helpful? Yes No
KFlanagan 16 on at

Like (2)

Report

Hi When it comes to assigning Records in Dataverse.

The User or Team GUID you use also needs to have the proper security roles to read that table of the row you are trying to assign.

How many records are you trying to assign? There is a few different options to work through depending on the full use case:

- XRM Toolbox

- Assign in a model driven app

- Assign in the advanced find popup window

Best,
Kevin

Was this reply helpful? Yes No
Farhanftp 79 on at

Like (1)

Report

@KFlangan,

I have tables with different sizes ranging from 100+ records to 5000+ records.

It would be really great to identify the best solution. If XRM Toolbox is not from Microsoft, I am afraid the remaining two are the only options. Could you provide a bit more details?

Was this reply helpful? Yes No
Farhanftp 79 on at

Like (2)

Report

@D_D,

Due to admin restrictions, I cannot open the dataverse table in excel. Need to go with another solution.

Was this reply helpful? Yes No