Answered

Flow stopped working - error message relates to an array and value type null

(0) Share

Report

Posted on by LM123

Hi ALl,

My flow just stopped working. I received the following explanation when I went into the flow and tried to trouble shoot but it has not worked. I am unsure why it stopped working as no details have changed. What do I have to do to get this back up and running.

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @LM123,

Could you please show me how you configure your approval?

I think there is no null value in your response details.

If you use a value in a field that might have a null value you can use coalesce to replace it with an empty string.

coalesce(outputs('valueyouwant'),'N/A')

Was this reply helpful? Yes No
LM123 81 on at

Like (0)

Report

@v-qiaqi-msft - this is my approval:

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @LM123,

Have you tried my formula?

Use the

coalesce(<DynamicContent_ResponseDetails>,'N/A')

Or:

if(equals(<VALUE TO TEST>,null),'N/A',<DynamicContent_ResponseDetails>)

Was this reply helpful? Yes No
LM123 81 on at

Like (0)

Report

Hi Qi,

I dont know where to put your formula. I am not from an IT background so not sure where it is meant to go.

Any guidance.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @LM123,

if(equals(outputs('Get_response_details')?['body/rfd513626b03b41fd873c992d83806885'],null),'N/A',outputs('Get_response_details')?['body/rfd513626b03b41fd873c992d83806885'])

Was this reply helpful? Yes No
LM123 81 on at

Like (0)

Report

THanks Qi, do I need to type all this out as it does not come up as an option and cannot cut and paste.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @LM123,

If you are not sure which field is empty, you need to type all this out.

Was this reply helpful? Yes No
LM123 81 on at

Like (0)

Report

@v-qiaqi-msft I applied your solution but now my flow wont run - any other suggestions?

Was this reply helpful? Yes No
LM123 81 on at

Like (0)

Report

@v-qiaqi-msft dont know what happened but after the second test flow worked with your solution thanks!

Was this reply helpful? Yes No