Filter array question

(0) Share

Report

Posted on by ywies-gz

Hi Guys

I am new with PA and working on a flow and here is the idea:

1. Retrieve data from Excel spreadsheet

2. Select certain record based on criteria by Filter array function, in this case: Case Number = 1

3. Fill out Word template with corresponding data

4. Convert the Word file to PDF and send it out as an attachment

However, when I test the flow, the Filter array function does not seems to work properly (no output)

Can anyone throw me an idea that could make things happen?

Thanks

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @ywies-gz ,

Do you have more than 1 filtering condition? or it is just one condition?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ywies-gz

Can you check if there is any whitespace after '1' in the condition for filter array?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
ywies-gz 6 on at

Like (0)

Report
Copy link

Link copied!

I am pretty sure there is no space after "1"

Was this reply helpful? Yes No
ywies-gz 6 on at

Like (0)

Report
Copy link

Link copied!

Just 1 condition for the time being. Maybe I will add more once I get familiar with Filter array.

Was this reply helpful? Yes No
ywies-gz 6 on at

Like (0)

Report
Copy link

Link copied!

Can anyone help?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ywies-gz
Can you try to use the Filter Query on the List Items Excel Action as below

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No