Unanswered

Filter results

(0) Share

Report

Posted on by tezbriz123

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:

Using flows

I have the same question (0)

All responses (11)

Answers (0)

tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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! 🙌

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @tezbriz123

May i know what condition you are adding there ?

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! 🙌

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @tezbriz123

What condition you have put in there ?

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

Thank you for having a look at this.

Was this reply helpful? Yes No
tezbriz123 14 on at

Like (0)

Report
Copy link

Link copied!

when i

Was this reply helpful? Yes No