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.
Hey there. The ODATA bit should have worked, what did your filter look like? Another option might be a 'filter array'.
Keep us posted.
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.
@kr6955 - Ah, I think it's the space in the field name. SharePoint reacts weird to those sometimes. Checking now, will update shortly.
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.
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.
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
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
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!
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.
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.
This is taking longer than the time it takes me to send all the work and dates manually.
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.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!