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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,369)