cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Power Automate - Formula Creation

Hello, 

I am working on an automation where it picks up a report from my inbox and I need to filter current Workers who will be ending in 35 days from the current date. Is there a way to filter to the date column and only keep those rows? Please let me know if you need me to provide additional information. 

 

Thank you!

3 REPLIES 3

Hi @tliwanag 

 

so just to clarify - you have email with excel attachment from which you need to make flow to download attachment and then filter the excel report based on date - correct ?

 

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

 

Hi @Nived_Nambiar yes, that is correct. I currently have flow that will pick up the file in my one drive, create a table and then list the rows in that table. From here I will add a few filters. The first, is to filter out any blanks within my "Hiring Manager" column, filter out a name in the "Supplier Column" and my last filter would be to filter the "Work Order End Date" to only show dates that are 35 days out from the current date. However, my filter arrays don't seem to be working.

 

This is my overall flow:

tliwanag_0-1721251831796.png

 

In my first filter array to filter out blanks in the "Hiring Manager Column"

tliwanag_1-1721251888362.png

 

In my 2nd Filter array, it filters out Supplier that are not equal to Navolio

tliwanag_2-1721251925967.png

 

In my 3rd filter array, I'm trying to filter the "Work Order End Date" to show anything equal or less than 35 days

tliwanag_4-1721252014527.png

 

Hope this provides better clarification. Thanks!

 

Hi @tliwanag 

 

if i am correct - your 3rd filter isn't working. Here for comparision of date , i always recommend to take the difference b/w dates and convert to equivalent days/months/hours etc and then compare which would be easy.

Take this expression from the article as an example-

https://powerusers.microsoft.com/t5/General-Power-Automate/Using-the-dateDifference-expression-or-ti...

 

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

 

Helpful resources

Announcements

Important Update | Power Up Community READ ONLY July 22 – July 28

Dear Community Members, As you may have read, the Power Platform communities are transitioning to a new platform and to access will be set to READ-ONLY mode during the transition. Key DatesTo ensure current learners have adequate support in the final week of the cohort, the Power Up Program Community will transition to READ-ONLY mode starting July 22nd, the platform will transition to READ-ONLY mode until July 28th. Power Apps, Power Automate, and Power Pages communities will be read-only July 16-22, 2024.During this period, members will not be able to start new threads or Kudo, Comment, or Reply to any posts, but will be able to search and review past threads or solutions. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. Learners will be able to sign in to the new Power Up Program community experience, starting July 29th. If you registered for community using your learnwithpowerup account, you will not receive an email, but should be able to sign in successfully if you are signed in to My hub.  If you need help with your community account, please submit a request at aka.ms/PPCommSupport We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead! 

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.

Users online (710)