How to Generate Sequential Approval Flow with Filter Query

(0) Share

Report

Posted on by RR-13080951-0

Dear All

Please help me to overcome the eror and confusing things

i want to make a sequential approval flow with filter query from get items but i got error and confused

i got three sharepoint to help me

1. Document approval where i input my data to start the flow

2. Type Approval fills with two type approval

3. Detail Approval fills with the type of approval, approver, and approver order

please help me how to input the filter query

Categories:

Building flows

Screenshot 2025-0...

I have the same question (0)

All responses (7)

Answers (0)

Tomac 3,951 Moderator on at

Like (0)

Report

@RR-13080951-0 Please show screenshots of your whole flow with all actions expanded so we can see what you're currently working with.

Was this reply helpful? Yes No
RR-13080951-0 24 on at

Like (1)

Report

@Tomac

this is the whole flow, thank you

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Can you clarify the purpose of the Get items action in your flow? Specifically, how does it relate to the approval process triggered when a new item is created? If the approval is based on the item from the trigger itself, it seems the Get items action may not be necessary. It would be helpful to understand why it's included and how it contributes to the overall logic of the flow.

Was this reply helpful? Yes No
RR-13080951-0 24 on at

Like (1)

Report

@David_MA

so the get items is to use the approval filter

i have two type approval :

1 level approval

2 level approval

the get items is use to filter the approval

i learn it from youtube

https://www.youtube.com/watch?v=F819U_l07qI

but got confused with the error that happen

thank you

Was this reply helpful? Yes No
Tomac 3,951 Moderator on at

Like (0)

Report
@RR-13080951-0 Your flow looks correct, but if you're getting an error then we still have a problem.

After your Select action but before your Start and wait for an approval action, please add a Compose with the input of your Select. Run the flow again, let it fail, then post the output of the new Compose action here along with the error message you're getting. You can change the email addresses to fake emails (person1@contoso.com, person2@contoso.com, etc) but we will need to see the structure of your array. It should look like this in the output of your Compose:

[ { "assignedTo": "person1@contoso.com" }, { "assignedTo": "person2@contoso.com" } ]

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

I think I see the problem based on your screen shot of the flow and what Tomac is asking you to do. You are using the output of the select action to assign the approvers, which is returning data as shown in what Tomac posted. The approval action needs the values to be semicolon separated (person1@contoso.com; person2@contoso.com), but your are passing it an array. You need to use a join expression -- join() -- on the output of the select action, and join the values with a semicolon.

However, if you do this, you need to ensure that your process will always return more than one person otherwise your flow will fail saying that the join was done on an object instead of an array.

Was this reply helpful? Yes No
Tomac 3,951 Moderator on at

Like (0)

Report
@David_MA Your array format is for all approvers to be on the same step:

[ { "assignedTo": "person1@contoso.com;person2@contoso.com;" } ]

To have each approver be on a sequential setup, the array needs to be formatted as:

[ { "assignedTo": "person1@contoso.com" }, { "assignedTo": "person2@contoso.com" } ]

Since @RR-13080951-0 is looking for sequential approvals, the format they're attempting is correct but we will need to see what's being pulled from the SharePoint list to ensure it's coming in the correct format.

Was this reply helpful? Yes No