Unanswered

Check if value already exists in field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi volks,

first of all: sorry, I' m pretty new to Power Automate and I'm in charge of building a ticketing support system for my team, using MS Power Automate to connect a support form in MS Forms to our teams Planner in MS Teams. So far everything is working pretty good:
A task is created with the dedicated title, in the correct bucket and with the chosen due date and priority. Tasks are even assigned to the correct team members based on the software the user hast issues with and the department the request is comming from.
But my problem is: If a user chooses plattform A and department B and but software a and department b are both maintained by team member C, Power Automate gives me this error:

The blacked out area is the ID/email address of the assignee. And the output in the Assigned User IDs-field is twice that ID.

I assume that PA can't handle the same ID twice in the field of 'Assigned user IDs'.

If I fill in the form with plattform A and department D, there is no problem because two different team members are being assigned.

So I guess before checking for the the chosen plattform/department, I need to check whether another plattform/department that assignes the same users, has already been true in previews checks. I tried something like if(contains(???), '', if(equals(outputs('get_answer_details')?[body/xxxxxxx], 'YouTube'), variables('RoleYouTube'), '')). But I my main problem is, that I don't know how to check the field I'm currently in.

I hope that makes any sense? And sorry for my bad English. 😅 If anything is unclear please ask 🙂

Additional information:
This is how I check for plattform/department and assign the dedicated team member:

if(equals(outputs('Antwortdetails_abrufen')?['body/xxxxxxxxxxx'],'YouTube'), variables('RoleYoutube'), '')

In the variable RoleYouTube I'm holding the IDs of the team members, who are responsible for YouTube, thus are being assigned.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

That looks like a lot of if expressions 🙂

I would suggest adding all of the assignees into an array, including duplicates. Then use a union expression, passing in the array of assignees twice. This will remove any duplicates. You would then use the unique assignees in your assignment field.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your quick response, sounds very reasonable!
Since I'm not too familiar with Power FX and programming in general though, could you do give a little more details on that? 😅

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Create a Compose action and rename it to something like Assignees All. Then add all of your if expressions (you should be able to copy and paste the existing expressions from your current Assigned User Ids action. Then add a semicolon between each of your if expressions.

Then add another Compose action and rename it to Assignees Unique. And within there, add the following expression to remove any duplicates, and separate each item with a semicolon.

join( union( split(outputs('Assignees_All'), ';'), split(outputs('Assignees_All'), ';') ), ';' )

You should then be able to use the output from Assignee Unique in your Assigned User Ids action.

If that doesn't work, then let me know. I'm not 100% sure what your current output is from all your expressions.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Can't believe it - seems so simple and it's working! Thanks so much! 🙂

Was this reply helpful? Yes No