Forum Discussion
Replace column values using Uri.parts function
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.
Hi awtahhan
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
3 Replies
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
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.
Hi awtahhan
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
