web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

File Import using Data Entities and Logic Apps

(0) ShareShare
ReportReport
Posted on by 10

Hi there,

I'm in charge of creating a solution that allows me to consume files using a custom data entity, through Logic Apps. I already created this custom entity and everything works as intended if I manually import a file. My idea here is to create a Logic Apps that allows me to import multiple files (one by one) during the day, automatically.

These files exist in an SFTP server and the idea is to import them (through the said data entity) and move them into another folder, inside the SFTP server. So far I've seen some guides regarding similar solutions, but none of them seem to capture exactly my idea (since many of them use OneDrive and not SFTP connections). 

I've managed to define a recurrence as the main stone in my Logic Apps workflow and then added a "List Folder" connector, which allows me to list all SFTP server folder contents. I'm now having issues creating a loop in order to import each file that exists inside that said folder, besides also not understanding how to call the import project (data entity) to import these files.

Is it possible to have some guidance regarding this matter?

I have the same question (0)
  • AnithaEswaran Profile Picture
    2,032 on at
    RE: File Import using Data Entities and Logic Apps

    Hi,

    Loop will be automatically created in logic apps when you include 'Get File contents' connector.

    hope the below screenshot gives you the clue

    pastedimage1653308767981v1.png

  • joaosilva Profile Picture
    10 on at
    RE: File Import using Data Entities and Logic Apps

    Hi Anitha Eswaran ,

    Thank you for your quick response. I have a couple of questions (I'm a very basic user of Logic Apps, I'm sorry):

    1. When using List Folder (SFTP) connector, I'm not choosing any "root directory", I'm simply using /. Is that enough to force the root directory to be (literelly) the initial path of folder tree?
      1. I then chose /Folder1/Folder2 as my "Folder path", inside this connector parameters. So, root path is "/" and then we access Folder 1 -> Folder 2 and files will be there.
    2. When using Get File Content (SFTP) connector, it asks me for a file path (which can include the file extension). Since there are multiple files with different names (that, once again, I need to import one after another), what should I actually write here?
      1. The For Each statement only appears if I select Dynamic Content, but there are multiple options and they all seem the same to me. I don't understand their impact in the final solution.
  • AnithaEswaran Profile Picture
    2,032 on at
    RE: File Import using Data Entities and Logic Apps

    Hi,

    1. You should select a proper root directory. If SFTP connector is selected for the first step, it asks for credentials. Enter proper details . Now when you browse the 'Folder' icon on 'List folder' , it will list the folder structure to navigate and select the right folder for you.

    2. File content - when you keep the cursor on the path, you will get the option like below. 

    pastedimage1653317031135v1.png

    Try to read the output of each step after execution. This way you can get some idea on what values are to be passed. I learnt this way :) 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,177

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 860 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans