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:
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: