cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kr6955
Level: Powered On

Flow reminder email for 7 days before due date based on 2 items in a SP list column

Hello Experts

I am desperately trying to complete a list of Flows that have been assigned to me - I am the only person that has even attempted Flows.

 

I have a SP list with a column with varying projects.  I need a flow that will email specific users based on only 2 of the projects in the column.  For example: the column is called Tasks Assigned and there is, Task 001, Task 002 ... I only need Task 18 and Task 34. 

 

I have tried a few of the online examples that are similar but am missing the expression or something that actually filters the column and only looks at the 2 that I need.  I tried using the ODATA and a Get Items but neither have worked.

 

Has anyone seen this type of Flow?  Any input/help is appreciated. 

9 REPLIES 9
Super User
Super User

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

@kr6955 

Hey there.  The ODATA bit should have worked, what did your filter look like?  Another option might be a 'filter array'.

 

Keep us posted.

-Ed-

 

kr6955
Level: Powered On

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

Hello

I have tried a multitude of combinations and now just trying to get it to work with one

 

Task Assigned eq 'Task 18' and 'Task 34'

"Task Assigned eq 'Task 18' and 'Task 34'"

Task assigned eq 'Task 18' (I figured if I could get at least 1 parameter to work - I could learn what to use for adding the other.  No joy.)

 

I have tried quite a few.  Some see easy enough but I am obviously not understanding.  It seemed easy enough but in reality, it is quite complex.  I only thought it would be easy.  I figured the hard part would be with trying to put the information in a table in the email.  I have not progressed far enough to start the table thoughts.

 

Thanks for responding.

Super User
Super User

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

@kr6955 - Ah, I think it's the space in the field name.  SharePoint reacts weird to those sometimes.  Checking now, will update shortly.

Super User
Super User

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

@kr6955 

Yep, remove the space.  I tried - TaskNumber eq 'Task 34' and it worked even though the field is labeled Task Number.

 

It used to be that you had to do something like Task_x0020x_Number, but I guess they 'fixed' that. 🙂

 

Keep us posted.

 

-Ed

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Jcook
Level 8

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

Hello @kr6955 ,

 

I did something similar, although it was with CDS. What I ended up doing was adding a extra column to specify if that task is getting reminder emails sent. My solution / flow was setup to look for either a day before, 3 days before, a week before, and 2 weeks before.

Than I was able to filter on that column to bring up multiple tasks.

 

Hope this helps at all

 

--Josh

 

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Dual Super User
Dual Super User

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

Hey @kr6955 

 

Adding to @edgonzales response, it actually depends on the internal name of the sharepoint column. You can take a try without the space and check if it works. Now coming to checking for more than one field values, this is how you have to write the query: 

 

TaskNumber eq 'Task 34' and TaskNumber eq 'Task 35' 

 

Note that this works in SP but might not work while getting rows from SQL or excel (every connector has a bit different syntax for the ODATA queries)

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

kr6955
Level: Powered On

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

Thank you all for your help.  I will give that a try this morning and report back.  I have a laundry list of Flows and maybe that will fix things and I can actually get something to work.  

 

I have a meeting and will work on in about an hour.

 

Thanks, Kim

kr6955
Level: Powered On

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

UPDATE: I found the field internal name and now just need to figure out how to get the listing to appear in the mail.  

I am close - THANKS TO EACH OF YOU.  I will update again tomorrow (Wednesday)

Sorry for the delay in responding.  I had deadlines.  This ask is a multiple ask that I think can be done but it is beyond me, at this time.

 

  • I have the fow for the email for 7 days because the list has an option available on the due date column.  
  • I have changed all the column names and now have a best practice to use an underscore for multiple names.
  • I thought I could update the Flow to include the criteria for the specific column.  It does not work.  Below is what I have for the function that was part of the automated Flow for 7 days.
concat(concat('Contractual_x0020_Due_x0020_Date',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Contractual_x0020_Due_x0020_Date',' lt ','''', outputs('x_Days_+_1'),''''))
I thought I could just add the statement below,
and Task_Assigned eq 'Task0018'
 
That did not work.  I have been reading and think maybe I need the column internal name - but I can't locate it.  All instructions and videos say to use edit and there is no option to edit for the column that has my information.  So now, I am reading again to determine why this column does not give me an option to edit.  I inherited the list.
 
to recap: 
  • I can do the reminder for 7 days because it exists.  
  • The existing email reminder will need to be modified since it currently says it will come to me and I need the email to let me add the intended person.
  • I cannot get the Task Assigned eg 'Task_0018' to work ( also tried with double quotes and even a parenthesis)
  • I am looking for another name for the column (so far, no luck

This is taking longer than the time it takes me to send all the work and dates manually.

kr6955
Level: Powered On

Re: Flow reminder email for 7 days before due date based on 2 items in a SP list column

This is on my list for tonight.  I worked on it all weekend and just could not figure out how to get the email to go to someone other than myself.  I have taken a multitude of Microsoft classes and read the notes and really hope to get it done tonight, especially since I have the exact same request for 3 days and then day of.

 

I will report back.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,773)