Answered

Adding a new user to a certain Tag based on his Office Location

(0) Share

Report

Posted on by 0carion

Hello Comunity,

Im trying to create a power automate flow, which triggers on "when a user is added to a certain team". The flow is supposed to get the Profile from the User and read out the officeLocation. Than it should add the User to a tag, which has the same name as his office location (e.g. the user works in berlin, so he is added to the tag called "berlin".)
The flow is simple enough:

This runs into the following Error :

After some trial and error, i figured out that the tag ID is indeed NOT the tag display name. If i choose the Tag manually, it would work, but this needs to get automated.
Here is a working example:

As you can see, the Raw Input is obviously not the same for the Tag ID. Can i somehow work around that?
I figured something like: Get all Tags from the team -> Read out Tag ID's -> Match Tag Display Name with users officeLocation -> Convert users officeLocation into Tag ID -> Done. Is there a way to make this work? I was not able to figure it our.
Thank you in advance!

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 32,852 Most Valuable Professional on at

Like (1)

Report
Re: Adding a new user to a certain Tag based on his Office Location

Hi @0carion,

You could use the approach you suggested. List the tags, filter for the one which has the same displayName as the Office location and lookup the id of it.

Below is an example.

Use this expression as a custom value for the Tag id:

first(body('Filter_array'))['id']

Was this reply helpful? Yes No
0carion 14 on at

Like (0)

Report

Re: Adding a new user to a certain Tag based on his Office Location

Hi @Expiscornovus !

Thank you for you very quick help!The flow seems to work, there are no errors and the outputs are correct. But the user is still not in the tag for some reason. Do you have an idea why thats happening?

Was this reply helpful? Yes No
Expiscornovus 32,852 Most Valuable Professional on at

Like (1)

Report

Re: Adding a new user to a certain Tag based on his Office Location

Hi @0carion,

The 200 response suggests that it should have worked. Maybe your Teams client is caching something and it is a timing issue?

Have you tried it in Teams in the browser or otherwise signing out of the Teams Desktop client and signing back in to see if that makes a difference?

Was this reply helpful? Yes No
0carion 14 on at

Like (0)

Report

Re: Adding a new user to a certain Tag based on his Office Location

I created a user called "TestTag", gave him the office Location "München" and created the Tag "München". After I built the flow, I added him to the team in teams in my browser. Singing in and out of my account did not work, and singing into the "TestTag" account also made no difference so far. BUT!
I tried to build in a 2 minute delay between user Joining and grabbing his information and it worked! Thank you for your help!

Was this reply helpful? Yes No