Skip to content

Instantly share code, notes, and snippets.

View expiscornovus's full-sized avatar

Dennis Goedegebuure expiscornovus

View GitHub Profile
@expiscornovus
expiscornovus / addusertoyammergroup.json
Created February 9, 2021 21:07
Add a user to a Group via Yammer REST API
Method - POST
URI - https://www.yammer.com/api/v1/group_memberships.json
Headers -
{
"Authorization": "Bearer @{variables('YammerAccessToken')}",
"content-type": "application/json; charset=utf-8"
}
Body -
{
"user_id": "@{variables('User_id')}",
@expiscornovus
expiscornovus / D365FOAlerttriggercondition.json
Created February 17, 2021 20:44
D365FO Alert trigger condition
@equals(triggerOutputs()?['body/RuleId'], '000073')
@expiscornovus
expiscornovus / D365FOAlertBusinessEventparsejsonschema.json
Created February 17, 2021 20:48
D365FO Alert Business Event parse json schema
{
"type": "object",
"properties": {
"BusinessEventId": {
"type": "string"
},
"ControlNumber": {
"type": "integer"
},
"DataAreaId": {
@expiscornovus
expiscornovus / SalesOrderHeadersV2FilterQuery.json
Created February 17, 2021 20:53
SalesOrderHeadersV2 Filter Query
SalesOrderNumber eq '@{body('Parse_JSON')?['KeyValue1']}'
@expiscornovus
expiscornovus / WorkersFilterQuery.json
Created February 17, 2021 21:13
Workers Filter Query
PersonnelNumber eq '@{outputs('Lists_items_present_in_table_-_SalesOrderHeadersV2')?['body/value']?[0]?['OrderTakerPersonnelNumber']}'
@expiscornovus
expiscornovus / PrimaryContactEmailExpression.json
Created February 17, 2021 23:07
Primary Contact Email Expression
outputs('Lists_items_present_in_table_-_Workers')?['body/value']?[0]?['PrimaryContactEmail']
@expiscornovus
expiscornovus / D365FOSalesOrderDeliveredAlertAdaptiveCard.json
Created February 17, 2021 23:20
D365FO Sales Order Delivered Alert Adaptive Card
{
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"type": "AdaptiveCard",
"version": "1.2",
"body": [
{
"type": "TextBlock",
"size": "Large",
"weight": "Bolder",
"id": "ubsTitle",
@expiscornovus
expiscornovus / SavePageAsDraft_EmbedWebPart.json
Last active July 15, 2021 10:29
SavePageAsDraft SharePoint Page with Embed WebPart
Method
POST
URI
_api/sitepages/pages(@{body('Parse_JSON')?['d']?['Id']})/SavePageAsDraft
Headers
{
"content-type": "application/json;odata=nometadata",
"Accept": "application/json;odata=verbose"
@expiscornovus
expiscornovus / ColumnFormattingCreatePageButton.json
Created February 22, 2021 19:28
Column Formatting Create Page Button
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"yourflowid\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover"
},
@expiscornovus
expiscornovus / TriggerExpressionsForVariables.json
Last active February 25, 2021 21:14
Trigger Expressions For Variables
trigger()?['inputs']['parameters']['table']
trigger()?['inputs']['parameters']['dataset']
split(trigger()?['inputs']['parameters']['dataset'], '/sites')?[0]
triggerBody()['text']