With({x:ThisItem.Created},With({y:Now()},If(DateDiff(x,y,TimeUnit.Seconds)<60,DateDiff(x,y,TimeUnit.Seconds)&" sec ago",If(DateDiff(x,y,TimeUnit.Minutes)<60,DateDiff(x,y,TimeUnit.Minutes)&" min ago",If(DateDiff(x,y,TimeUnit.Hours)<24,DateDiff(x,y,TimeUnit.Hours)&" hr ago",If(DateDiff(x,y,TimeUnit.Days)<30,DateDiff(x,y,TimeUnit.Days)&" day(s) before",If(DateDiff(x,y,TimeUnit.Months)<12,DateDiff(x,y,TimeUnit.Months)&" month(s) ago",x)))))))
Subscribe to:
Post Comments (Atom)
Add Service Principle support in Custom Connector
then search for "Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Applicati...
-
Created ge datetime '@{outputs('Get_item_Last_Run')?['body/LastRun']}' // add '' and the column needed
-
SortByColumns(Filter(coll_Area, Result in Filter(AddColumns('Maintenance Notification',"AreaName",Trim( Last(First...
-
Lets assume [colName] is your collection, [column] is your column & you want to convert it into a string with items in the Title column...
No comments:
Post a Comment