PVA/FLOW for checking a number in a list - need help

[Nikolabg91]

Hey guys im hopping to get some help here. I have recently started creating a bot for my team and creating a flow for it is proving to be an impossible task. 

First i want the PVA to trigger on @(number) and then i need a flow that will grab that output compare it to a sharepoint list and return result yes if that number is present and no if not.
I have attempted using multiple conditions after get items(sharepoint) but im getting errors 200 and 400 when im trying to save.

Any help here would be greatly appreciated

[Nikolabg91]

I have managed to do something but have problems phrasing variable

What do i need to do now to get a second outcome? I need the flow to verify if the number is present. If so get a yes, if no get a no

[Shujaath_Khan]

Hi @Nikolabg91 

you can try to save the loop conditional outcome in variable and in last try to return using Return values to Power Virtual agents connector

You can also return multiple values from flow by clicking on Add an output in the last step

Thanks

If this post helps, please consider Accepting it as the solution. Thumbs up if it helped you other way.

[Nikolabg91]

So i cannot find SPOC in the condition and this is the error i am getting : 

Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Return_value(s)_to_Power_Virtual_Agents' of type 'Response' are not valid. The variable 'ResponseVar' must be initialized before it can be used inside action 'Return_value(s)_to_Power_Virtual_Agents'.'."}}". Code: 0x80060467 InnerError: '.



[Shujaath_Khan]

Hi @Nikolabg91 

1) regarding SharePoint column spoc please replace with your SharePoint column name ref.

2) not sure what is your return type in last action from flow. Can you assure you're sending only text variable as example and try to save.

Thanks

[Nikolabg91]

Ok so below you will find my whole flow

[Nikolabg91]

Now im getting an erro 2003 on bot side. For some reason i cannot get it to read results. I wanted it to be simple. If the number is present in the SP list (title) say yes, if no say no

[Nikolabg91]

Note in the condition field i have set Title to eq VarsiteID

@Shujaath_Khan 

[Shujaath_Khan · Accepted solution]

Hi @Nikolabg91 

I've quite recreated your flow and removed even Apply each as well to make it simple and straight

Flow

and in expression use simple items count if any items found in SharePoint

Testoutcome.Value = if(equals(length(outputs('Get_items')?['body/value']),0),'No','Yes')

and from PVA side

Here's a demo you can watch : https://youtu.be/3IgNNqkV6XQ

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[Nikolabg91]

Dude you are the MAN !!!! i am totally accepting and liking although i do have one question ( and i guess there aint no simple answer). Can greeting phase be skipped? Like i would like to @botname (input) and just get a response

[Shujaath_Khan]

hi @Nikolabg91 

greetings are all by choice and you've volition to skip at your choice.

Just delete the action which is not needed.

and glad that it helped 

Thanks