Bot can't get items from sharepoint list with matching name

(0) Share

Report

Posted on by Alicekings

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Alicekings 145 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Alicekings 145 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No