Unanswered

Apply to each not completing

(0) Share

Report

Posted on by Mats_1997

I have a SP list of some size, and I'd like to loop over it to find the unique values in it, in this case, Avdeling, and send it to myself as a comma separated string. The flow works just fine, it just doesn't complete, and instead kills itself and doesn't do what I ask it to do.

This is my flow

The message I get is that 'Action "Append_to_array_variable' failed", which is seemingly what happens after it has iterated over 100 items and can't iterate over the 101th item for some reason??

why is this? it also tells me that no dependant actions succeeded, which doesn't in itself make much sense to me.

In advance, thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @Mats_1997

Couple of point to consider here:

1: Get Items action has default limit to 100 items so you will get only 100 items. you can change the limit by going to the Get Items settings and set pagination "on" and set "Threshold" limit to higher number (less than 5000)

2: you flow is failing in Apply To each action could you click on next failed and find the actual error and share?

Regards,

DS

Was this reply helpful? Yes No
Verified answer

Mats_1997 62 on at

Like (0)

Report

@DeepakS

Turns out the limit wasn't the issue, it was that when I tried to append the value, sometimes it was null, and PowerAutomate wasn't too happy about it, image of the issue bellow, added a condition avdeling != null and it got fixed

the limitation wasn't an issue, but I also hadn't thought about it 😉

Was this reply helpful? Yes No