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.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,016)