You’re offline. This is a read only version of the page.
246
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
Analytics Department
and so and so on.
Hopefully this makes sense.
Thank you for your time.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
