Skip to content

Instantly share code, notes, and snippets.

View expiscornovus's full-sized avatar

Dennis Goedegebuure expiscornovus

View GitHub Profile
@expiscornovus
expiscornovus / CreateTextField
Created June 15, 2024 12:04
Create Text Field
{"id":"bdf22962-73bb-4823-95dc-a8e32269dab7","brandColor":"#036C70","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/exp_sharedsharepointonline_e5efa"}}},"connectorDisplayName":"SharePoint","icon":"https://connectoricons-prod.azureedge.net/releases/v1.0.1694/1.0.1694.3752/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/lists/getbytitle('@{variables('ListName')}')/Fields","parameters/headers":{"Accept":"application/json;odata=verbose","Content-Type":"application/json;odata=verbose"},"parameters/body":"{ \n\"__metadata\": { \"type\": \"SP.FieldText\" }, \n\"FieldTypeKind\": 2,
@expiscornovus
expiscornovus / ResponseCreateTextField
Created June 15, 2024 12:01
Response Create Text Field
{
"d": {
"__metadata": {
"id": "https://contoso.sharepoint.com/sites/PowerUsers/_api/Web/Lists(guid'9f7a4039-16f1-4aec-b912-957f2e6ecf8e')/Fields(guid'b4d21304-7a82-4c68-a70c-5dcaf2c7f541')",
"uri": "https://contoso.sharepoint.com/sites/PowerUsers/_api/Web/Lists(guid'9f7a4039-16f1-4aec-b912-957f2e6ecf8e')/Fields(guid'b4d21304-7a82-4c68-a70c-5dcaf2c7f541')",
"type": "SP.FieldText"
},
"DescriptionResource": {
"__deferred": {
"uri": "https://contoso.sharepoint.com/sites/PowerUsers/_api/Web/Lists(guid'9f7a4039-16f1-4aec-b912-957f2e6ecf8e')/Fields(guid'b4d21304-7a82-4c68-a70c-5dcaf2c7f541')/DescriptionResource"
@expiscornovus
expiscornovus / BodyCreateTextField
Created June 15, 2024 11:56
Body Create Text Field
{
"__metadata": { "type": "SP.FieldText" },
"FieldTypeKind": 2,
"Title": "Floor"
}
@expiscornovus
expiscornovus / URICreateTextField
Created June 15, 2024 11:55
URI Create Text Field
_api/web/lists/getbytitle('@{variables('ListName')}')/Fields
@expiscornovus
expiscornovus / UpdateAverageRatingField
Created May 20, 2024 11:12
Update Average Rating Field
{"id":"14cc7ad1-3514-4a4e-8702-4b8bbf1a505e","brandColor":"#036C70","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/exp_sharedsharepointonline_e5efa"}}},"connectorDisplayName":"SharePoint","icon":"https://connectoricons-prod.azureedge.net/releases/v1.0.1685/1.0.1685.3700/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/Microsoft.SharePoint.Portal.RatingSettings.SetListRating(listID=@a1,ratingType=@a2)?@a1=@{encodeUriComponent(variables('ListId'))}&@a2=2","parameters/headers":{"Accept":"application/json;odata=verbose","Content-Type":"application/json;odata=verbose"}},"authenticati
@expiscornovus
expiscornovus / ResponseUpdateAverageRatingField
Created May 20, 2024 11:11
Response Update Average Rating Field
{
"d": {
"SetListRating": null
}
}
@expiscornovus
expiscornovus / URIUpdateAverageRatingField
Created May 20, 2024 10:27
URI Update Average Rating Field
_api/Microsoft.SharePoint.Portal.RatingSettings.SetListRating(listID=@a1,ratingType=@a2)?@a1=@{encodeUriComponent(variables('ListId'))}&@a2=2
@expiscornovus
expiscornovus / ResponseCreateAverageRatingField
Created May 15, 2024 11:30
Response Create Average Rating Field
{
"d": {
"SetListRating": null
}
}
@expiscornovus
expiscornovus / CreateAverageRatingField
Created May 15, 2024 11:30
Create Average Rating Field
{"id":"46f9d52a-3611-40c6-b0d0-29af87793b82","brandColor":"#036C70","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/exp_sharedsharepointonline_e5efa"}}},"connectorDisplayName":"SharePoint","icon":"https://connectoricons-prod.azureedge.net/releases/v1.0.1685/1.0.1685.3700/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/Microsoft.SharePoint.Portal.RatingSettings.SetListRating(listID=@a1,ratingType=@a2)?@a1=@{variables('ListId')}&@a2=1","parameters/headers":{"Accept":"application/json;odata=verbose","Content-Type":"application/json;odata=verbose"}},"authentication":{"type":"Raw","v
@expiscornovus
expiscornovus / URICreateAverageRatingField
Last active May 20, 2024 10:23
URI Create Average Rating Field
_api/Microsoft.SharePoint.Portal.RatingSettings.SetListRating(listID=@a1,ratingType=@a2)?@a1=@{encodeUriComponent(variables('ListId'))}&@a2=1