Jan 17 2019 06:43 PM
This only works if the URL you want is static aside from a data value inside your data output.
Example: http://www.microsoftflowisamazing.com/1234567/home is the URL to view ticket number 1234567, and that ticket ID is available as dynamic content in my source data output. But I want something short in my table output like the word Link for every entry that has one of these ticket IDs instead of that long URL path, and I want it clickable.
1. For my example I'm using a Kusto Query, so I add a 'Run Query and list results' for Kusto. This is my source data.
2. Add 'Create HTML table', include headers, columns are custom
3. While configuring these columns for this table, I will create one of the headers as URL, and set the Value for it as test1<IncidentId>test2
The <IncidentId> in the above URL column is the Dynamic Content object from my 'Run Query and list results' for the Ticket ID that will be part of the URL.
The test1 and test2 are two unique values I will reference and replace later to build my URL inside my output.
4. Add 'Compose', and instead of dynamic content I will use an Expression