Get App Modified By value of File
How to retrieve the App Modified By (AppEditor) value of a file in a SharePoint Online library using a Power Automate flow. This could be useful to check if the File has been updated by a Power Automate flow.
URI
_api/web/lists/getbytitle('@{variables('ListName')}')/items(@{triggerBody()?['ID']})/FieldValuesAsText?$select=AppEditor |
Headers
{ | |
"Accept": "application/json;odata=nometadata", | |
"Content-Type": "application/json;odata=nometadata" | |
} |
Body
Not applicable
Screenshot with example
Sample data
Site Address – https://contoso.sharepoint.com/sites/PowerUsers
ListName – App check
Expected response
Value of the AppEditor field, in this case Microsoft Power Platform
{ | |
"AppEditor": "Microsoft Power Platform" | |
} |
Copy/paste example (classic designer)
{"id":"67f4ee67-a245-41d6-ba6a-10adec0d50f4","brandColor":"#036C70","connectionReferences":{"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":"GET","parameters/uri":"_api/web/lists/getbytitle('@{variables('ListName')}')/items(@{triggerBody()?['ID']})/FieldValuesAsText?$select=AppEditor","parameters/headers":{"Accept":"application/json;odata=nometadata","Content-Type":"application/json;odata=nometadata"}},"authentication":"@parameters('$authentication')"},"runAfter":{"Initialize_variable":["Succeeded"]}}} |
Resources
SP.ListItem.fieldValuesAsText Property
That’s it, Happy testing!