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.
Solved! Go to Solution.
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:
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
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:
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
Your solution works! Thank you.
Follow-up, if i wanted to put each URL on a new line, how might i alter this to accomplish that?
Thanks
Matt
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
User | Count |
---|---|
95 | |
48 | |
21 | |
19 | |
18 |
User | Count |
---|---|
137 | |
54 | |
42 | |
40 | |
30 |