英文:
Get Items with some date column less than 3 days ago in logic app
问题
我正在Azure Logic App中工作,从一个创建不到3天的SharePoint列表中获取项目。
我想初始化一个日期变量,但是在Logic App中没有日期类型。
有人知道如何创建一个过滤器的X:
"Created lt X",其中X是3天前的日期吗?
谢谢。
英文:
I am working in Azure Logic App to get items from a SharePoint list created less then 3 days ago.
I wanted to initialize a date variable but there isn't date type in Logic app.
Anyone has an idea how to create X for a filter:
"Created lt X" where X is 3 days ago?
Thank you
答案1
得分: 0
X = string(addDays(utcNow(),-3)) 的中文翻译是:X = 将日期转换为字符串(addDays(utcNow(),-3))
英文:
X = string(addDays(utcNow(),-3))
答案2
得分: 0
这是一个基本示例,请注意,没有日期变量,它们都被视为字符串...
表达式 = formatDateTime(addDays(utcNow(), -3), 'yyyy-MM-ddThh:mm:ssZ')
请注意,我使用了gt
(大于),但你也可以使用ge
(大于或等于),eq
(等于),le
(小于或等于)或其他支持的比较运算符。
英文:
This is a basic example and be aware, there is no such thing as a date variable, they're all just treated as strings ...
Expression = formatDateTime(addDays(utcNow(), -3), 'yyyy-MM-ddThh:mm:ssZ')
Be aware, I used gt
(greater than) but you can use ge
(greater than or equal to), eq
(equal to), le
(less than or equal to) or any of the other supported comparison operators.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论