List Filtering Bug in Power Automate (Gift List)

Aidan Lambert

I believe I've possibly come across a bug in either the Gifts API or in the Power Automate connector for it (and possibly with list actions in general).

When trying to retrieve a gift list, I cannot both select a predefined NXT list (a list made and stored in NXT) and add filters to it using those provided in the action (such as date last modified or constituent ID). If I try it with just the filters, each filter will work either individually or in conjunction. And if I select a predefined list, the action will pull said list. But if I both select a list and add a filter, the entire list is returned without filtering.

Since I can get each one to work, I know this isn't an error with how I'm setting it up.

I can somewhat get around this using the basic “filter array” action (though curiously, constituent ID isn't working for whatever reason), but would much rather be able to combine filters (or be able to access all the filters I need in NXT itself, that would also be nice).

Anyone else noticed this/able to reproduce the result?

Dan Snyder

@Aidan Lambert It was built so you can use either a NXT created list OR the filters that are available in the connector, not both. I looked for some ideas in the idea bank and it does not seem to be there so maybe you can add it.

For the constituent id and filter array, sometimes you have to quote wrap the id if you are looking to filter for id ‘12345’ or something like that.

Aidan Lambert

Dan Snyder:

@Aidan Lambert It was built so you can use either a NXT created list OR the filters that are available in the connector, not both. I looked for some ideas in the idea bank and it does not seem to be there so maybe you can add it.

For the constituent id and filter array, sometimes you have to quote wrap the id if you are looking to filter for id ‘12345’ or something like that.

Thanks for that Ben! It's good to know that at least this was intentional.

I was also finally able to figure out filtering by constituent ID. I ended up having to wrap the constituent_id variable in a string() function to get it to work. For whatever reason, the literals “” and ‘’ weren't doing the job (though they do elsewhere). I think this was more of a problem with PA being finicky about data types though (which I've experienced elsewhere).