Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Deleting a row failed when searching for the data

Posted on 26 Nov 2024 09:58:29 by 150
Hi Experts,
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 :
 
 
  
 
 
 
Key Value : 
startOfMonth(addToTime(utcNow(), 1, 'MM'))
 
Please help to sort this flow ..
 
Thanks
DK
  • Suggested answer
    abm abm Profile Picture
    abm abm 32,227 on 26 Nov 2024 at 11:10:19
    Deleting a row failed when searching for the data
    Hi
     
    Few things not quite right here.
     
     
    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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard