You’re offline. This is a read only version of the page.
21
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:
Hi @jophi1124 ,
Here are some suggestions for you to try.
We use the Select action in Text Mode to select only the values in the Title column.
And I think that the the expression in the Filter arraySS for the ClientName just needs to be: items('Apply_to_each')
To check if the "field_Due_x0020_Date" appears in the ArrayDueDate you can use the contains operator. A rough approximation of usage could be:
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
