LoiShar
LoiShar

Reputation: 15

Unable to Navigate to URL from Excel DataRow in Power Automate Desktop

I'm currently working on a flow using Power Automate Desktop, and I'm encountering an issue accessing a URL from an Excel DataRow.

Here's the scenario. I've successfully read data from an Excel worksheet into a DataTable.

I'm looping through each row with a For Each action, storing each row in the variable CurrentItem.

Each row contains multiple columns: Type, Category, and URL.

I’m attempting to use the URL in the "Go to web page" action.

The Problem

When I use the expression:

%CurrentItem['URL']%

in the "Go to web page" action, I receive the following error:

Failed to navigate. The return exception is not valid. Type: System.UriFormatException

I tested by displaying %CurrentItem%, and the entire row prints correctly in the format:

Best Sellers, Amazon Devices & Accessories, https://www.amazon.com/... However, navigating directly to %CurrentItem['URL']% throws the navigation error.

My questions:

Why am I getting a System.UriFormatException when attempting to navigate to the URL?

Is there a more reliable method to extract and use the URL column from a DataRow in PAD?

Are there any common pitfalls or additional configuration steps that might be causing this error?

enter image description here

enter image description here

Upvotes: 0

Views: 16

Answers (0)

Related Questions