Select data operation

(1) Share

Report

Posted on by Bochie

237

Hi Everyone!

I'm trying to copy records from a SharePoint list to another SharePoint list. I'm using the Get Items action of SharePoint and doing an Apply to Each. Inside the Apply to Each action I'm using the Select data operation to store the values of multi-choice columns. I then use the output of select as input to copy the multi-choice values into the new record. The problem is some of the multi-choice values are empty/null which causes an error in the Select action. I have 7 multi-choice columns and I do not want to do a Condition action for each.

Is there a better way to copy multi-choice columns in SharePoint using Select? Or maybe a better way than using the Select action?

Thank you for any insight/advice!

Cheers!

bochie

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

David_MA 12,515 Super User 2025 Season 2 on at

Like (0)

Report
Select data operation

Just use an expression to check if the field is empty. If it is return null, otherwise return the values. For example:

if(empty(triggerOutputs()?['body/CostsIncurred/Value']),null,triggerOutputs()?['body/CostsIncurred/Value'])

Was this reply helpful? Yes No