Flow Creating SharePoint Folder, Then Inserting Data

[Dallas-Chambers]

Hello All, 

I have a flow that will run once a day, it will pull data from D365 F&O and put it into SharePoint site. I would like it to create a new folder then add all the records in that folder. 

An example would be:

• 24 Hour Period Flow Runs
  • Creates new folder in a parent folder (Cycle Count Report Folder/Current Date/Time) - Bold = Parent
    • Inserts records pulled from D365 F&O into the new sub folder
• Repeats

I feel that I am limited with my knowledge on what to do next. I have had no luck so far with getting this to work. I am teaching myself how to use power automate as I go.

Any Info is helpful!!

@abm 

[annajhaveri]

@Dallas-Chambers  What issue are you facint with current flow? Is it creating the folder? In Create Item i see that you have used Current Item in the List Name, which seems incorrect. You need to use actual list name, which i think is Cycle Count Accuracy. Usually items are not created within folder, is there any specific requirement that you want to create folders in list? You can save the same information as folder name in the column in the list as well instead of creating folder.

[abm]

Hi @Dallas-Chambers 

Please try the following:

Above compose action step expression is as follows:

formatDateTime(utcNow(),'dd-MM-yyyy')

Map the compose 2 below. See below step

Insert the items under the folder

Thanks