Filtering NXT list of actions by "added on or after" in Power Automate

Nicole Holt

I'm trying to create a flow based on a certain action type/action added yesterday. Since "date added" isn't an available filter in NXT action lists, and "action type" isn't an available filter in the Power Automate "list actions" BB connection, I tried combining the two:


Unfortunately the flow is disregarding the "added on or after" filter. Is there a way to make these filters work together?


Thanks in advance for any insight!


-Nicole

Ben Lambert

Hi Nicole,


Thanks for your question, and sorry for the confusion.


The List actions connector action is based on the underlying ListActionsAllConstituents endpoint in the SKY API, which doesn't (currently) support a filter for action type. And you're right about the NXT Action list not supporting a filter for "date added" (it's based on the Action Date). This is good feedback that I'll make sure to route to the teams who own these areas.


The way the API (and by extension, the connector) works today is that providing a List overrides other filters. We have this (admittedly subtle) behavior documented here:
https://docs.microsoft.com/en-us/connectors/blackbaudraisersedge/#list-actions.


So in your screen shot, the "Added on or after" filter (which looks at the date added on the action) will be ignored because you've specified a List. Does the "FLOW - Volunteer Actions (yesterday)" list contain more criteria? If you remove the List filter, and just keep the "Added on or after" filter, you'll get all actions added yesterday (assuming that is the expression you're using), and you could perform any additional filtering within the flow.


Does that help?

Nicole Holt

Ah-thank you so much! Yes, the NXT list has filters that aren't present in the connector, so that list is still needed for now.


And thanks for passing on the feedback about "date added!"

Warren Sherliker

Hi,


Yes via SKY API ListActionsAllConstituents you can filter by date_added and sort by it too. Using this you can then apply a later filter on the action_type. This is what we have used in SmatSYNC to provide exactly this sort of trigger. e watch for all new actions and then apply custom filters on any of the fields... Maybe you can do similar in the Microsoft platform? Anyway, message me if you want to know more about our product which we are sure can do what you are after - just as an alternative approach.


Cheers


Warren