Skip to content

Instantly share code, notes, and snippets.

View expiscornovus's full-sized avatar

Dennis Goedegebuure expiscornovus

22 followers · 28 following
View GitHub Profile
@expiscornovus
expiscornovus / FirstDayofNextMonth
Created November 6, 2024 12:36
First Day of Next Month
startOfMonth(addToTime(utcNow(), 1, 'Month'))
@expiscornovus
expiscornovus / RemoveUserfromSharePointGroupbyLoginName
Created October 29, 2024 15:12
Remove User from SharePoint Group by LoginName
{"id":"43f11978-1cde-4d71-80d2-d1728b895ff7","brandColor":"#036C70","connectionReferences":{"shared_office365users":{"connection":{"id":"/crca4_sharedoffice365users_8b60b"}},"shared_sharepointonline":{"connection":{"id":"/exp_sharedsharepointonline_e5efa"}}},"connectorDisplayName":"SharePoint","icon":"https://connectoricons-prod.azureedge.net/u/jayawan/releases/v1.0.1697/1.0.1697.3786/sharepointonline/icon.png","isTrigger":false,"operationName":"Send_an_HTTP_request_to_SharePoint","operationDefinition":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_sharepointonline","operationId":"HttpRequest","apiId":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline"},"parameters":{"dataset":"@parameters('SPOSiteCollection_PowerUsers (exp_SPOSiteCollection_PowerUsers)')","parameters/method":"POST","parameters/uri":"_api/web/sitegroups/getbyname('Custom SharePoint Group')/users/removeByLoginName('@{encodeUriComponent(concat('i:0#.f|membership|',outputs('Get_user_profile_(V2)')?['body/mail'])
@expiscornovus
expiscornovus / ResponseRemoveUserfromSharePointGroupbyLoginName
Created October 29, 2024 15:11
Response Remove User from SharePoint Group by LoginName
{
"d": {
"RemoveByLoginName": null
}
}
@expiscornovus
expiscornovus / URIRemoveUserfromSharePointGroupbyLoginName
Created October 29, 2024 15:05
URI Remove User from SharePoint Group by LoginName
_api/web/sitegroups/getbyname('Custom SharePoint Group')/users/removeByLoginName('@{encodeUriComponent(concat('i:0#.f|membership|',outputs('Get_user_profile_(V2)')?['body/mail']))}')
@expiscornovus
expiscornovus / BodyvalidateUpdateListItemwithoutsharedLockId
Created October 23, 2024 22:36
Body validateUpdateListItem without sharedLockId
{
"formValues":[
{
"FieldName":"TextField",
"FieldValue":"Power Automate for the win!"
}
],
"bNewDocumentUpdate": true
}
@expiscornovus
expiscornovus / BodyvalidateUpdateListItemwithsharedLockId
Created October 23, 2024 22:32
Body validateUpdateListItem with sharedLockId
{
"formValues":[
{
"FieldName":"TextField",
"FieldValue":"Power Automate for the win!"
}
],
"sharedLockId": "@{body('Send_an_HTTP_request_to_SharePoint_-_sharedLockId')['vti_x005f_sourcecontrollockid']}",
"bNewDocumentUpdate": true
}
@expiscornovus
expiscornovus / URIvalidateUpdateListItemwithsharedLockId
Created October 23, 2024 22:31
URI validateUpdateListItem with sharedLockId
_api/web/lists(guid'@{parameters('SPO_Library_PowerUsers_FileLockHandling (exp_SPO_Library_PowerUsers_FileLockHandling)')}')/items(@{variables('ItemID')})/validateUpdateListItem
@expiscornovus
expiscornovus / URIGetsharedLockIdpropertyvalue
Created October 23, 2024 22:26
URI Get sharedLockId property value
_api/web/lists(guid'@{parameters('SPO_Library_PowerUsers_FileLockHandling (exp_SPO_Library_PowerUsers_FileLockHandling)')}')/items(@{variables('ItemID')})/File/Properties?$select=vti_x005f_sourcecontrollockid
@expiscornovus
expiscornovus / ConditionExpressionodata.nullisnotequaltotrue
Created October 23, 2024 22:23
Condition Expression odata.null is not equal to true
body('Send_an_HTTP_request_to_SharePoint_-_lockedByUser')?['odata.null']
@expiscornovus
expiscornovus / URIGetLockedByUser
Created October 23, 2024 22:21
URI Get LockedByUser
_api/web/lists(guid'@{parameters('SPO_Library_PowerUsers_FileLockHandling (exp_SPO_Library_PowerUsers_FileLockHandling)')}')/items(@{variables('ItemID')})/File/lockedByUser