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
Super User
Super User

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 (+2.300 students | PROMOTIONS) : English | Português

View solution in original post

9 REPLIES 9
renatoromao
Super User
Super User

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 (+2.300 students | PROMOTIONS) : English | Português

@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 (+2.300 students | PROMOTIONS) : 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
Super User
Super User

@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 (+2.300 students | PROMOTIONS) : 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
Super User
Super User

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 (+2.300 students | PROMOTIONS) : English | Português

View solution in original post

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
Super User
Super User

@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 (+2.300 students | PROMOTIONS) : 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
March Update

Welcome to the User Group Private Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (60,798)