web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create new items in Sh...

Power Automate

Answered

Create new items in SharePoint List when new respondent submit the survey with attachment

(0) Share

Report

Report

Posted on by ABCDEFG1234

24

Hi All Expert,

I copy a flow that can create the new item on my SharePoint List with attachment when a new respondent submit a survey and upload a file.

But unluckily, only the PDF & Media file can be added as the attachment when the SharePoint Create a flow.

The office file: Word, Excel, SharePoint cannot successfully created. It is because there is an additional string at the end of the file path:

&action=default&mobileredirect=true

Office file path demo:

https://testing.sharepoint.com/sites/demo/_layouts/15/Doc.aspx?sourcedoc=%7BA1A69%7D&file=123_user%20test.docx&action=default&mobileredirect=true

PDF & Media demo:

https://testing.sharepoint.com/sites/demo/Shared%20Documents/Apps/Microsoft%20Forms/Testing%20(Teams)/Question/FY1234%2010th%20abc%20bacd%20badcs%20(28%20JAN%202021)_user%20u.pdf

The get file content using file path is unsuccessful.

Please check my flow:

May I know there any solution to extract the office file for this case?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @ABCDEFG1234 ,

if the only problem is the string "&action=default&mobileredirect=true" at the end of the url, you can remove it with the replace(...) expression to replace that string by nothing ('') in the url.

replace([link],'&action=default&mobileredirect=true','') Note: replace [link] with the link dynamic content

Was this reply helpful? Yes No
Verified answer

ABCDEFG1234 24 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom_riha,

I used another method to replace the dynamic [link] element.

I put the fixed path like: Shared_Document/Apps/Forms/Question/Testing/[name] instead of the [link].

Thank you for your help

Was this reply helpful? Yes No
ABCDEFG1234 24 on at

Like (0)

Report
Copy link

Link copied!

It seems replace JSON function cannot apply for the dynamic content. The flow warning me.

Was this reply helpful? Yes No

Join the conversation