Answered

Blank output from filter array flow

(0) Share

Report

Posted on by Tim19943

I'm trying to send automated emails with multiple variables. I'm also adding a table in the email. but it only needs to add the table rows for each applicable contact. and this is where i get stuck. I've followed a video from youtube and replicate the steps but i think at filter array it went wrong. my input looks okay, but my output is blank. Any idea why this is blank? or how could i manage this?

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Show us filter action configuration, your issue may come from the dynamic contents you populated there.

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

i hope these help?

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

this Email comes from Parse JSON ?

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

yes it does

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ok nothing wrong from Parse JSON output, the last thing I didn't checked is your "Retrieve all data" output, the "Email" dynamic content is either not the right one (I can see a "E_mail Medisch..." in the select all emails action) or "Email" haven't same value as Parse JSON one.

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

The "retrieve all data" is a list row from excel. one of the columns names in the excel is "E_mail Medisch techniek" where it needs to select and gets its emails. the Parse JSON gets its content from the output of "get unique emails". where i used the union expression.

output from start

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

Ok, I built a test case flow with same actions, but couldn't reproduce behavior, I got rows I had to get.
In your flow:
Is this Email dynamic content same as the following, because they look different ?

I see nothing in your flow that could make it fail, except that data you're comparing are not matching.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

so i started a complete new flow, and now i'm almost there. i'm only missing two values in my email. for some reason the "select output" is causing this. i use the exact same file and the input recognize the values in the excel, but output is Null. any idea why? i'm reffering to CDM/SDM name and Email CDM/SDM

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

Because you have "/" in your column title. PA replace it by "~1" in path selector.
item()?['CDM~1SDM Email'] instead of item()?['CDM/SDM Email'] because if it keeps "/" it would try to find a property called "SDM Email" of an object called "CDM".

As far as I know you can't escape this, obviously ~1 make PA failing to reach value. Rename your column.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Tim19943 56 on at

Like (0)

Report
Copy link

Link copied!

it worked for the output. but in the email body it is not being recognized 😞

Was this reply helpful? Yes No