353
I am just trying to Get Rows from SQL and then get them into the Details section of an Approval.
My thought process was
I can't figure out how to do that.
Did you ever find a solution to putting each item returned on a new line? For example, @v-yamao-msft join formula uses a semi-colon to separate each item.
I would also like to split each item onto it's own line for readability sake
Hi @schuess3 ,
Do you want to add a link in the approval details?
From the doc Use Markdown in Microsoft Flow approval requests # links, we know that HTTP and HTTPS URLs are automatically formatted as links.
I have set up the flow likes below, and the URL works properly.
Initialize an array variable named as Test.
Get rows from the SQL table, a column named “URL” included in the table.
Add Apply to each, and action Append to array within the loop, configure the value field likes below:
[ColumnName](URL)
Under Apply to each add Compose action with the following link:
Share
Report
All responses (
Answers (
join(variables('Test'),';')
Add Start and wait for an approval action, select Compose output for the Details field.
An image for your reference.
Best regards,
Mabel
