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
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
Any help would be very appreciated.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.