Power Platform Community Forum Thread Details

I have an Array Variable that has an output of this:

[

"",

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E379A985-70EF-46A2-B4FC-3AB4E6ECF382}]",

"4/12/2024 10:13 PM",

"Error Occurred",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E379A985-70EF-46A2-B4FC-3AB4E6ECF382}]",

"",

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={5AF0E797-38EF-4696-97E2-7D9E2C14CA27}]",

"4/12/2024 5:11 AM",

"Failed on Start (retrying)",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={5AF0E797-38EF-4696-97E2-7D9E2C14CA27}]",

"",

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={55955119-4339-4F9C-8093-EAF2EB3DCCE3}]",

"4/11/2024 10:38 PM",

"Failed on Start (retrying)",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={55955119-4339-4F9C-8093-EAF2EB3DCCE3}]",

"",

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={71F27A42-617C-495E-903E-7627C35F587E}]",

"4/4/2024 2:48 PM",

"Failed on Start (retrying)",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={71F27A42-617C-495E-903E-7627C35F587E}]",

"",

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E2D08147-6631-4C8E-BE34-757F87922141}]",

"3/30/2024 12:01 PM",

"Failed on Start (retrying)",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E2D08147-6631-4C8E-BE34-757F87922141}]",

"",

"Study Distribution List Review",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={740F8E61-AECA-42A6-9C4D-86C7D75B3F89}]",

"3/30/2024 11:25 AM",

"Error Occurred",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={740F8E61-AECA-42A6-9C4D-86C7D75B3F89}]",

"",

The next step is an apply to each with a compose (Take) action. The expression for the Take action is take(skip(variables('WorkflowArray'), 2), 5) The issue I am coming across is the apply to each run 266 times but for each instance of the loop it is the same output which is the first 5 of the start of my array:

[

"Approaching or Over Due Date Notification",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E379A985-70EF-46A2-B4FC-3AB4E6ECF382}]",

"4/12/2024 10:13 PM",

"Error Occurred",

"[/global/ctp/study/_layouts/15/WrkStat.aspx?WorkflowInstanceID={E379A985-70EF-46A2-B4FC-3AB4E6ECF382}]"

]

How can I have it loop through the rest of the array? I am pretty sure I have to fix my take expression but not sure how.

Categories:

Building flows

Hi @skarthanal25

Here are the actions that help you in solving this problem.

Firstly, use "Filter array" to filter nonempty elements in the array variable. Pass the value of variable as the input of filter array action:

Click 'Edit in advanced mode' button on the bottom of this action and enter the below query in the textbox:

@not(equals(item(), ''))

Next, add "Apply to each" action and using expression with chunk() function, we will make a group of 5 elements by creating a nested array:

chunk(body('Filter_array'),5)

When we iterate, we get an array with 5 elements in each iteration. You can use index to retrieve the values of each within the group. I have used compose action to show how we can get the first value from the nested array (group). Add "Compose" action in the 'Apply to each' block and enter the below expression: