I am creating a birthday announcement automation for my organization. I'm using a dataverse connector to get contact info from D365, OneDrive to write to an Excel file for testing, and email, to test sending the message. I am trying to store a list of birthday quotes in an array, and then pick a random item from that list later in a for each loop and use it in a email/excel. The trouble that I am having is that when I attempt to select a random item and store it in a variable, it appears that the variable is blank.
Here's what I have:
I declare the array variable and set the value.
I declare the variable to hold the selection being picked from the array, (leaving it blank so I can set its value next). (ignore the comment, that was from a previous try)
Within my for each loop, I attempt to set the variable with this expression