Unanswered

This output is an array. A foreach cannot be nested inside of another foreach.

(0) Share

Report

Posted on by AmitLoh-Powerap

608

I have a business requirement where for each salesforce user I need to get all opportunities closed today and send combined single email to each user combining multiple closes opportunities per user using compose function.

when I try to do it it says This output is an array. A foreach cannot be nested inside of another foreach.

Requirement-

For each salesforce user every night get all closed opportunities (close date as today) and combine those closed opportunities in a single email(per user) and send email to each user(with a list of closed opportunities with date)

How to do this?

I tried using get salesforce users and then for each get opportunities with close date as today (I can not add second condition where owner id is for each user)

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

v-monli-msft on at

Like (0)

Report

Hi AmitLoh,

It seems that your requirement cannot be achieve directly with only one Flow process, please try to separate them and create 2 flows to see if this works.

Best regards,
Mona Li

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like (0)

Report

I am trying this as well. It seems to be tricky to do it in 2 seperate workflows as I need to get user specific closed opps. data then combine and send email to each user.

Was this reply helpful? Yes No
keerthich 4 on at

Like (0)

Report

Hi,

I'm facing similar issue i.e. This output is an array. A foreach cannot be nested inside of another foreach.

can you please let me know how you handled this issue.

your inputs are highly appreciated.

Thanks
keerthi

Was this reply helpful? Yes No
parry2k 14 on at

Like (0)

Report

Any update on this how it was solved? Any input/help will be highly appreciated. This is what I'm doing:

- getting rows from sql table
- foreach for each row and then use text speach to get key phrases
- once i have these key phrases whcih are array, i need to insert into a table

since I'm unable to add foreach loop in other foreach, is there way that I can make this array a string and then insert into a table?

Not sure what is the right solution but any help will be great.

Thanks,
P

Was this reply helpful? Yes No
LozzieD 203 on at

Like (0)

Report

Another "broken by design" Office 365 feature.

Was this reply helpful? Yes No