Power Automate - Building Flows

Remove joining date which is greater than current month

(0) Share

Report

Posted on by DineshK_

173

Hi Experts,

I am working on the scenario like to remove the user details who joined greater than current month.

For eg : Assume that few new joiners are gonna join on December 1st 2024 , but current month is November . So in that case we have to remove that employees from our excel lists. We can keep whoever joining until Nov 30th 2024 . Both Month & Year filter we have to apply here.

Joining Date format in the file : 26-04-2011 (dd-MM-yyyy)

I have tried to create the flow but it is giving blank result.

Input :

last row should remove from the list (as per the logic , this employee will join only on December - Next month , so we should remove this row based on the joining date - dynamic)

FLow :

int(formatDateTime(item()?['Joining Date'],'MM-yyyy'))

Please help to achieve this..

Thanks

Categories:

Business Process Flows

All responses (3)

Answers (0)

DineshK_ 173 on at

Like (0)

Report

Remove joining date which is greater than current month

08-12-2024 date is available in the file but the flow failed due to not found error :
Suggested answer

DineshK_ 173 on at

Like (0)

Report

Remove joining date which is greater than current month

ThanksExpiscornovus ..

But the month should be greater than instead of less than (December Joining date) .

After that only i will get the row of having december joining date .

Now how to remove those selected row from the same excel file after filter array ?
Expiscornovus 30,664 on at

Like (0)

Report
Remove joining date which is greater than current month

You can also use the addtoTime function and calculate the 1st day/start of the next month.

https://paulcunningham.dev/calculate-start-end-month-power-automate/

Try the below

Joining Date is less than

startOfMonth(addToTime(utcNow(),1,'month'))