Monday, November 4, 2024

Find the owner of a Microsoft Form

Here's a hack to determine who created (and is therefore the owner of) a Microsoft Form:

1) Grab the ID of the form:

https://forms.office.com/pages/responsepage.aspx?id=mHcFBexHuEeJJeYuEg8GOReFjaXIXp5Gn24tRTWqhexUNUw2RDSVY1QkwxV040REZSRy4u&route=shorturl

2)  Append the ID to this url:


and go to the url.  You should see an error like this:




3)  View the source of that page, and search for /users/, and you'll see a url like this:

https://forms.office.com/formapi/api/05057798-47ec-47b8-8925-e62e120f0639/users/a58d8517-5ec8-469e-9f6e-2d435aa908ec

The ID of the user is highlighted.

4)  Go to Azure Portal and do a search for the User ID.  The user should show up in the results.

Monday, April 1, 2024

Power Automate - "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: location.'"

 I've noticed on occasion that when calling a child workflow in power automate, I'd get the following error message:

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: location.'.

From what I can tell, it seems to happen if I save the child workflow in the "New Designer" mode, which adds location as a required field:

{
  "type""Request",
  "kind""Button",
  "inputs": {
    "schema": {
      "type""object",
      "properties": {
        "number": {
          "title""ID Start",
          "type""number",
          "x-ms-dynamically-added"true,
          "description""Please enter the Employee ID to start with",
          "x-ms-content-hint""NUMBER"
        },
        "number_1": {
          "title""ID End",
          "type""number",
          "x-ms-dynamically-added"true,
          "description""Please enter the Employee ID to end with",
          "x-ms-content-hint""NUMBER"
        },
        "location": {
          "type""object",
          "properties": {
            "fullAddress": {
              "title""Full address",
              "type""string",
              "x-ms-dynamically-added"false
            },
            "address": {
              "type""object",
              "properties": {
                "countryOrRegion": {
                  "title""Country/Region",
                  "type""string",
                  "x-ms-dynamically-added"false
                },
                "city": {
                  "title""City",
                  "type""string",
                  "x-ms-dynamically-added"false
                },
                "state": {
                  "title""State",
                  "type""string",
                  "x-ms-dynamically-added"false
                },
                "street": {
                  "title""Street",
                  "type""string",
                  "x-ms-dynamically-added"false
                },
                "postalCode": {
                  "title""Postal code",
                  "type""string",
                  "x-ms-dynamically-added"false
                }
              },
              "required": [
                "countryOrRegion",
                "city",
                "state",
                "street",
                "postalCode"
              ]
            },
            "coordinates": {
              "type""object",
              "properties": {
                "latitude": {
                  "title""Latitude",
                  "type""number",
                  "x-ms-dynamically-added"false
                },
                "longitude": {
                  "title""Longitude",
                  "type""number",
                  "x-ms-dynamically-added"false
                }
              },
              "required": [
                "latitude",
                "longitude"
              ]
            }
          }
        },
        "key-button-date": {
          "title""Date",
          "type""string",
          "x-ms-dynamically-added"false
        }
      },
      "required": [
        "number",
        "number_1",
        "location",
        "key-button-date"
      ]
    }
  },
  "metadata": {
    "operationMetadataId""2447e36d-f686-4dfd-aefa-c73d0383839f4"
  }
}

The only way I've found to fix it is to delete the manual trigger of the child flow, in the old designer view, and recreate the manual trigger from scratch.  And then update anywhere your original parameters were used.