nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Array variable for blank Prospect Status

Chris Zello

I need some assistance with the logic in a flow that finds the records in a list with a blank Prospect Status, and sends me an email. My questions are: Does this look correct, because when I create the HTML table in my email later, nothing shows; is it blank?

And I don't recall what the purpose of the red arrow above the Append step?

acff91571122909890c7829aac65192f-huge-im

Thank you.

Find more posts tagged with

Microsoft Power Platform

Comments

Ben Regier

@Chris Zello
The red arrow pointing at your Append action means you've customized the Run After settings for that step. To verify, click the three dots in the upper right corner of the Append action and select “Configure run after”. There you'll be able to see which conditions will prompt this action to fire.

It looks like the logic behind this flow is:

Try to fetch a constituent prospect status for a specific constituent
If no prospect status exists, that step will fail, which will cause the Append step to fire, adding the constituent to your array

That logic seems sound to me. If you have reason to believe that your flow isn't returning the constituents it should, the problem may be elsewhere.

Chris Zello

@Ben Regier Glad to hear the logic is sound.

The next steps after what you saw are:

e86cb2ac03f7fd4877c35e3635e02fec-huge-im

And after that condition, I have a branch for Yes or No. Nothing happens if there is No. But if yes, then I send an email:

4fea3a1e754c1734078bc5cbea1cad53-huge-im

Unfortunately the “replace” function isn't working, because my email comes through with nothing:

c86fe5dd2cae36a7ad24584a4b3f98fb-huge-im

Something isn't quite right. Thanks.

Ben Regier

@Chris Zello
It looks like your condition is checking to see if the length of your missing prospects variable is less than 1, right? In that case, the Yes branch will fire when there are 0 results, and the No branch will fire when there are 1 or more results.

You could either move your email into the No branch, or you could change your condition to check if length is greater than 0.

Alex Wong

@Chris Zello
As Ben said, your condition should be changed as he stated.

Additionally, your condition is checking for IF there is any constituent in the array, if yes, send email. Your Create HTML table action can be inside the condition branch right before the send email action. Save an action from needing to be executed if there is no email to be sent anyway.