英文:
Filter Queries in Get Items on Recurrence Flow
问题
我对Power Platform还不太熟悉。我有一个用例，其中流程每天运行一次，它会将今天的日期与SP列表中的修订日期进行比较 - 30天，即今天的日期 >= [修订日期] - 30天。
当然，“获取项目”每天都会处理所有项目，即使对于已满足条件的列表项目也是如此。我想限制这一点，请告诉我如何做到这一点。
我完全不知道如何继续下去。
谢谢，
Sid
英文:
I'm pretty new to Power Platform. I have an use case scenario where the flow runs once in a day, It compares today with the revision date from SP List - 30 days i.e Today's date >= [Revision days] - 30 days.
The Get items ofcourse processes all the items everyday even for the list items which already satisfied the condition. I want to restrict that, Let me know how it can be done.
I'm completely clueless on how to proceed.
Thanks,
Sid
答案1
得分: 1
"The Get items connector has the ability to add a filter in OData.
So, if you want to delete item depending a date, you can do that:
Created lt 'addDays(utcnow(), -30)';
Feel free to change the 'Created' column by your 'revision date' column."
英文:
The Get items connector has the ability to add a filter in OData.
So, if you want to delete item depending a date, you can do that:
Created lt 'addDays(utcnow(), -30)'
Feel free to change the "Created" column by your "revision date" column.
答案2
得分: 0
I have written the Filter data query like,
ReviewDate le formatDateTime(addDays(utcNow(), +30), 'yyyy-MM-dd')
英文:
I have written the Filter data query like,
ReviewDate le formatDateTime(addDays(utcNow(), +30), 'yyyy-MM-dd')
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论