In this blog, we will learn how to upload a file from Microsoft Dataverse to SharePoint, in my account entity I have a custom file type column “Account File”, Flow will get triggered when user uploads file in any column.

Implementation:

• For triggering the flow, we are using action from Microsoft Dataverse “When a row is added or modified”.
• Select table, here we have selected “Accounts”.
• In “Select columns” we have added a logical name of file type column.

• Now add “Download a file or an image” action from Microsoft Dataverse.
• Select “Accounts” in table name.
• Add dynamic content to get GUID in Row ID.
• And select your file type column in Column name.

• Add a “Get a row by ID” action from Microsoft Dataverse.
• Select table name as “Accounts”.
• Add dynamic content to get GUID in Row ID.

• Now add an action from SharePoint “Create file”.
• Select the site where you want to upload the file.
• Provide folder path.
• In “File Name”, we have added dynamic content to get account name from trigger.
• After adding the dynamic content just add the file type, We have added “.csv”.
• And in “File Content” add dynamic content of “File or Image Content.”

Output:

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here