Replace structured values with nulls in Power Query

[EBGAL]

Hi, community,

When I load data from a SharePoint list, it often happens that column values are partly structured like below:

Structured value Table, in this case, means null value. 

When I convert such a column to text type, it throws an error for structured value rows. For sure, I can later delete/convert errors to nulls but thought if there was any way of converting Table structured values to nulls straight away.

Thanks

Evan

[v-rzhou-msft · Accepted solution]

Hi @EBGAL 

Structured value Table is a dynamically expanding table, not the same like values in columns.

Unless you change the Structured value Table to error, you couldn't find replace value function like normal values when you right click on column header.

Normal value:

Structured value Table:

So please transfor Structured value Table to error and you can use replace error to get null.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.