Unanswered

Issue with append to array variable

(0) Share

Report

Posted on by MerlinT

I have a flow which gets the file properties from a sharepoint library. Based on the criteria I need to send one email which contains multiple criteria matches.

I am getting the following error message - The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

Append to Array variable =

What am I doing wrong??

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @MerlinT

Dose your "Documen_x0020_Reviewer/Email" return blank in your side? Can you show me your output of your "gets file properties" action with the [Documen_x0020_Reviewer/Email] field in your flow run history?

And if it return null in your side , you need to add the condition before your "Append to array variable" action:

The condition you can refer to this

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
MerlinT 42 on at

Like (0)

Report
Copy link

Link copied!

Hi Yueyun

No it does not return blank.
I did realise the field name was slightly different, and updated it however the issue still remains.

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

Like (0)

Report
Copy link

Link copied!

Hi , @MerlinT

Thanks for your response! What's the expression you use in your side and what's the data type of your "Document_x0020_Accountab....Cliams"? And can you show me your error code now?

And you need to ensure all the [Document_x0020_Accountab....Cliams ] do not return null in your array instead of just one item.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
MerlinT 42 on at

Like (0)

Report
Copy link

Link copied!

Hi Yueyun

Thank you for your patience.
There were some blank fields which I have corrected. The flow all works now with the exception of the last step which is to update the date field in the sharepoint file properties with todays date + 30 days.
I tried adding
addDays(utcNow(),30,'dd/MM/yyyy') how it comes up with the following error message -
Any help would be very appreciated.

Was this reply helpful? Yes No