Answered

Update Item > Keep current array value

(0) Share

Report

Posted on by ahartsfield

I'm searching for how to Update Item (SharePoint list) in Power Automate with a multi-select value as one of the required fields that I don't want to change. I've tried using every option in dynamic content, but it either throws an error or wipes out the values and leaves the field blank. Here is my flow:

I use initialize variable to get my multi-choice values into a form I can use in a summary email that gets sent back to the employee (Outputs from Compose 3). After it goes through an approval process, I want the Status updated on the SharePoint list, so I'm using Update Item. Since all required fields must have content, I'm trying to set it up with the same values so it doesn't change the content of any other field except the Status, but if I use Outputs again, it wipes out the content from the Incident Type field.

I've also tried just using the Incident Type Value from the "When an Item is Created" and "Get Items" dynamic content, but it wants to put me into an Apply to All loop, which I want to avoid.

Any solutions?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello,
Here is the workflow in order to update Multi Selection Field and use the value as text in order to send it in the email.
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.
And here is the output
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

Thank you!
The string variable produces the same result in the summary email for me as the array variable does, but it also still wipes out the data, leaving it blank, from the Update Item action. I must be doing something wrong because in your example of the Update Item, you are inputting the created variable. That variable isn't showing up for me in the dynamic content, I only have the Compose Outputs. I do get that variable as dynamic content in the email, however. Any suggestions?

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ahartsfield what is the type of Incident Type field in SharePoint ?
In your sharepoint list settings, please share the screenshot of the field properties like this

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

It's a Choice column:

Was this reply helpful? Yes No
abouchaala007 on at

Like (0)

Report
Copy link

Link copied!

Try to :
1- copy and paste the variable from your compose to the update item and test
OR 2- copy paste directly this code in the update item field @{variables('IncidentTypeChoice')}
OR 3- copy paste this code in the expression of the update item field,
variables('IncidentTypeChoice')
Or 4- from the power automate settings, activate the experimental features and re test.

abouchaalaBAIT

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

Thank you for the ideas for things to try! Unfortunately, none of these worked. It just continues to erase the values in the Incident Type field. I wish there was an IF statement I could write that basically tells it to do nothing, but I haven't made that work either.

Was this reply helpful? Yes No
Verified answer

ahartsfield on at

Like (0)

Report
Copy link

Link copied!

So - progress, maybe? I decided to try allowing an Apply to Each loop to see what would happen. I just used basic dynamic content to fill the Incident Type field:
I then ran a quick test and found that it did not erase the content from the SharePoint list. But that was when I only selected one Incident Type (this is a multi-choice field). I wanted to test if it would work with multiple incident types selected. Running that test, it only keeps one of the entries and erases the others.

In addition, I happened to add an attachment to my test entry and got an error (screenshot below) I have not been getting up to this point when I've tested attachments. All of my research on this particular topic is turning up issues for others when attaching multiple attachments, which is not the case for mine. And, it's been working fine until now. Sharing this info also in case it is related somehow to the changes I've made.
Help?

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

I should have included screenshots of the attachments info:

Was this reply helpful? Yes No
Verified answer

ahartsfield on at

Like (0)

Report
Copy link

Link copied!

For the attachment issue, I followed this post and it resolved. I think the Apply to Each loop is actually working so hoping this whole issue is resolved. https://powerusers.microsoft.com/t5/Building-Flows/No-Input-parameters-provided/m-p/1209371#M139366
Thank you everyone for your help!

Was this reply helpful? Yes No