Flow is deleting list values

Viewed 13

I am attempting to create a flow which will be used to update the members of various SharePoint Permission Groups. I ran into an issue with one of the actions not executing due to the fact it said that the value could not be found. After much trial and error I still could not figure out why it was failing so I started to remove actions and steps from the flow. I've taken it all the way back to my trigger and 1 action and I can't figure out what is causing my issue. Here is the setup.

I have a list with the following fields: Employee Name - Person or Group Folder - Choice Column Action - Choice Column

Flow is triggered when an item is created or modified and has the trigger condition of @not(equals(triggerBody()?['Action'],'Updated'))

1st action is just a Get items

When I add an entry to the list and select a person, a Folder and an Action the flow will run. But when it does it is deleting or removing the selected choice in the Folder column leaving it blank. Why would it do that? In the 2 steps I'm not even specifically calling that field and if it could be due to the fact that it is a choice field, why isn't the Action column value also not removed? It is not my intent to delete or remove field values.

I need the value in that field to not be removed as I intend to call on it later in a concat string but I can't call what isn't there.

What is going on?

Update #1: As an update I deleted the original flow and rebuilt it again with just the 2 steps but without the trigger condition. Re-ran the flow and immediately the option selected in the "Folder" column is removed from the list. None of the list columns are set as "required" and the choice fields are not multi-select.

Update #2: In looking at the trigger action settings the Split On statement is @triggerOutputs()?['body/value']. In looking at the sample I was using to build my flow they show the statement to be @triggerBody()?['value']. There doesn't seem to be any way for me to change the statement, could this have anything to do with why my field value is being removed from the list?

0 Answers
Related