Workflow to concatenate multiple choice field into a single text field

(0) Share

Report

Posted on by Cat_Car

Hello,
I am a beginner in Power Automate, but made some research and I understand that it is possible to concatenate multiple choice field into one text field using Power Automate.
My objective is to make a business rule with that text field that will gather all the possible answers of the multiple choices.

So based on a Copilot step by step and with small modifications, I started with this

so the trigger is that when the column gm_specialpickupanddelivery is added, modified or deleted from the table Opportunities

Do I need to filter rows? If so, how do I do this?

Then I created a variable and in the value I selected the field for which there are multiple answers possible (Special Pick up and Delivery)

Then used the "Update a row" action
Identified the table and in the row ID I selected the new text field that I previously created (SpecialPickUpDeliverytext)

and next to that text field I put the variable

and the error message I get is at the Update a row step
The 'inputs.parameters' of workflow operation 'Update_a_row' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'recordId'

I do not understand. Can anyone explain in a simpler way PLEASE :-).

Thanks,
Cat

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Matthias PPS 70 on at

Like (0)

Report
Copy link

Link copied!

I think what you mixed up is the field where you can write directly into and the expression area.

When you click in the value field you need to go to the Expression area. There you can enter the join function.

Was this reply helpful? Yes No
Cat_Car 16 on at

Like (0)

Report
Copy link

Link copied!

Hello @Matthias PPS, thank you for the information. I made the change, but now I am getting another error in the Initialize variable

So in the expression, I copied my formula join(triggerOutputs()?['body/@{triggerOutputs()?['body/gm_specialpickupanddelivery']}'])

and when I test it, I now have this error :

Unable to process template language expressions in action 'Initialize_variable' inputs at line '0' and column '0': 'The template language function 'join' expects its first parameter to be an array. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#join for usage details.'.

Any Ideas on how to fix this?

Thanks

Was this reply helpful? Yes No