Power Platform Community Forum Thread Details

I'm encountering multiple issues with my Power Automate flow:

Trigger Error:

My trigger is configured with the following setting:
```
"splitOn": "@triggerBody()?['body/attachments']"
```
This setting instructs the flow to iterate over the attachments from incoming emails. However, if an email arrives without attachments, the attachments property returns a null value instead of an array. Since splitOn expects a valid array, the trigger fails with an error message like:

"The splitOn expression '@triggerBody()?['body/attachments']' is of type 'Null'. The result must be a valid array."

As a workaround, I've considered either removing the splitOn configuration altogether or wrapping it in a condition to return an empty array when there are no attachments (e.g., using if(empty(...), json('[]'), ...)). However, I'm unable to modify the code.
Code Unmodifiable:

I cannot modify the code directly in my Power Automate environment, which prevents me from applying any fixes to the splitOn expression.

Incomplete ZIP Export:

Additionally, when I download the flow as a ZIP file, the exported package does not contain the complete code (or definition) of the flow. This makes it even more challenging to troubleshoot or modify the flow as needed.

Any insights or suggestions on how to resolve these issues would be greatly appreciated.

Categories:

In #2 When you say the code is unmodifiable do you mean you can't edit the flow in Power Automate and turn SplitOn off in the settings? Or that you can't modify the way SplitOn operates in the trigger to fix the null issue?

To the best of my knowledge your only choice is to turn off SplitOn in the settings and then handle the attachments individually in the flow. SplitOn is designed to work in such a way that each message would trigger a separate flow instance and not each attachment within a message. Your only real choice is to disable the way you are doing SplitOn either by editing the flow or deleting it and starting over.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog