Reputation: 15
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.
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?
Upvotes: 0
Views: 16