Weekly Action Added Template

@Spencer Smith
search for action here and you should see one that you can modify to start with:

Daily action report with constituent solicitor & prospect status

@Spencer Smith

list actions does have filter for action added on or after.

However, keep in mind that List and all other fields are mutually exclusive, meaning, if you specified a List that you saved in RE NXT to use, you cannot filter on any other field (including added on or after)

@Spencer Smith
the added on or after field intakes a static date/time. However, since you are using power automate, it is easy to dynamically create a date that is X day in the past. You can check out these expression:

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#addDays

addDays(startOfDay(utcNow()), -7) means use the date/time based on UTC (utcNow()), then use startOfDay() to set the time to midnight and then use addDays() to go back 7 days (using negative 7).

If you want to be more specific to your timezone, you can use convertFromUtc() expression.

@Spencer Smith
you will need to provide more info, esp the screenshot of the action when having run error and when in edit mode.

@Spencer Smith
you did not provide the screenshot where the error happen.

Your screnshot is just showing that there is error in your apply to each step, it doesn't show which iteration of apply to each failed and on which action did it failed on.

you need to click on the “>” button in the apply to each and find the specific action that has the red exclaimation and screenshot that action as well as the edit mode of that action.

@Spencer Smith
You are misunderstand what I am asking.

For example, in a sample flow:

• get list of gifts
• apply to each gift
  • action 1
  • action 2
  • action 3

If your flow run and show you there is error at “apply to each gift”, that is NOT where your error truly is. the error is going action 1, action 2, or action 3. It “MAY” not show for the first gift in the apply to each gift, you will have to use the >

to go through each gift that is “looped” and find the one that has a red exclaimation on the actions INSIDE the apply to each. It will be one of the actions you have: Get a constituent action, List constituents - connects Action to Constituent of Action, etc (can't see more from your screenshot). Find that action that failed, and screenshot that action's run history and edit mode.

@Spencer Smith
what you provided is good now. So we now know the real action that error out is List constituents - connects Action to Constituent of Action

you are using the join() expression to create a comma separated constituent system record ids to get constituent list on. But the problem is your join() is incorrect. Like the error message tell you, the first parameter of a join needs to be an array, but instead you provided null.

Your join expression is: join(outputs('Get_a_constituent_action')?['body/fundraisers'], ‘,’)

this means either (1) the Get a constituent action did not return an action that has any fundraisers (action does not have to have fundraiser) or (2) You did not call the Get a constituent action using the action system record id.

Your flow also does not “sound” right, so your originally post was to get a list of action that was added in a given week, is that still what you are trying to do? if so, then your flow should just be:

1. get action list (all constituents) parameter filter by date_added greater than -7 days ago
2. for each action
   1. get the constituent (for info like name)
   2. append data you want to show in an email into an array
3. create html table based on the array
4. send email with the html table created in #3.

@Spencer Smith
what template did you use, maybe i'll import it so better see what it is.

However, the error you receive has nothing to do with using list or using date_added. I don't konw what critiera you had on the RE NXT list, probably filter on fundraiser being some one or some people. Therefore your list of actions all had the fundraiser array. However, when you get action by date_added, you will get all actions that meet that criteria, including actions that does not have any fundraiser, which cause the “null” error.

If you are only looking for action that HAS fundraiser, then after the list action step, you can use filter array to filter only on actions that have fundraiser.

or if your flow INTENT to process actions that doesn't have fundraiser, then you need to use condition to determine if fundraiser dynamic content is null, if yes do not do the list constituent step, if no, do the list constituent step.

Flow should be created such that it does what you want it to do, so the question is what exactly are you trying to accomplish? what should happen for action that have fundraiser(s), what should happen for action that does not have fundraiser?