cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Misa
Kudo Kingpin
Kudo Kingpin

Creating dynamic URL in an HTML table

Hello and happy Thursday.

 

I have a flow that will recur everyday.  It will check the list for new jobs and it will send out a sort of newsletter.  The jobs are tags with 1 of 5 departments.  I created a Compose to filter out based off of department chosen.  What i would like to do is create a custom hyperlink using a link name composed of 5 different columns. 

 

For the Compose Expression Inputs:  equals(items('Apply_to_each')?['accountFSO'], 'Analytics')

 

I created a variable (called linkFSO) that would concat the hyperlink name using the below formula: 

Concat(triggerBody()?['projectTitle'],' // ' ,triggerBody()?['TheLevel'], '// ',triggerBody()?['Clearance'],' // ',triggerBody()?['LocationCity'],', ',triggerBody()?['LocationState'],' // ',triggerBody()?['Remote'])

 

In the Select HTML table value i use 

Concat(<a href="(triggerBody()?['ReqUrl']">Outputs('linkFSO')</a>

 

What i would like to happen is that it will pull all of the items listed by department, group them and create hyperlinks using information from 5 columns.

 

ex:  

Cyber Department

  • Title of Job / Job Level / Clearance / Location / Work from home <-- would link using a column value that contains a hyperlink
  • Title of Job / Job Level / Clearance / Location / Work from home
  • Title of Job / Job Level / Clearance / Location / Work from home

Analytics Department

  • Title of Job / Job Level / Clearance / Location / Work from home
  • Title of Job / Job Level / Clearance / Location / Work from home

and so and so on.

 

Hopefully this makes sense.

 

Thank you for your time.

 

JobOpp.PNGJob1.PNGJob3.PNG

 

 

 

2 REPLIES 2
SandyU
MVP

Hi @Misa 

 

What result are you getting instead of what you are expecting...? Or are you getting an error at some point? I'm unsure what your question is 🙂 

 

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


@SandyU 

 

Hi Sandy, when i try to update the equation it says that it's not valid.  I got the idea from John Liu's youtube video on creating a Complex HTML table with Hyperlinks and it didn't work.

 

I have a Sharepoint list where employers list job openings.  They submit to the list on a daily basis.  At the moment, the job listings are manually added to an email newsletter and sent out to a distro list.  The job listings are grouped by 5 departments.  The hyperlinks are created by taking the values of 5 columns and merging them together.  So it would look like Column 1 // Column 2 // Column 3 // Column 4 // Column 5.  The links would use a URL supplied in another column of the same item.

 

I used the following formula to create the hyperlink:  

Concat(<a href=\"(triggerBody()?['ReqUrl']">Outputs('linkFSO')</a>

linkFSO =  Column 1 // Column 2 // Column 3 // Column 4 // Column 5 using the Compose Action

 

Ultimately they would like to automate it this process.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,823)