cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MrDannyHarry Helper II
Helper II

ForAll SQL and HTML text

Hi All,

 

I want to run a ForAll function on a SQL table.

My table has a list of groups and I want to print those Groups in between h1 tags on a HTML text box.

 

For Example:

group_name
Group 1
Group 2
Group 3

 

HTML text to show:
Group Name: Group 1

Group Name: Group 2

Group Name: Group 3

 

Hopefully I have explained this the best I can!

 

Many Thanks!

Danny

1 ACCEPTED SOLUTION

Accepted Solutions
MrDannyHarry Helper II
Helper II

Re: ForAll SQL and HTML text

Managed to do this with a Concat function

 

 

Concat(
'[dbo].[q_groups]',
"<h3>" & group_name & "</h3>"
)

 

 

View solution in original post

1 REPLY 1
MrDannyHarry Helper II
Helper II

Re: ForAll SQL and HTML text

Managed to do this with a Concat function

 

 

Concat(
'[dbo].[q_groups]',
"<h3>" & group_name & "</h3>"
)

 

 

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,955)