Hi There,
In SharePoint, "Publishing HTML" fields are not directly supported in the 'Get file properties' action in Power Automate due to their complex nature.
You might can use these steps -
Use the 'Get files (properties only)' action to retrieve the item and its ID from the document library.
Use this action to send a REST API request to SharePoint to fetch the specific item details including the Publishing HTML field. Select the site where your document library resides.
Use method GET, Url - /api/web/lists/getbytitle('YourDocumentLibraryName')/items('ItemID')?$select=YourPublishingHtmlFieldName. Headers like ‘application/json;odata=verbose’
content-type - ‘application/json;odata=verbose’
The HTML field’s content will be in the response body. Use the ‘Parse JSON’ action to extract the value. use body('Send_an_HTTP_request_to_SharePoint')?['d']['YourPublishingHtmlFieldName']
Now you can use the extracted HTML value in subsequent actions in your flow to copy it to the DataVerse table or any other desired operations.
Ensure you have the necessary SharePoint permissions to send HTTP requests and access the document library and its items.
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
