I have a flow. On a scheduled time at 6am GMT, the flow runs, it Gets items from a SharePoint List and sorts it by Client Name (CN) and Due Date (DD). I am successful in even creating union so that each details per CN will be separate.
I get to do apply to each so that each scope will have only one instance of CN.
I want to insert a flow on the green portion about a field for Due date. If a Client array has a due date in its array that is 7 days or below from date of flow, the next step is to check it's Client name if it has special characters. If none, I need to automate sending email with subject that contains the word "RUSH" on it. Likewise, if the CN does not have a due date field from its items that are within 7 days, the flow is to filter the client name as well and if none, send email as usual without appending RUSH on subject. I cannot move on after the filter array. I am not sure if i have put apply to each or Scope in error.
The content of Filter array is this:
Also created array of Dates within 7 days from date of run but can't put it into logic to check if the due date per client falls in one of the 8 dates.
Contents of the client entries contain these fields:
"Title": "This is the client name"
"field_Classification": "text if entry is on or off"
"field_Due_x0020_Date": "2022-10-20", <--this is the Due date column from the SharePoint.
