cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aurlho
Helper I
Helper I

PVA - Get documents from Sharepoint

Hi all,

 

I would like to download or open a Sharepoint document from PVA. 

Today, it is always the same link and same document which is displayed ... Where should I configure the name of the document to search in the SP library please?

Could you please help me with step by step procedure  ?  I'm struggling.... here is my flow :

aurlho_0-1605690084354.png

Thank you in advance 

1 ACCEPTED SOLUTION

Accepted Solutions
renatoromao
Most Valuable Professional
Most Valuable Professional

Hi @aurlho ,

 

You can change the properties after upload in your environment, but I created a sample workflow to help you. (you can see attached below)

https://docs.microsoft.com/en-us/power-automate/import-flow-solution


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

Renato Romão,

Connect with me here 😉

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

View solution in original post

10 REPLIES 10
renatoromao
Most Valuable Professional
Most Valuable Professional

Hi @aurlho ,

 

Please, take a picture of your Apply to each action.

Basically, you created a variable at the beginning of your workflow. Inside the Apply to each, you need to use the "append to a string variable" action and insert in the Value field the dynamic content called "Link to the item".

 

Now, on your last action of your workflow, just send to PVA the variable.


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+3.250 students) : English | Português
renatoromao
Most Valuable Professional
Most Valuable Professional

@aurlho ,

 

Adding...

Regarding your question about the filter, you can filter the SharePoint documents by metadata/properties in this document library. You can filter on a Filter array or filter using the OData field on SharePoint action.


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+3.250 students) : English | Português
aurlho
Helper I
Helper I

Hello Renato, 

Thanks for your feedback!

 

Below is the flux in detail :

aurlho_0-1605696340414.png

I have the step "Apply to a string" but the link displayed in my PVA Bot is still the same (and same document).

How can i tell it to look for a specific file name in the Sharepoint base ?

In Odata filter ? But i don't know what to fill in...

 

Thank you very much in advance

 

renatoromao
Most Valuable Professional
Most Valuable Professional

@aurlho 
Oh no 😞 

You are using the wrong property on the Apply to each action.

Inside the first field on Apply to each that is written "value" you need to remove that, and click again on this field, and select the list items, body, values, or something like that on the Dynamic content.


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+3.250 students) : English | Português
aurlho
Helper I
Helper I

@renatoromao 

Oh... I'm noob sorry ! 🙄

I know that i'm not far but some configurations must be missing. Here is my flow ...

aurlho_0-1605697327892.png

aurlho_1-1605697451582.pngaurlho_2-1605697468612.png

 

 

renatoromao
Most Valuable Professional
Most Valuable Professional

Hi @aurlho ,

 

You can change the properties after upload in your environment, but I created a sample workflow to help you. (you can see attached below)

https://docs.microsoft.com/en-us/power-automate/import-flow-solution


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+3.250 students) : English | Português
aurlho
Helper I
Helper I

Thank you very much @renatoromao  ... I will try.
I used your template but now the bot is not responding at all ...

 

aurlho_0-1605699796411.png

aurlho_1-1605699857151.pngaurlho_2-1605699907446.png

 

 

renatoromao
Most Valuable Professional
Most Valuable Professional

@aurlho ,

 

You need to change the apply to each property, you need to use the Items or Value output from Filter Array action, your are using ~corps~ 


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

Renato Romão,

Connect with me here 😉

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

Thank you very much @renatoromao  for your help and patience! After having searched for a long time, in fact it was not "Title" but "Name" that I had to use in the filter array...
Good day to you !

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   😊Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

The Copilot Studio community is thrilled to share some exciting news!

We are embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools that our community advocates for.  We're proud to announce that the Copilot Studio community will pioneer this migration starting in June 2024. The move will mark the beginning of a new chapter, and we're eager for you to be a part of it. Following our lead, the rest of the Power Platform product sites will join us over the summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind, to connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport. To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages  

Users online (2,946)