Upload SharePoint attachment to DataVerse

[amg92]

I am having issues uploading an attachment from SharePoint into the DataVerse. I have tried various methods such as "Upload a file or an image" and "Get Attachments" with no luck.

[rzaneti]

Hi @amg92 ,

Just to confirm: does your Dataverse table have a column with file data type? If yes, please share an image of your current flow design and/or the error that you are receiving. Make sure to remove any sensitive data before sharing it.

[amg92]

Yes, I have three columns with file data type. If I input an attachment using Power Apps, the DataVerse will store the form. But I am trying to take a form from Microsoft Forms or SharePoint and upload in to the Dataverse. I have tried using two different methods, method one on the left parallel path and method two on the right.

On the left, I get an error stating "Action 'Upload_a_file_or_an_image' failed." Badrequest. The provided workflow action input is not valid.

On the right, I get an error saying NotFound.

[rzaneti]

Hi @amg92 ,

I ran some tests here and found a solution. 

First, add a 'Compose' action before your parallel branch, and use this expression: 

first(json(outputs('Get_response_details')?['body/r776a5868cec54310946102573d57121c'])), passing the dynamic content from your file Form question to the json() expression.

After that, add a 'Get file content' action from OneDrive connector (apparently the MS Forms files are uploaded to OneDrive, by default) and pass as input the driveId and the Id properties from the compose, separated by a dot.  

You will need to access these properties via expressions, and they may look like this:

• right side: outputs('Compose')['driveId']
• left side: outputs('Compose')['id']

Then, just pass the 'File content' dynamic content to the 'Content' input and it will be properly uploaded to your DV table: 

The flow ran without any issues (you can ignore the 2 last actions, as I just included it to test if the uploaded files were working fine):

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 

[amg92]

When I use the same dynamic content as get response details I get the following error.

 If I use what you recommended I get the following.

[rzaneti]

Hi @amg92 ,

Could you please share the outputs from your 'Get response details' action, or assign the 'upload file' answer dynamic content to a 'Compose' action and share its outputs? The idea here is to identify how Power Automate is reading the files that you are uploading in MS Forms: usually, it would be reading as a JSON stored into a string, but clearly it is not happening in your end, as both errors messages refer to a null and to an integer.

When sharing any of these outputs, make sure to remove any sensitive content.  

[amg92]

Example file output from Get response detail:

Compose action input: 

first(json(outputs('Get_response_details')?['body/r218xxxxxxxxxxxxxxxxx']))

[rzaneti]

Hi @amg92 ,

Your flow looks fine. I recommend you to take 2 tests to try to identify potential errors:

• Assign only outputs('Get_response_details')?['body/r218xxxxxxxxxxxxxxxxx'] to a string variable and check if it displays the JSON as text (which will looks identical to the output that you just shared)
• Create a new Form with a file question (this is just for test purposes) and check if the expression is working properly (you can do it in a different flow as well).