Possible to save variable to local folder?

(0) Share

Report

Posted on by nicklim

391

Hi, I have a power automate cloud flow that triggers a PAD flow when an email arrives.

Is there a way for us to save the variable %Attachment% into a local folder? The %Attachment% is a PDF file.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The %Attachment% is an object that contains the file contents as binary data. You should be able to use %Attachment.ContentBytes% in the Convert binary data to file action to save it as a file on your machine.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@Agnius

This is what I got when I tried to hardcode it

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you view the %Attachment% value during runtime? Can you share it in a screenshot?

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@Agnius

It's not really helpful as I can't really see the value in Power Automate Cloud, do note that the variableName is changed to %Attachment% now instead of %GetAttachment_V2Response%

Was this reply helpful? Yes No
nicklim 391 on at

Like (1)

Report
Copy link

Link copied!

@Agnius

Some progression, so now I save the attachment into a document library with PA cloud instead. I removed the Get attachment action in PAD since it is not working for me.

In PAD, I get the file content using SharePoint connector and then successfully convert binary data to file. Managed to merge the PDF files as well.

However, in "Get file content" when I change the hardcoded file name 31-test.pdf

to %AttachmentName%, it breaks. %AttachmentName% has the exact same value which is 31-test.pdf.

Get file content output value of the successful flow
"value": "%252fShared%2bDocuments%252fPlant%2bStreet%252fSigned%2b-%2bContract%2bof%2bSale%252f31%2b-%2bContract%2bof%2bSale%2b-%2b1%2 ...",

Get file content output value of the failed flow:
"value": "/Shared Documents/Plant Street/Signed - Contract of Sale/31-test.pdf",

I need the File Identifier to be dynamic

Was this reply helpful? Yes No
nicklim 391 on at

Like (1)

Report
Copy link

Link copied!

@Agnius

Just noticed there's another SharePoint connector called "Get file content using path". That solved my problem, thanks for taking your time

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You could also use the File system connector to create your file directly into your local file system from the cloud, so you wouldn't need to use SharePoint at all.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@Agnius

That might be another solution. Is the File system connector within PAD? I can't seem to find it. Do you mind sharing a sample of the workflow using the File system connector?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The File system connector is only in cloud flows. Since you are using a cloud flow to create a file in SharePoint anyway, using the Create file action of the File system connector is easier.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

Interesting, I’ve never heard of that connector before. I’ll check it out tomorrow morning as it’s getting late here.

thanks for the suggestion!

Was this reply helpful? Yes No