
Hi,
My PAD is hitting an internal site to download files based on the ID being passed on by my cloud flow. PAD should return the file to the cloud flow after a successful download and store them in a sharepoint list.
I am researching on how i can do it more efficiently like maybe i can pass multiple ids to PAD and let it process a batch and return them all. I was trying the objects for data tables by having an input and output with data table types. The only problem i see is this error when updating the output variable.
Seems like it cannot return a binary value. My data table looks like this
Is this really possible? Any thoughts on how to resolve or maybe what other workarounds do i have?
You can push your files to SharePoint via the SharePoint actions in PAD. No need to return binary data to the cloud flow to crate a file. This will be much easier and you will not need any output variables. There are the Create file and Create item actions in the SharePoint group of actions for both creating a file in a SharePoint library, as well as creating an item in a list. So, these should cover your needs.
-------------------------------------------------------------------------
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.