cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fernandosilva
Helper V
Helper V

Upload a file

Hi there,

 

Does anyone knows how an user can upload a file through PVA and after the the file is uploaded it triggers a Power Automate flow to send the file to the SQL database?

 

Cheers,


Fernando

6 REPLIES 6
renatoromao
Super User
Super User

Hi @fernandosilva ,

 

You use these steps below:

While Microsoft provide better in-app support for this, you can do the following,

 

  1. Deploy a custom web-canvas (see documentation) that supports attaching images / files
  2. Upload the image / file to your own Azure Blob storage
  3. Send the URL as a message activity (response to a question node) so that it gets assigned to a variable
  4. Use that URL in Flow / Skills to achieve your desired outcome

Microsoft has provided a github sample that attempts to mimic this capability.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Quite a work to be done on it to make it to work, but thank you for your reply @renatoromao 

renatoromao
Super User
Super User

you're welcome! 🙂

I will try to record a video doing this action on my YouTube channel soon.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

That will be awesome. Please send your youtube channel link, so I can find the video when is uploaded. Thanks.

renatoromao
Super User
Super User

Sure 🙂

https://youtube.com/Renatoromao


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao ,

 

Thanks for the link. Please let the community knows when the video is online as this is a crucial feature of the tool.

 

Cheers,

Fernando

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Users online (5,103)