web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Filter results

(0) ShareShare
ReportReport
Posted on by 14

I have a flow set up. It runs fine, Kina. It is returning the 4 recorts from the excel file. In the excel file there is a column called Diarised date. I woulkd like to filter the results to only show the rows that show todays date in the diarised date column.

I have the next step set to post a message in teams which is working but as i said it sends 4 messages not just the one showing todays date in the diarised date column. Hopefully an easy fix

Categories:
I have the same question (0)
  • tezbriz123 Profile Picture
    14 on at

    I have solved the issue. The dates coming from excel needed to be changed as they come as a 5 digit number. I solved that. I now would like to ignore blank spaces and anything that is not a date from a column. I have used if to ignore the blanks. How would I get it to ignore (N/A) 

  • Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @tezbriz123 

     

    I think Date format may be different in the dynamic content , do one thing, use compose action to check the highlighted dynamic content to see how date format looks like in output ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

  • tezbriz123 Profile Picture
    14 on at

    I have tried a few things. What should I be using? Choosing this I thought would give me the results u wanted. 

  • tezbriz123 Profile Picture
    14 on at

    IMG_0230.png

  • Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @tezbriz123 

     

    May i know what condition you are adding there ?

    Nived_Nambiar_0-1699804506811.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

  • tezbriz123 Profile Picture
    14 on at

    When I put anything in the condition boxes the flow says it is successful but it doesn’t send a message to team at all

    IMG_0223.png

  • Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @tezbriz123 

     

    What condition you have put in there ?

  • tezbriz123 Profile Picture
    14 on at

    When I try to add Anything two the condition part the flow, then doesn’t run or at least it doesn’t give me any results at all. If I leave it blank I get all of the records from the XL file which is just four at the moment

  • tezbriz123 Profile Picture
    14 on at

    Thank you for having a look at this. 

  • tezbriz123 Profile Picture
    14 on at

    IMG_0222.png

    IMG_0221.png

    when i

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard