[Azure Data Factory] cannot be evaluated because property 'RuntimeStatus' Cannot be selected. Property selection is not supported on values of type 'String'.

Question

[Azure Data Factory] cannot be evaluated because property 'RuntimeStatus' Cannot be selected. Property selection is not supported on values of type 'String'.

Abarquez, Daniel 0

I have an error in running my Azure Data factory which saids here "cannot be evaluated because property 'RuntimeStatus' Cannot be selected. Property selection is not supported on values of type 'String'.", this pipeline didn't occur this year since I've deploy it last year until this today which the error occurred.

Abarquez, Daniel 0 Reputation points

2025-05-14T01:00:52.4933333+00:00

since the picture is not reflected on my question I just put it here.
Abarquez, Daniel 0 Reputation points

2025-05-14T01:01:49.62+00:00
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2025-05-15T08:31:01.04+00:00

@Abarquez, Daniel We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Abarquez, Daniel 0 Reputation points

2025-05-14T01:00:52.4933333+00:00

since the picture is not reflected on my question I just put it here.
Abarquez, Daniel 0 Reputation points

2025-05-14T01:01:49.62+00:00
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2025-05-15T08:31:01.04+00:00

@Abarquez, Daniel We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi @Abarquez, Daniel
Thanks for reporting the issue you're encountering with your Azure Data Factory pipeline.

"Property 'RuntimeStatus' cannot be selected. Property selection is not supported on values of type 'String"

This error indicates that your expression is trying to access a property (RuntimeStatus) on a value that is a plain string, not a complex object as expected.

This typically occurs when you use a dynamic expression like:

or(equals(activity('WaitCheckCSVDetail').output.output.RuntimeStatus, 'Failed'), ...)

In this case:

activity('WaitCheckCSVDetail').output.output is already a string (not a JSON object), so ADF cannot evaluate .RuntimeStatus on it.

How to Fix

You need to adjust your expression to reflect the actual structure of the output.

Step 1: Inspect the Output

In the Output tab of the 'WaitCheckCSVDetail' activity, look at the structure of output.
It’s likely already a string or contains a flat structure.

Step 2: Update the Expression

If the output is just a string like "Failed", you should simplify the expression:

equals(activity('WaitCheckCSVDetail').output, 'Failed')

Or, if it's nested like:

or(
  equals(activity('WaitCheckCSVDetail').output.RuntimeStatus, 'Failed'),
  greater(activity('WaitCheckCSVDetail').output.ErrorCount, 0)
)

Make sure you're not repeating .output.output unnecessarily.

Azure may have changed how outputs are handled internally, or your source activity now returns a string instead of an object. This is why it’s good to revalidate the output format especially after time gaps or backend updates.

Let us know how it goes, and feel free to share the output structure if you’d like help refining the expression.

If this resolves your issue, please click Accept Answer to help others who may have similar questions.

Abarquez, Daniel 0 Reputation points

2025-05-18T16:28:07.39+00:00

Hi @Smaran Thoomu

Thanks for the help, already found the cause of the error, my apologies if I didn't show the whole JSON message due to sensitive information.

The pipeline JSON output is displaying error message on the "output" variable.

Pipeline CheckCSVDetail JSON output:

"output":{ "name":"CheckCSVDetail", "input":{ "name":"CheckCSV", "runtimeStatus":"Failed" }, "output": "Thrown Exception" } ```We call an Azure function for checking the csv files which cause the error on the pipeline when running, which the activity('WaitCheckCSVDetail').output.RuntimeStatus returns "NULL" value because the value RuntimeStatus didn't exist in the JSON message causing the or(...) condition thrown an error exception.I'm still fixing the Azure function until now :)
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2025-05-19T12:24:36.2266667+00:00

@Abarquez, Daniel Thanks for the update and for sharing additional context.

From the JSON you've provided, it looks like activity('WaitCheckCSVDetail').output is a string ("Thrown Exception"), and not an object containing RuntimeStatus. That explains why the pipeline throws the error when trying to evaluate .RuntimeStatus - it's not present in the current output structure.

Suggested Fix:

To avoid this issue, you can update your expression to include a null check or structure check. For example:

if(equals(coalesce(activity('WaitCheckCSVDetail').output?.runtimeStatus, ''), 'Failed'), true, false)

Or, if output is always a string, simplify to:

equals(activity('WaitCheckCSVDetail').output, 'Failed')

This helps prevent failures when RuntimeStatus is missing or the structure changes unexpectedly - which can often happen if the called Azure Function behavior changes.

Let us know once your Azure Function is updated. We’re happy to help validate the new structure or refine the expression accordingly.

If this helped, kindly click Accept Answer so others can benefit from this too.

Share via

[Azure Data Factory] cannot be evaluated because property 'RuntimeStatus' Cannot be selected. Property selection is not supported on values of type 'String'.

1 answer

Your answer