cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JhonaOB91993
Frequent Visitor

Error ChatBot

Good morning, dear.
Please could you help me with the following query.

I am developing a chatbot and I would like it to make a query on a database in a sharepoint list. The objective is to know the status of the request.

At the time of developing the chat, in the response to PVA I get an error per loop and that must be developed separately.

Cheers,

JhonaOB91993_0-1604769572602.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
renatoromao
Super User
Super User

Hi @JhonaOB91993 ,

You are using the Get Items action to filter by ID and this action returns a list of items, you cannot use of this way, you will need to create a variable, define this variable and return the variable to the PVA action.

 

I recomendo you to use the GET ITEM action, because this action return only one item and you can use the Status of the request or another column to return to the PVA 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.760 students) : English | Português

View solution in original post

1 REPLY 1
renatoromao
Super User
Super User

Hi @JhonaOB91993 ,

You are using the Get Items action to filter by ID and this action returns a list of items, you cannot use of this way, you will need to create a variable, define this variable and return the variable to the PVA action.

 

I recomendo you to use the GET ITEM action, because this action return only one item and you can use the Status of the request or another column to return to the PVA 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.760 students) : English | Português

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,631)