You’re offline. This is a read only version of the page.
145
I try to create bot that get Item form sharepoint list but can't Return value to Power virtual agents
Then I try another solution by try to keep output in the Variable initialization it fix the error but the bot still return null value
Output
Thank you for any advice
You can use the Person or Group column for the filter. But since those are complex objects you don't use the column name to match. There should be some dynamic content for Name Display Name or something like that. That is the property in the people group column that is the name of the person.
@Pstork1 Thanks for your reply
I alredy fix it with you help on the first solution and the problem on get items return null value it look like on Filter Query can't match Person or Group type so my solution is Copy the name and enter in the Title (Single line of text)
and in the Filter Query Instead of use Name columns I use Title eq (Value that my bot get) and it work
Is Name a People column in SharePoint or a single line of text? If its a single line of text you won't be able to use that as part of the query since its a complex object not text. You'll have to do the get items and then use a filter array to filter the result. Without knowing what your data looks like its hard to tell what is not working. But I suspect its the query you are using in Get items.
@Pstork1 Thanks for your comprehensive reply your solution fix the loop action, but unfortunate it look like my flow didn't get value from Get items part
History run
My sharepoint list Name colume type is person and VacationLeave type is Number the name that get from the bot is correct but it still return null value
output detail
Inside your loop you should be using the Append to String Variable action, not the set variable action. The set action will overwrite the results from each previous loop so you will only get the last value in the column. What you probably want looks more like this. In this flow I built a table using markup to display three columns. Then returned the string variable to the Bot for display.
#1
Romain The Low-Code...
74
#2
Pablo Roldan
61
#3
stampcoin
10
Share
Report
All responses (
Answers (
