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.
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.
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 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.
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 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.
Great video!
Thankyou for the comment Brian! Happy it helped :)
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.
Great job. Could you please guide me how I can show files from SharePoint as attachment to download in Bot for user?
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.
@@alokinsights hey thanks for the comment. I had a look for this to se latest updates however it still does not look possible to return an attachment.
Could you Record a vídeo returning a especific item from sharepoint list?
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!
How can we filter the data from the Sharepoint list? and is it possible to display them as a table?
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
Thankyou
Thankyou for the comment Dharmesh, I hope it helped :)
@@WeTechCareOfYou Yes, It really helped me a lot. Thanks again :)
Can I update SharePoint list using bot ??
Hey Nitin, you can update a SharePoint list in the flow (triggered from the bot) using "Update Item"
@@WeTechCareOfYou thank you for your reply.. will do that and let you know.
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.
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
My data is in an excel file in sharepoint how do i retrieve 2-3 columns of data with one key ID say date.?
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.
@@WeTechCareOfYou i will try this today and let you know how it goes. Your so awesome thanks.
thankyou, let me know if you have any issues
I am getting one job type value o
instead of getting all values
Hey Saideekshith, thanks for the comment. Please send an email to admin@wetechcareofyou.com and I will schedule a call to look at your issue.