Replace column values using Uri.parts function

[awtahhan]

Hello,

I have a column with encoded URL values, I want to decode and replace these values using Uri.parts function, to do so I constructed the following poqwer query:

Table.ReplaceValue(#"Renamed Columns3", each [url], Uri.Parts(Table.Column(#"Renamed Columns3","url"))[Query][a], Replacer.ReplaceValue, {"url"})

But I am getting the following error:

Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]

Could any one please help me with this problem?

Thanks in advance.

[PhilipTreacy · Accepted solution]

Hi @awtahhan 

Download example PBIX file

The initial error you posted stated We cannot convert a value of type List to type Text. so I expected that your url column contains Lists somewhere like this

To avoid that error you can use try..otherwise when creating your Custom Column in Power Query like this

try Uri.Parts("http://contoso?a=" & [url])[Query][a] otherwise [url]

which gives this result

Check my file above for the full code example.

Regards

Phil

[PhilipTreacy]

Hi @awtahhan 

The column you're trying to decode contains Lists.  Can you please supply some sample data to help me see what youu are working with.  I need to know what is in those Lists.

Regards

Phil

[awtahhan]

Hi @PhilipTreacy 

Thanks for your reply, please find below screenshot. The column does not hold full URL, it is only holding the encoded query parameter values. I want to decode those query parameter values.