'How to retrieve latest file from SharePoint to blob using logic app?

I am getting the everyday one new file in my SharePoint. My file is stored in "Shared Document/Data"

Below is my logic app flow. I used Get Files and I am selecting Document and included Nested items as I am getting new data under "data folder" which is stored in the Shared document.

I used Filter Array to get the last modified file with less than or equal to 5m so I can get the latest file

I am facing two issues,

  1. It takes all the files from SharePoint under "Get Files" and the filter array is not working.

  2. I have used create blob wrongly

Can anyone advise me on how to do this?

enter image description here

azureazure-logic-appsazure-cloud-services


Solution 1:[1]

Follow the workaround

You can use the below Trigger & Connector

  • Sharepoint (Trigger) - When a file is created or modified in a folder

You can use this connector to select and get the exact Directory to fetch the recent Modified/Created File.

  • Azure Blob Storage (Connector)- Create Blob (V2) Use this connector to create a blob.

enter image description here

Result

enter image description hereenter image description here

Modified file fetched and added in a Blob

enter image description here

Refer here for more information

Updated Answer

Here is the list of available directories in SharePoint that will be shown in a SharePoint Trigger. You can select according to your requirement.

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions