Insert parameter from column A to column B

[patrickoleary85]

Hi there,

I have 2 columns in PowerQuery, text and CurrentValue. 

The value in 'text' contains {CurrentValue1}, which looks at the CurrentValue column. 

For the highlighted example with '40' in CurrentValue, the text needs to display "...for 40 has been submitted for review." 

You'll also see an example that has 'do' and 'P' in CurrentValue. 

How can I insert the text from the CurrentValue column into the {CurrentValue1} location in the text column?

Please note that the text column has a number of different variations ("{CurrentValue1} is missing a Training", "Course is missing for the user {CurrentValue1}.") so I cannot use a simple replace or split and then re-merge the columns since location is always different.

Thank you in advance!

[CatSchneider · Accepted solution]

Add in a 'Replace Values' step from the Transform Tab, then update the step in the formula bar to:

= Table.ReplaceValue(
    #"Name of your last step",
    "{CurrentValue1}",
    each _[CurrentValue],
    Replacer.ReplaceText,
    {"text"}
)

And you end up with something like:

Let me know if this helped!

[patrickoleary85]

Thank you @CatSchneider ! This worked great. Apologies for the delayed response