Filtering a JSON Array in Power Automate

you can certainly use Filter array action in power automate to do what you want to do, however, you do need to pay attention to the date data. The data you showed in your post looks to be Query API downloaded data, where the date is in "m/d/yyyy" format. This format to power automate is just a normal string, not a date string. You are likely going to need to use the parseDateTime() expression on the Participant Registration Date before you can do the logical comparison to the addDays(utcNow(), -1) or addDays(utcNow(), -7)

you can do it multi-actions process or, you can do it in 1 action directly in filter array. the multi-action process (for no/low coder) in a nutshell:

1. Query API get the data in JSON (you are getting "text" back, but it is not a text file)
   1. not going into the multi-action here to execute, to poll if complete, to check success, to download
2. Parse JSON on the data that came back so you can use dynamic content more easily
3. use action to get yesterday date, potentially needing to convert from UTC to your timezone
4. Use Filter Array
   1. in the condition, you will use expression to parseDateTime() of the Registration date equals to yesterday date

Condense version without so much more action:

1. Query API get the data in JSON (you are getting "text" back, but it is not a text file
   1. not going into the multi-action here to execute, to poll if complete, to check success, to download
2. Filter Array
   1. From: json(base64ToString(body('HTTP_Get_Query_Result')?['$content']))
      1. Assuming the HTTP action name to download query result is HTTP Get Query Result
   2. Condition
      1. LEFT
         1. parseDateTime(item()?['Participant Registration Date'], 'en-US', 'M/d/yyyy')
      2. is equal to
      3. RIGHT
         1. addDays(startOfDay(convertFromUtc(utcNow(), 'Eastern Standard Time')), -1)