cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adil365
New Member

Create new Sharepoint folders for each Dataverse row, with folder name = row's name

Hi,

 

I'm trying to build a on-demand/instant flow that when triggered, it will create a new Sharepoint folder for each Dataverse row, with the folder name the same as the row's name. The Dataverse table I'm referencing has 107 records so the flow should create 107 folders. 

 

Here's my basic setup.

1. List Rows - Dataverse - Table referenced with 107 rows

2. Create SharePoint Folder parent folder in proper location

3. Create SharePoint Subfolders based on the "Name" column, using "Apply to each" action

 

Flow:

Adil365_2-1644537444303.png

 

Adil365_1-1644537377050.png

 

 

Issue:

 

Adil365_0-1644536972125.png

 

Message:

The execution of template action 'Apply_to_each_-_List_Rows_Name' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_-_List_Rows')?['pl_name']' is of type 'String'. The result must be a valid array.

 

 

Any help would be appreciated!

 

Thanks,

Adil

 

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @Adil365 :

Please try:

vbofengmsft_0-1644916063994.png

Best Regards,

Bof

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,035)