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

getappmodifiedbyvalueoffile

Expected response

Value of the AppEditor field, in this case Microsoft Power Platform

{
"AppEditor": "Microsoft Power Platform"
}

getappmodifiedbyvalueoffile_example

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!

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.