Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a table which contains a colums with Email-address and another with multiple URLs.
Example:
The purpose of this is to send the URLs to the Email-addresses via Teams using the Power Automate integration.
Unfortunately the URLs are sent as a long continuos line IE. https://Link1 https://Link2 https://Link3
Instead of:
https://Link1
https://Link2
https://Link3
What I did:
In Power Query I've replaced the spacing characters with the #(cr) carriage return. It works but when I load the data in the report it is again a flat line.
Then I've tryed to SUBSTITUTE the empty space with UNICHAR(10) and/or UNICHAR(10240) but again it does not work and I get a flat line. I was making an attempt by inserting a special charachter and SUBSTITUTE it with UNICHAR(10) and/or UNICHAR(10240) but still no luck.
My last attempt was to use the Replace function in the integrated Power automate Flow but the Compose step does not let me to do it (It refuses to enter the function)
The output is this string: replace(https://Link1 https://Link2 https://Link3," ", decodeUriComponent(‘%0A’))
What should I do to get the URLs be divided by line breaks and sent in the correct way?
Thank you.
Solved! Go to Solution.
Solved.
In order to have a line break visible in the final Teams message the data needs to be in HTML format.
I've replaced the " " between the URLs with "<br>" and it works.
Solved.
In order to have a line break visible in the final Teams message the data needs to be in HTML format.
I've replaced the " " between the URLs with "<br>" and it works.
Hi @FedericoM1
I recommend that you split the URL column by delimiter " " into Rows. Then you will have only one URL value on each row.
Split columns by delimiter - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@FedericoM1 Table visuals don't seem to respect line breaks. However, other visuals like Card visuals do. So, maybe try an alternative visual?
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |