cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
goliaaat
Frequent Visitor

Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document. clientRequestId

Hello

I have a problem with reading xlsx files

Even though I deleted all urls

I see the same error

FLOW.png

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Afternoon,

 

I was puzzled by this for a bit too, but worked out the issue. Certainly for me anyway.

 

To resolve this, it seemed to be caused by the formatting of some of the data within cells in my table. Namely emails had been converted into hyperlinks. Once I formatted thema s plain text. It stopped this issue.

 

Just need to be careful when modifying\adding cells manually that may convert data to hyperlinks.

View solution in original post

4 REPLIES 4
v-monli-msft
Community Support
Community Support

Hi @goliaaat,

 

I saw the error was from the field of picking tables in excel file. Have you made sure that you have formatted the data as table style  in Excel?

https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,

@v-monli-msft

 

All of the sudden my app stopped working today and now I am getting this error;

 

Tables didnt load correctly. 

Failed to read Excel workbook stream. Failure reason: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.
clientRequestId: 56762065-be49-4111-a4e9-b18838b08cd4
serviceRequestId: 56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4

Session ID: 178af976-33d6-4cf4-ae2f-9e52be235c75

 

what can I do to fix this? 

Anonymous
Not applicable

Afternoon,

 

I was puzzled by this for a bit too, but worked out the issue. Certainly for me anyway.

 

To resolve this, it seemed to be caused by the formatting of some of the data within cells in my table. Namely emails had been converted into hyperlinks. Once I formatted thema s plain text. It stopped this issue.

 

Just need to be careful when modifying\adding cells manually that may convert data to hyperlinks.

AuriKlipsch
New Member

Modern.ie VM Password: Passw0rd!

Easy way to remove Hyperlinks from Excel sheet:

 

  • Press Alt+F11 to open the VB editor.
  • Add the VB sub below and Save. Ignore macro-free worksheet error if prompted, unless you want to save this macro.
  • Close, then go to Macros and run the macro. It will remove all hyperlinks from the active sheet.

 

Sub RemoveHyperlinks()

 

' Remove all hyperlinks from the active sheet.

ActiveSheet.Hyperlinks.Delete

 

End Sub

 

Based on this video: How To | Remove all Hyperlinks from Excel - YouTube

Worked for me 🙂

 

Good luck!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,392)