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:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
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