Unanswered

problems exporting hyperlink in Sharepoint columns to excel table

(0) Share

Report

Posted on by bren88

I have created a flow to export a sharepoint list to an excel table in my OneDrive folder. The column that contains hyperlink is displayed in html code. How do I get around this problem? How can I display this column as text only?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @bren88

You can add an action to convert Html to plain text and then pass the content with html to that action and use the outputs to pass plain text to excel column.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
bren88 99 on at

Like (0)

Report

Thanks for your response, see the following part of my flow to add row to Excel table, it's the contact details column that contains hyperlink, can you show me where to add the extra actions here?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @bren88

You have to add the html to text action above the add row in a table action and then pass the contact details from dynamic selector to the html convert action and use the out put from that action for the excel column.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
bren88 99 on at

Like (0)

Report

Thanks again, I have added the following action above the 'Add row to table' action but where is this output?
Am I missing a step here? When I get to 'contact details' when adding a row I can only see the Sharepoint contact details field in the dynamic selector?

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @bren88

You do not need to use another apply to each. This action can be added to the apply to each loop itself. Here is what you can try:

1. Add the convert HTML action after the excel action that is in your current flow. Pass the contact details column in that.

2. Select the excel action and drag it below the convert HTML action now.

3. In the excel action, on the appropriate column, select the output of the html action from the dynamic selector.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
bren88 99 on at

Like (0)

Report

Thank you so much!
The details in this column now displays as text but any idea why it repeats the url in square brackets like this:
https://auspost.com.au/ [https://auspost.com.au/]

Also is there an action I can add to now hyperlink the url in my Excel table?

Thanks again for all your help, much appreciated:)

Was this reply helpful? Yes No