i have sharepoint list ,for date using default coloumn 'Created'.
i connect to list to gallery.
now i want to delete records by bulk using Default Date coloumn. ( records should delete by month wise ).
how to do this ?
Hi @venky232,
You can create two datepicker controls to select the start and end dates for the records that you want to delete. Then, use the following formula on the 'OnSelect' property of a button to delete all the records between these dates.
RemoveIf(
YourListName,
DateColumn >= StartDatePicker.SelectedDate &&
DateColumn <= EndDatePicker.SelectedDate
);
If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @venky232
You can bulk delete records by calling the RemoveIf function.
For example, here's how to delete records created in June 2023
RemoveIf(YourSharePointList,
Created >= Date(2023,06,01) && Created < Date(2023,07,01)
)
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional