Unanswered

ERROR The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

(0) Share

Report

Posted on by chintu49

Hi, I am getting this error message as well (The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.), . I am trying to send reminders to users from Power BI Report using Power Automate.

Below is the error message and step where I get the error

I am not sure what should I do to ignore or remove that "NULL", i do not have any "NULL" Values in the table below is my workflow screenshots in detail

Please help

Thank you

Chintu

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Hi , @chintu49
Can you show your "Parse Json" output in your flow run history and your "Append to array varaiable" action's configuration in your side?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
chintu49 45 on at

Like (0)

Report

Was this reply helpful? Yes No
chintu49 45 on at

Like (0)

Report

Thanks for your help Yueyun Zhang

Was this reply helpful? Yes No
chintu49 45 on at

Like (0)

Report

@v-yueyun-msft

Thank you for your response really apprecaite, here is the screenshot for the append to array variable. I am putting body and then "AccountOwnerEmail" in "Name" field and "Resourceemailaddress" that comes from the dataset table in the "Value" field

Was this reply helpful? Yes No
chintu49 45 on at

Like (0)

Report

@v-yueyun-msft are you able to help please?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi, @chintu49

Thanks for your response! This error code means you can not pass the null to the "Append array variable" action in your loop.

You need to add the condition before you use the "Append to array variable" action:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No