Answered

One line in my flow convert to PDF

(0) Share

Report

Posted on by TB50

Hi All,

I have created a MS form with PDF download, then a flow to excel to transfer just the information I need, however when the flow copies over the PDF address it adds text so the PDF link no longer works.

1. is there away to stop the adding of text

2. is there away to convert that one line into a PDF picture view?

thanks

TB50

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TB50,

Could you please add some screenshots about the issue?

If you could show us how you stucture the Flow, it will help us assist you better.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
TB50 9 on at

Like (0)

Report
Copy link

Link copied!

This is what is the original form excel file ..

https://mismunich-my.sharepoint.com/personal/tbarker_mis-munich_de/Documents/Apps/Microsoft%20Forms/Reimbursement%20of%20expenses/Please%20upload%20a%20copy%20of%20the%20invoice%20%20receipt%20in%20pd/00206D995E2D200610132946_Tina%20Barker%206.pdf

this is what goes into the excel file after the flow..

[{"name":"00206D995E2D200610132946_Tina Barker 6.pdf","link":"https://mismunich-my.sharepoint.com/personal/tbarker_mis-munich_de/Documents/Apps/Microsoft%20Forms/Reimbursement%20of%20expenses/Please%20upload%20a%20copy%20of%20the%20invoice%20%20receipt%20in%20pd/00206D995E2D200610132946_Tina%20Barker%206.pdf","id":"01PZV7QQSS5M6QHZTHXNHZZT4AHUV2ZWGF","type":null,"size":241697,"referenceId":"01PZV7QQQ6ZFN7BZIH25FKZSLERGZOTAHL","driveId":"b!WfEBNJApvkSI3fg4LIlJAjEh4wynF_ZDirU4EbZF71znbWtK4pG4SaroFsa-Eno0","status":1,"uploadSessionUrl":null}]

this is the flow...

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @TB50,

Sorry the first link about excel I can't open it cause permission but I think I understant what you want now.

1. is there away to stop the adding of text

Yes, you could use expression to extract the link part in the upload file:

outputs('Get_response_details')?['body/r61ca06fcadfb4d03b25782c99b6dd22e'][0]['link']

The string after the "body/" is question code, you could put the question into an action, then click the peek code then you'll find the question code:

2. is there away to convert that one line into a PDF picture view?

No, there is no way could do this. Currently, this feature couldn't support via Flow.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No