Hi @Tejaswini1234 ,
Do you mean that you want to check the date field and if it is <30 then modify the date to =30?
Try this formula:
ClearCollect(test,
AddColumns(
Filter(tablename, DateDiff(datefieldname,Now())<30), //filter the items that datediff<30
"newdate",datefieldname+30 //add a newdate= olddate+30
)
)
ForAll(test,Patch(tablename,LookUp(tablename,ID=test[@ID]),
{datefieldname:newdate}
) //modify multiple records at once
Please replace the tablename ,datefieldname with the name that you use.
Best regards,
Community Support Team _ Phoebe Liu