Scenario : Fetching employee data (rows) based on the joining date , if the joining date is greater than current month then it should be removed from the source file (eg : current month is November , if we see any dates with December or later than that , remove it) and from the below sample data , we have date of "08-12-2024" which is matching our scenario and also already available in the file but the flow failed :
Here you are deleting the row. Use the GGID which I believe is the unique value. Change the Key Column to GGID and Key value map from the list rows step (GGID).
If looking anything from next month onwards then look for
formatDateTime(utcNow(), 'MM') this will return the month.
How about next year January data?
So if you are comparing Nov vs Jan it will be 11 > 1 which won't be true.
Think about adding Year too.
Thanks
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.