Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Check if SQL rows are empty for Yesterdays date only

(0) ShareShare
ReportReport
Posted on by 14

Bit of a complex one, I am wanting Power Automate to check if sales data for YESTERDAY ONLY exists or is blank, and if blank then return a zero and if not blank then return a 1

 

Adam01_0-1648465762716.png

So in this example as there was sales data relative to yesterdays date which is "2022-03-27" as today is the 28th. I want Power Automate to return a 1 and therefore the rest of the flow will run.

 

If there was no sale data for the 27th I would want Power Automate to return a 0 and therefore the rest of the flow would not run.

 

So far I have the following:

Adam01_2-1648465959170.png

 

Would this work or is there a more functional/effective way of doing this?

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard