
I have selected Getitems as want to make a schedule report but want to appy filter query
of last 7 days based on the column InqDate
Below is the list image,
Could not understand, same getItem should bring the column name on the filter field
please advise
Hi @MIA27 ,
Please try:
InqDate le '@{utcNow('yyyy-MM-dd')}T00:00:00' and InqDate ge '@{addDays(utcNow(),-7,'yyyy-MM-dd')}T00:00:00'
Best Regards,
Bof