Views:

Applies to Product - Power Automate


What’s happening?
Customers are encountering issues when attempting to access URLs from a DataRow in Power Automate Desktop, resulting in navigation errors.
 

Reason:
The errors are typically related to invalid URL formats being used in the "Go to web page" action, which may arise from incorrect extraction of the URL from the DataRow.
 

Resolution:

  1. Ensure that the data is read correctly from the worksheet into a DataTable using the appropriate action.
  2. Use the "For Each" action to loop through each DataRow in the DataTable, storing each row in a variable (e.g., CurrentItem).
  3. When using the URL in the "Go to web page" action, verify the expression used. For example, use %CurrentItem['URL']% to extract the URL.
  4. If encountering a navigation error, display the entire row using %CurrentItem% to confirm that the URL is formatted correctly in the respective column.
  5. If the error persists, consider constructing the URL using parts from different columns if applicable, ensuring that the final URL is valid.
  6. Keep in mind any '%' included in a manually constructed URL, which may need to be escaped via the notation %%, which results in using a literal '%' character.