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

All responses (9)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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')
LM123 81 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft - this is my approval:
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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>)
LM123 81 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LM123,

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

Like
a
(0)

Report
Copy link

Link copied!

THanks Qi, do I need to type all this out as it does not come up as an option and cannot cut and paste.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LM123,

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

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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