Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Issue with append to array variable

Posted on by 42

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 = MerlinT_0-1718590330083.png

MerlinT_1-1718590474210.png

 

What am I doing wrong??

Thanks

  • MerlinT Profile Picture
    MerlinT 42 on at
    Re: Issue with append to array variable

    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.

    MerlinT_0-1718756387601.png

    MerlinT_2-1718756466266.pngI tried adding 

    addDays(utcNow(),30,'dd/MM/yyyy') how it comes up with the following error message - MerlinT_3-1718756602879.png

    Any help would be very appreciated.

     

     

     

  • Re: Issue with append to array variable

    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

  • MerlinT Profile Picture
    MerlinT 42 on at
    Re: Issue with append to array variable

    Hi Yueyun

     

    No it does not return blank.

    MerlinT_0-1718604035411.png

    I did realise the field name was slightly different, and updated it however the issue still remains.

  • Re: Issue with append to array variable

    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:

    vyueyunmsft_1-1718592046081.png

    The condition you can refer to this

    vyueyunmsft_0-1718591898591.png

     

     

    Best Regards,

    Yueyun Zhang

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard