Unanswered

Filter Array not working with user input as variable

(0) Share

Report

Posted on by skerbel

I am creating a flow where a certain set of users from a table are presented to the user in PVA based on their department and which specific row of information they are looking for. I'm using user input from PVA to try to filter the data.

I'm having an issue where if I use a variable that I created from their user input it will not properly filter an array. However, if I specify the data using a specific row, it does work.

For example, this flow creates output in the filer array:

But this one presents no output in the filter array:

I've confirmed in the run history that the variables are getting the correct values. Everything looks perfectly correct, and perfectly the same between the two flows, until it hits the filter array. Then, the latter produces no output. I've even had the AuthOption variable presented back to PVA and it's passing the right data (the user input).

Can someone tell me what I'm missing please? Thank you!

All responses (5)

Answers (0)

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Array not working with user input as variable

@skerbel Got what you mean now. I didn't realize that AuthOption contained the actual column name you were trying to retrieve.

What I'd suggest is to look at the column names and ensure they are the internal names of the columns, not just the display names. So, after running List rows present in a table, have a look at the output and ensure the column names you see in the JSON output exactly match what is being stored in your AuthOption variable.
skerbel 20 on at

Like (0)

Report

Re: Filter Array not working with user input as variable

I'm sorry if I'm being dense, but the issue is that the AuthOption variable changes based on the user input. So if I choose a specific column name in the filter array, the array will work, but it's not getting the dynamic input from the user, so it will only provide one column of data.

I've set the user input to be exactly what the table columns are named, and it shows in the variable correctly, but when it hits the filter array, there's no output.

If it helps, the structure of the table has the names of the columns left to right, which correspond to the user input, and then TRUE or FALSE in the rows. So every time a user chooses a different column, it would provide a different set of TRUE or FALSE data.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Array not working with user input as variable

As mentioned, in your second Filter array you need to add the Auth field from List rows present in a table and check to see if that contains (or equals) the value stored in your AuthOption variable.
skerbel 20 on at

Like (0)

Report

Re: Filter Array not working with user input as variable

Thank you for your response. The issue is the value of the variable changes depending on the user selection, so I can't just choose a static value like in example 1. Is there a way I can define the value of the variable such that the filter array can read it correctly?
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Filter Array not working with user input as variable

@skerbel In the second flow, the filter array have filter of variable AuthOption contains True? I think you need to select the value from excel that contains certain value in filter array condition for it to make work.