Hey Glauber, unfortunately we have a large list of requests and we do not work on Power Virtual Agent videos anymore. I would suggest to raise a ticket with Microsoft in your admin center and they will help you with this issue. Apologies we could not help further and wish you the best of luck with your issue!
Hey Faizan, thankyou for the comment. As far as im aware we cannot return an attachment in virtual agent so an option is to return a link to a document
@@WeTechCareOfYou do we have any solution now since there is so many changes in copilot. I have list of document (pdf /word) in SharePoint and i want to display them on PVA so that external user can download it.
Hi man, great stuff, congrats! What if I want to return the list as multiples options to the Power Virtual Agents so the users can select the services?
Hey Fabio thanks for the question! Unfortunately at the moment you can only return a string and not an array of values. I have not yet seen a workaround or an update for this.
how to get the list with same type of triggers??the power automate gets all answers of same intent..how to get specific question with same words in 2 rows??
Hey Hanif, thankyou for the comment. Apologies but I do not understand what you are trying to achieve. You want to read the list twice in the same flow or pull 2 values from the same list record?
@@WeTechCareOfYou thanks for your reply dude..I solved that prob using *1.*markdown option. now..could you tell how to show the contents in the SP list at PVA chat using a dropdown window which the user can select.??
@@hanifadhithan Hey Hanif, thanks for the response. I'm sorry but unfortunately we could only return a string in PVA to the user which is why we have 1 concat string. Maybe it will allow us to pull an array in the future which mean we could have some sort of option or selection
Hey Abdel, thankyou for the comment. You can filter your SharePoint list data using OData filter query in the Power Automate: powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Get-items-OData-Filter-Query-Simplified/td-p/777566 Relating to displaying the data in a table, unfortunately we can only return a string to the virtual agent so we cannot display in a table
No problem, if you have issues please email admin@wetechcareofyou.com and we will give you a free session with one of our developers to try and fix it.
Hey ThatBrownGirl, in my video at 6:41, instead of using "Get Items" use the excel step "List rows present in a table". This will pull all of the rows from your excel file.
Thanks I shall try that. Also.... How to get a list of today's events from Excel SharePoint when user enters today's date as an input. Note the ID here is date format which is March 01 or April 21. User enters date in this formate and the same date is used to look into Excel and get it's corresponding two columns Any help would be appreciated.
Ok so at approx 5:30 in my video if you can get the users input to be passed into the power automate flow of whichever date they enter as a string (it will need to be the same date format as whatever is in the excel spreadsheet). Then after your Excel step "List rows present in a table", add an "Apply to each step" and add the "List rows present in a table"-"values" variable into the apply to each so it loops through each row in the spreadsheet. Now within the apply to each add a condition and have: [User passed in variable from power virtual agent] is equal to [Excel value date field] In the "Yes" branch of this condition, add "Append to string variable" and then you can select the "Services" variable in my video example then add whichever Excel field you want as the event. This will then return the services variable with all events matching that date.
