cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dude150001
Frequent Visitor

Approval on SQL with child table

I have an approval setup when a new row is inserted on a SQL table.  This table has a child table that contains details for each line item so I added a step for 'Get Rows' so I could include this detail in the approval.  Well adding this step also added a 'for each'.

 

Any ideas how I can get these child rows to send with the approval?  I just want to send a single approval for the grouping, not a seperate one for each.

1 ACCEPTED SOLUTION

Accepted Solutions
dude150001
Frequent Visitor

Figured it out.  I'm just appending the rows to a string and using markdown to format as a table in the approval email.

View solution in original post

1 REPLY 1
dude150001
Frequent Visitor

Figured it out.  I'm just appending the rows to a string and using markdown to format as a table in the approval email.

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (49,480)