PowerPlatform Code Collection

Posted on Edited on In Views:

虽说是低代码，但是有很多有用的代码，记录下来，方便以后使用

concat(utcNow('yyyy'),'-01-01')
concat(add(int(utcNow('yyyy')), 1), '-01-01')
formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Tokyo Standard Time'),'ddHHmm')

field_9 eq '有給休暇' and OData__x5ba1__x6279__x72b6__x6001_ eq '許可' and inserttime ge '' and inserttime lt ''

{
  "UserEmail": "@{variables('flagCurrentMail')}",
  "UserDisplayName": "@{items('Apply_to_each')?.OData__x6c0f__x540d_}",
  "Year": "@{int(items('Apply_to_each')?.req_year)}",
  "LeaveDays": @{variables('allLeaveDaysThisYear')},
  "Year0": "@{sub(int(items('Apply_to_each')?.req_year),1)}",
  "LeaveDays0": 0
}