corresponding team function to systemusers

(0) Share

Report

Posted on by piergaetano

148

I have a flow that create a record assigning ownership from other record in other table.

I use /systemusers to read the user from the source record but I do not find any corresponding function systemteams, do You know which is the correct funtion name? (i.e I tried team teams systemteams but not working)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'm not quite following your question, but "systemuser" is the table name for the Users. Adding an "s" at the end usually means that's the set name (helpful in Power Automate for assigning lookup values).
Now for a Team the table name is "team" and the set name is "teams".
If you can provide a little more context to your question I can try to help.

Was this reply helpful? Yes No
piergaetano 148 on at

Like (0)

Report
Copy link

Link copied!

This is the partial flow: if the record source has an user as owner no problem, I use function /systemusers(UID) and it works but in case owner is a team /systemusers fail so I need function that return me the owner team.

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

You would enter /teams(GUID)

from your screenshot - /teams([owning team])

Was this reply helpful? Yes No
piergaetano 148 on at

Like (0)

Report
Copy link

Link copied!

Not working
with /teams not recognized
with /team I get this assigning to record owner:
URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL.

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!
This is an example from a flow I created to do the same thing some time ago. This expression eliminates the IF statement in your flow as puts it in just the owner field.

the only difference I see is to remove the starting forward slash “/“ - so simply “teams(guid)”
if( equals( items('Apply_to_each')?['_xx_lookup_value@Microsoft.Dynamics.CRM.lookuplogicalname'], 'systemuser'), concat('systemusers(', items('Apply_to_each')?['_xx_lookup_value'] , ')'), concat('teams(', items('Apply_to_each')?['_xx_lookup_value'] , ')') )

Was this reply helpful? Yes No
piergaetano 148 on at

Like (0)

Report
Copy link

Link copied!

  "error": {
    "code": "0x80060888",
    "message": "The supplied reference link -- teams() -- is invalid. Expecting a reference link of the form /entityset(key)."

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,189 Moderator on at

Like (1)

Report
Copy link

Link copied!

Take a look at this link - it explains your issue and shows your error-
https://www.encorebusiness.com/blog/power-automate-dynamically-set-crm-optional-lookup/

Basically I believe you are passing “teams()” as the owner field without a GUID inside the parentheses. Add a ‘compose’ step before you run the update and set it to the value you are setting the owner to. Then set the owner to the output of the compose step. Perhaps the Owning Team (Value) isn’t set, so use the Owner (Value) dynamic value instead.

basically you need to ensure that compose step does say teams() with a GUID inside.

Was this reply helpful? Yes No
JHarvey 4 on at

Like (0)

Report
Copy link

Link copied!

We, too, struggled with this... the solution for us was: for TEAMS Id was /teams/GUID. (No parentheses) For a Non-Teams, its systemusers(GUID) (with parenthesis) both in the ADVANCED options of "update a row" for dataverse; Field: Owner(Owners)
via: https://www.youtube.com/watch?v=F_7M_kQ02TM

Was this reply helpful? Yes No