Cloud Flow that creates Sharepoint folder named after users business unit on dataverse.

Question

Hey all,

I’m questioning my sanity as I have not been able to figure this out.

The goal is to create a flow that creates a folder named after the users owning team. Once this is accomplished I will create a condition that if the folder exists already it will not create a duplicate and will use that folder to store new records there as sub folders.

So far my flow is like this

1. Dataverse: when a row is added, modified, or deleted

• scope is organization and running the flow as row owner.

2. Get folder metadata> select file path
3. Condition: share point : body is equal to null
4. If yes: Get row by ID: table team> Owning Team value
5. Create sharepoint folder> folder path Team Name.

This is where it fails. Error says bad request. Path for the new folder is not provided.

I’m so confused as I did provide it in the previous step. Any suggestions, tips, assistance ?

Answer 1

Dear Mario Arzamendi,

Good day!!

I understand your concern but since it’s related Dataverse using Power Automate, I would like to request you to post your concern in the Microsoft Power Automate Community - Power Platform Community to get the detailed help from the experts.

Apologies for redirecting you to different community as the members in the category posted focus on the users with the Microsoft 365 concern and have limited knowledge on the Dataverse & Power Automate, so to get the fast and better assistance, we have redirected you in the correct path.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

Sophia