Unanswered

Joining All outputs of Apply to Each and using in main flow

(0) Share

Report

Posted on by HMJ_Somerset

118

I have a requirement whereby people can submit a request looking for one or more type of care in one or more towns. A SharePoint list of potential providers is then filtered to return possible matches. Emails are then sent to the possible matches asking if they are interested in providing care.

I am able to filter the List with the first criteria, and then filter that output with the second criteria resulting in an output of possible matches.

These are inside Apply to Each filters.

I can see that the filters are returning the correct items, but they are fragmented inside each of the Apply to Each loops and I can only use the result inside the Apply to Each.

How do I list the outputs of the final Apply to Each filter into a single array that can be used in the main body of the flow as my source list for the emails?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

mahoneypat 1,720 on at

Like (0)

Report

You can initialize an array variable before the Apply to Each, and then add an Append to Array variable step inside the Apply to each. You can then use the array variable later in the flow.

Pat

Was this reply helpful? Yes No
HMJ_Somerset 118 on at

Like (0)

Report

Hi @mahoneypat
I have tried append to an array following the initial Apply to each Filter array but the flow fails with this error -
BadRequest. The value of type 'Array' cannot be appended to the variable 'vMatchedAreaProviders' of type 'Array'. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

What am I doing wrong?

Was this reply helpful? Yes No
mahoneypat 1,720 on at

Like (0)

Report

Looking again at your initial post, can you explain why you have the Apply to Each actions? If one person triggers the flow and a filtered list of matches is returned to them, an Apply to each should not be needed.

Pat

Was this reply helpful? Yes No
HMJ_Somerset 118 on at

Like (0)

Report

Thanks Pat,

The Apply to each is created automatically when I filter the array, but I would have added it anyway as I want all the possible matches from all of the areas selected on the form. For example someone may have selected Wellington, Yeovil and Wells on the form and so I want to filter the list of providers to pull back all providers who work in any of those requested areas.

Hazel

Was this reply helpful? Yes No