Saving file to Sharepoint from MS forms/Approval

(0) Share

Report

Posted on by Jtaylor95

126

Flow:

When a response is submitted via MS Forms > gets form response > creates approval.

Once approved > file saved to Sharepoint

BUT that file is saving as a same textedit format. How do I solve this to save in the original format (PDF,Jpeg, Excel etc)

Screenshot 2023-01-17 at 17.35.23.png

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Jtaylor95 ,

Could you please show your complete flow?
Have you successfully obtained the attachments uploaded in MSForm?
If you want to rename the attachment you can try:

Best Regards,
Dezhi

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Hi the flow is:

Expressions:

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Jtaylor95 ,

I noticed that you have saved the files you got from MSform into an array, so you also need to use an Apply to each acton when saving these files.
Then if you want to rename your files, you can try to use Split() to get the filename suffix.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Unfortunately I am now getting the following error:

From this setup:

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Jtaylor95 ,

This looks like the json in your array is malformed.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

I amended the json but getting:

The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Could not find member 'ContentBytes' on object of type 'ApprovalsConnectorFileAttachment'. Path 'attachments[0].ContentBytes', line 1, position 540.'.'.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Jtaylor95 ,

Sorry, I forgot that these two actions require different json formats, you can create two arrays with different json formats for different actions.

Best Regards,
Dezhi

Was this reply helpful? Yes No