cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Floriankx Established Member
Established Member

Power Query - how to handover column to be used with 'each'

Hello,

 

I have the following formula 

Output=Table.AddColumn(TextToChange,"Changed Text", each ReplacementFunction([List]))     //[List]=Column name to change

If I try to replace list by a variable and integrate this row to a function. But even if I change to 

 

Output=Table.AddColumn(TextToChange,"Changed Text", each ReplacementFunction(TextToChange[List]))     //[List]=Column name to change

I receive an error because type 'list' can't be converted to 'text'.

So actually I am not able to handover this with a function because I only know how to handover lists and tables.

 

Do you have any idea how I can solve this issue? 

1 REPLY 1
Community Support Team
Community Support Team

Re: Power Query - how to handover column to be used with 'each'

Hi

Let me draw your attention to your formula below
Output=Table.AddColumn(TextToChange,"Changed Text", each ReplacementFunction(TextToChange[List]))

ReplacementFunction([List]) function need a parameter of type text, but TextToChange[List] return type of list.

 

Best Regards

Maggie

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,655)