cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDonahue
Continued Contributor
Continued Contributor

Nested "Apply to each" utilizing 2 "List rows present in table"

I seem to understand neither "loop" nor "is equal to" anymore.

I am populating a pre-filled Excel table with relevant data gleaned from another, static table pivoting on email address.

I have a static roster table (Roster) that has name and email among other columns.

I have another table for data collection (DataCollection) that has pre-filled data that includes email address.

Here is the structure of the nested loops:

nested apply to each loops.pngThe value of "value" in "Apply to each" is:
outputs('List_rows_present_ReviewingDoctorRoster')?['body/value']

The value of "value" in Apply to each 2 is:
outputs('List_rows_present_in_CCADataCollection')?['body/value']

The value in "Update a row" for "ReviewingDoctorEmail" is 
outputs('List_rows_present_ReviewingDoctorRoster')?['RDName']

In "Condition" I have:
items('Apply_to_each)?['RDEmail'] is equal to items('Apply_to_each_2')?['ReviewingDoctorEmail']

My plan is that I would:

1. loop through the roster and first grab the value for RDEmail in the first row in Roster table
2. compare the value for RDEmail with the value for each ProviderEmail in DataCollection table
3. If RDEmail = ProviderEmail then apply the name from Roster to name in Data Collection.

When I do it like this, all conditionals evaluate as "false" so nothing happens. Yes, the spelling and capitalization for emails is identical in each table.

Thank you for your assistance; it is greatly appreciated.

2 ACCEPTED SOLUTIONS

Accepted Solutions
manuelstgomes
Super User II
Super User II

Hi @BenDonahue 

 

As a "debug" mechanism, put two composes with each of the fields that you want to compare and check after running the values that you get. Probably something is getting mixed-up, and with this, you'll always see what values are being compared.

 

Can you please check if and let me know if you have any questions?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

BenDonahue
Continued Contributor
Continued Contributor

Sometimes I forget, when I find myself in situations that just make no sense whatsoever, is that I'm the idiot. Here are the two values that I should have been comparing:

items('Apply_to_each_2')?['RDEmail']
and 
items('Apply_to_each')?[ProviderEmail']

Comparing the correct values seems to have cleared up everything else.

 

View solution in original post

3 REPLIES 3
manuelstgomes
Super User II
Super User II

Hi @BenDonahue 

 

As a "debug" mechanism, put two composes with each of the fields that you want to compare and check after running the values that you get. Probably something is getting mixed-up, and with this, you'll always see what values are being compared.

 

Can you please check if and let me know if you have any questions?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

BenDonahue
Continued Contributor
Continued Contributor

Sometimes I forget, when I find myself in situations that just make no sense whatsoever, is that I'm the idiot. Here are the two values that I should have been comparing:

items('Apply_to_each_2')?['RDEmail']
and 
items('Apply_to_each')?[ProviderEmail']

Comparing the correct values seems to have cleared up everything else.

 

View solution in original post

Hi @BenDonahue 

 

Don't beat yourself up. These things happen all the time. 🙂

 

That's why setting up "debug" values in your Flow will show you right away if there's something up.

 

It's fixed.. Well done!

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (12,576)