Answered

sequential approval with dublicate approvers in step / why?

(0) Share

Report

Posted on by ChristianW

I have created a workflow that is based on a sharepoint list. It collects elements matching the todays date with a reminder date column.

After that I need to create an array (VarInitiate - Type Array - empty). For each item found it has to collect 5 contacts (email adresses). Before collecting the contacts I am setting the array to empty []. Due to the fact that Power Automate can only handle 12 columns look-up columns I had to add fixed values for two contacts. All collected emailadresses are formatted into the same format with

toLower(trim(items('For_each')?['AnsprechpartnerOperativ/Email']))
 
After that I am using the union-function to remove dublicate emailadresses
 
union(variables('EindeutigeAP'),variables('EindeutigeAP'))
 
The output of the union function I am using for a sequential approval with these Emailadresses and "assignedTo" - "current item"
  "inputs": {
    "from": "@outputs('Duplikate_Entfernen_(Dataop_-_Verfassen)')",
    "select": {
      "assignedTo": "@items('For_each')"
    }
  },
  "runAfter": {
    "Duplikate_Entfernen_(Dataop_-_Verfassen)": [
      "Succeeded"
    ]
 
The input to the sequential approval is clear - no dublicates. Unfortunately the approval does not run because the error shows up:
 
Bad request. Error Code: DuplicateApproversInSteps.
 
The inputs are the following:
 
And the first one is the creater of the workflow.
 
Hopefully someone can help.
 
 

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The union should be removing the duplicates. Can you show your flow and the configuration of the approval action. It will also help to clarify if the approval action is within the apply to each action.

Was this reply helpful? Yes No
ChristianW 8 on at

Like
a
(0)

Report
Copy link

Link copied!

"Dear David,

thank you for your reply.

Well the union does the job. The screenshot I shared is the input to the sequential approval. Allthough it puts three different Emailadresses, the mistake with "Bad request. Error Code: DuplicateApproversInSteps." occurs.

I even use with adding the VAR the formula " toLower(trim('name@email.com')) in order to avoid typing mistakes with letters.

Thank you for your help.

Best regards

Christian

Was this reply helpful? Yes No
ChristianW 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Here are the mission screens.

Meanwhile I have discovered that the matches found (items) are put 3 times to the approval. So if he finds 3 unique Emailadresses it seems the flows puts it to the approval 3 times... This would clarify why there are duplicate approvers. But still did not figure out the reason.

Looking forward to your reply

Was this reply helpful? Yes No
ChristianW 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Issue solved

The select funktion had the argument foreach('item()'). It needed to be changed to '(at)item()' and then the unique function works well

Was this reply helpful? Yes No