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

PVA Preview version - data type issue

I have an existing flow that does work with my current bot but does not work in Preview. This flow checks the user-inputted ID against Azure AD and returns their contact ID and name to PVA. If they are NOT found, the contact ID returns as blank, and the name returns as null.

 

In my current bot, if the contact ID "has no value" then it kicks them back to ask for their ID again. In the preview bot, "has no value" is not an operator option anymore. I have tried using "is blank" and "is not blank" as contact ID options to send the user down one path or the other. For the name value, I have also tried "is null." No matter what I do, the PVA bot errors and says that the variable "
evaluated to type ‘BlankType’ , expected type ‘StringDataType’".
The output from PA shows the data is sent as a string, but PVA Preview is interpreting that as "BlankType." All works fine as long as the user ID is found in AAD. I am not sure what else to try or if this is a bug. Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
webmonkee
Frequent Visitor

The solution was indeed to eliminate the null returns. I now have my flow return a blank by literally setting the value to one space-bar tap. PVA then recognizes it as an empty string instead of a null, and operates as expected.

 

View solution in original post

9 REPLIES 9
HenryJammes
Microsoft
Microsoft

Hi @webmonkee,

Can you try to use "Change to formula" on your condition node, and use something like this?

 

HenryJammes_0-1672917803062.png

 

Hi Henry,

I tried the formula approach with the same result. We can certainly do a workaround where we add a condition in the PA flow to return a non-empty value when the user is not found, then work the PVA condition off that result, but it feels buggy to me still, since an empty string is still a string. I don't think the "is/is not Blank" function is usable for strings as it stands?

But certainly not a show-stopper issue. 

HenryJammes
Microsoft
Microsoft

I'm not sure I fully understand what's not working here.

Can you share a few screenshots of the Power Automate cloud flow run outputs (with empty values) and of your PVA condition node?

webmonkee
Frequent Visitor

Yessir -thanks!

PA Output:

webmonkee_0-1672936542273.png

PA Raw Output:

webmonkee_1-1672936569322.png

PVA Node: (Note, I did try it as a formula too with same result, and also tried evaluating the name variables  instead)

webmonkee_2-1672936580741.png

PVA Error:

webmonkee_3-1672936593866.png

 

 

I still can't repro.
I create bot that asks for the user email:

HenryJammes_1-1672943687959.png

 

I then query for users with such emails using Power Automate, and return a couple of attributes for the first matching record:

HenryJammes_2-1672943753249.png

 

In a flow run that returns 0 results, I get this:

HenryJammes_3-1672943786345.png

 

In PVA, using "is Blank" in my condition works as expected for both cases where I get a match or not:

HenryJammes_4-1672943958714.png

 

 

 

 

 

webmonkee
Frequent Visitor

Hunh, you're returning all blanks, and two of mine are returning nulls. I need to figure out why I'm returning nulls. Very helpful - thank you for testing!

That's odd - not sure how you managed to return nulls, even when I try to force a null with an expression like this:

HenryJammes_0-1673003763380.png

The output sent to PVA is actually blank:

HenryJammes_1-1673003792134.png

 

webmonkee
Frequent Visitor

I guess I have mad skillz - just not useful ones. 🙂 Haven't had a chance to work on it yet, but will see what I can do to eliminate the null returns.

webmonkee
Frequent Visitor

The solution was indeed to eliminate the null returns. I now have my flow return a blank by literally setting the value to one space-bar tap. PVA then recognizes it as an empty string instead of a null, and operates as expected.

 

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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,557)