Get file metadata Action in SharePoint Connector(Power Automate Cloud flows)
This action retrieves additional information about a file on SharePoint, such as the file name and who updated it.
It requires the ID of the file as a parameter, but is used infrequently because if the ID of the file is known, other metadata is often obtained as well.
Cases in which it can be used effectively are limited to the following
- Other metadata items are needed when only the ID of the file is stored in a file, etc.
- Other metadata items are needed in addition to the information that can be retrieved by the "Get attachments" action.
- 1. How to use
- 1.1. Parameters.
- 1.2. Dynamic contents
- 1.2.1. Id
- 1.2.2. Name
- 1.2.3. Filename with extension
- 1.2.4. Folder path
- 1.2.5. Full path
- 1.2.6. IsFolder
- 1.2.7. Created
- 1.2.8. Created By Email
- 1.2.9. Created By DisplayName
- 1.2.10. Modified
- 1.2.11. Modified By Email
- 1.2.12. Modified By DisplayName
- 1.2.13. Thumbnail Small
- 1.2.14. Thumbnail Medium
- 1.2.15. Thumbnail Large
- 1.2.16. Link to item
- 2. Links
How to use
Select the "SharePoint" connector when adding steps to the flow.
Select "Get file metadata" from the "Actions" menu.
Set parameters.
Parameters.
Site Address
Specify the SharePoint group where the file whose metadata is to be retrieved is stored.
File
Specify the ID of the file stored in SharePoint.
Select a file with the directory icon on the right.
When selected, it looks like a file path, but it is only a display and the substance is an ID.
If you delete the specified file and then create a file with the same name, it will be treated as a different file.
In such a case, an error will occur that the file does not exist, so it must be re-specified in the flow.
Dynamic content.
Set the ID of the following triggers/actions dynamic content.
Those that retrieve file contents at the same time are excluded.
Triggers.
Actions.
- Get items
- Create file
- Update file
- Delete file
- Create folder
- List folder
- Move folder
- Copy folder
- List root folder
- Copy file
- Get file metadata
Dynamic contents
Only additional information can be obtained.
If you need the file content, which is the content of the file, use the "Id" to retrieve it with the "Get File Content" action.
Id
File identifier.
Used to specify when a SharePoint operation action is used.
Name
File/Folder name without extension.
Filename with extension
File/Folder name with extension.
Folder path
Path of the folder to which it belongs.
Full path
"Folder path" + "Filename with extension".
IsFolder
- True … Folder
- False … File
Created
Registration date/time of the file/folder.
Coordinated Universal Time.
In many cases, a "Convert time zone" is required.
Created By Email
Email address of the file/folder creator.
Created By DisplayName
Display name of the file/folder creator.
Modified
Modification date/time of the file/folder.
Coordinated Universal Time.
In many cases, a "Convert time zone" is required.
Modified By Email
Email address of the file/folder modifier.
Modified By DisplayName
Display name of the file/folder modifier.
Thumbnail Small
URL of thumbnail (small size).
Thumbnail Medium
URL of thumbnail (medium size).
Thumbnail Large
URL of thumbnail (large size).
Link to item
URL of the file/folder.
---