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

All responses (3)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report
Re: One line in my flow convert to PDF

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.
TB50 9 on at

Like (0)

Report

Re: One line in my flow convert to PDF

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...
v-litu-msft on at

Like (0)

Report

Re: One line in my flow convert to PDF

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.