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
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:
Would this work or is there a more functional/effective way of doing this?