vanity URL names inside table output

%3CLINGO-SUB%20id%3D%22lingo-sub-320562%22%20slang%3D%22en-US%22%3Evanity%20URL%20names%20inside%20table%20output%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320562%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20only%20works%20if%20the%20URL%20you%20want%20is%20static%20aside%20from%20a%20data%20value%20inside%20your%20data%20output.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CA%20href%3D%22http%3A%2F%2Fwww.microsoftflowisamazing.com%2F1234567%2Fhome%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.microsoftflowisamazing.com%2F1234567%2Fhome%3C%2FA%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20the%20URL%20to%20view%20ticket%20number%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E1234567%3C%2FSTRONG%3E%2C%20and%20that%20ticket%20ID%20is%20available%20as%20dynamic%20content%20in%20my%20source%20data%20output.%20But%20I%20want%20something%20short%20in%20my%20table%20output%20like%20the%20word%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ELink%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efor%20every%20entry%20that%20has%20one%20of%20these%20ticket%20IDs%20instead%20of%20that%20long%20URL%20path%2C%20and%20I%20want%20it%20clickable.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20For%20my%20example%20I'm%20using%20a%20Kusto%20Query%2C%20so%20I%20add%20a%20'%3CSTRONG%3ERun%20Query%20and%20list%20results%3C%2FSTRONG%3E'%20for%20Kusto.%20This%20is%20my%20source%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20Add%20'%3CSTRONG%3ECreate%20HTML%20table%3C%2FSTRONG%3E'%2C%20include%20headers%2C%20columns%20are%20custom%3C%2FP%3E%0A%3CP%3E3.%20While%20configuring%20these%20columns%20for%20this%20table%2C%20I%20will%20create%20one%20of%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eheaders%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eas%26nbsp%3B%3CSTRONG%3EURL%3C%2FSTRONG%3E%2C%20and%20set%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EValue%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efor%20it%20as%26nbsp%3B%3CSTRONG%3Etest1%3C%2FSTRONG%3E%3CINCIDENTID%3E%3CSTRONG%3Etest2%3C%2FSTRONG%3E%3C%2FINCIDENTID%3E%3C%2FP%3E%0A%3CP%3EThe%26nbsp%3B%3CSPAN%3E%26lt%3B%3CSTRONG%3EIncidentId%3C%2FSTRONG%3E%26gt%3B%20in%20the%20above%20URL%20column%20is%20the%20Dynamic%20Content%20object%20from%20my%20'%3CSTRONG%3ERun%20Query%20and%20list%20results%3C%2FSTRONG%3E'%20for%20the%20Ticket%20ID%20that%20will%20be%20part%20of%20the%20URL.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%26nbsp%3B%3CSTRONG%3Etest1%3C%2FSTRONG%3E%26nbsp%3Band%26nbsp%3B%3CSTRONG%3Etest2%3C%2FSTRONG%3E%26nbsp%3Bare%20two%20unique%20values%20I%20will%20reference%20and%20replace%20later%20to%20build%20my%20URL%20inside%20my%20output.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E4.%20Add%20'%3CSTRONG%3ECompose%3C%2FSTRONG%3E'%2C%20and%20instead%20of%20dynamic%20content%20I%20will%20use%20an%20Expression%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CSTRONG%3Ereplace(actionOutputs('Create_HTML_table')%2C'test1'%2C'%3CA%20href%3D%22%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.microsoftflowisamazing.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.microsoftflowisamazing.com%2F%3C%2FA%3E')%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3Ethe%26nbsp%3B%3CSTRONG%3ECreate_HTML_table%3C%2FSTRONG%3E%26nbsp%3Bin%20this%20expression%20is%20the%20name%20of%20the%20item%20in%20step%202.%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3Ethe%26nbsp%3B%3CSTRONG%3E%3CA%20href%3D%22http%3A%2F%2Fwww.microsoftflowisamazing.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.microsoftflowisamazing.com%2F%3C%2FA%3E%26nbsp%3B%3C%2FSTRONG%3Ein%20this%20expression%20is%20the%20part%20of%20my%20URL%20that%20precedes%20the%20IncidentId%20value.%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3E5.%20Add%20a%20second%20'%3CSTRONG%3ECompose%3C%2FSTRONG%3E'%20(default%20it%20will%20be%20called%26nbsp%3B%3CSTRONG%3ECompose%202%3C%2FSTRONG%3E.%20)%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3Eand%20again%20instead%20of%20dynamic%20content%20I%20will%20use%20another%20expression%20to%26nbsp%3Bbuild%20the%20second%20half%20of%20my%20URL.%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CSTRONG%3Ereplace(actionOutputs('Compose')%2C'test2'%2C'%2Fhome%22%26gt%3BLink')%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSTRONG%3Ethe%20Compose%20in%20this%20is%20the%20first%20compose%20name%20we%20created%20in%20step%204%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3CDIV%3Ethe%26nbsp%3B%3CSTRONG%3E%2Fhome%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20the%20closing%20text%20in%20my%20URL%2C%20the%26nbsp%3B%3CSTRONG%3ELink%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Eis%20whatever%20my%20want%20my%20vanity%20URL%20name%20to%20be.%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E6.%20For%20my%20purposes%2C%20I%20now%20add%20a%20'Send%20an%20email'%20and%20include%20the%20dynamic%20content%20value%20for%26nbsp%3B%3CSTRONG%3ECompose%202%3C%2FSTRONG%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3EThis%20will%20in%20turn%20be%20my%3CSTRONG%3E%26nbsp%3BHTML%20table%3C%2FSTRONG%3E%2C%20that%20includes%20all%20the%20data%20from%20my%3CSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EKusto%20Query%3C%2FSTRONG%3E%2C%20and%20a%20short%20value%20of%3CSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3ELink%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Einstead%20of%20the%20long%20URL%26nbsp%3B%3CSTRONG%3E%3CSPAN%3E%3CA%20href%3D%22http%3A%2F%2Fwww.microsoftflowisamazing.com%2F1234567%2Fhome%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.microsoftflowisamazing.com%2F1234567%2Fhome%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%2C%20for%20each%20item%20inside%20my%20data%20set%20that%20included%20a%20IncidentId.%26nbsp%3B%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Microsoft

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

replace(actionOutputs('Create_HTML_table'),'test1','<a href="http://www.microsoftflowisamazing.com/')
the Create_HTML_table in this expression is the name of the item in step 2. 
the http://www.microsoftflowisamazing.com/ in this expression is the part of my URL that precedes the IncidentId value. 
5. Add a second 'Compose' (default it will be called Compose 2. )
and again instead of dynamic content I will use another expression to build the second half of my URL. 
replace(actionOutputs('Compose'),'test2','/home">Link</a>')
the Compose in this is the first compose name we created in step 4
the /home is the closing text in my URL, the Link is whatever my want my vanity URL name to be. 
6. For my purposes, I now add a 'Send an email' and include the dynamic content value for Compose 2 
This will in turn be my HTML table, that includes all the data from my Kusto Query, and a short value of Link instead of the long URL http://www.microsoftflowisamazing.com/1234567/home, for each item inside my data set that included a IncidentId. 
0 Replies