cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SurajGuptha
New Member

isnull in PVA Power Automate

I want to set a bool when NULL is returned for a parse JSON property. There is no expression option available like its available in regular power automate.

 

I call a Power automate action from my power virtual agent bot. In the power automate action I query cosmosdb which returns an document. I then use parse json to parse the value returned by the action. If a property is null, set bool to false, if property is not null, set bool to true. Maybe there is a simpler way.

 

Appreciate your help.  

1 ACCEPTED SOLUTION

Accepted Solutions
SurajGuptha
New Member

I wasn't able to see expressions inside of power automate in power virtual agents because of which I wasn't able to use the null expression. When I "X" the test bot screen, expressions and dynamic content started appearing. 

View solution in original post

2 REPLIES 2
renatoromao
Super User
Super User

Hi @SurajGuptha ,

 

You need to do this logic within the Power Automate flow and return only the TRUE or FALSE values as an output to your PVA Bot.

Today, it is not possible to define variables in the bots.

 

Does make any sense?


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português
SurajGuptha
New Member

I wasn't able to see expressions inside of power automate in power virtual agents because of which I wasn't able to use the null expression. When I "X" the test bot screen, expressions and dynamic content started appearing. 

View solution in original post

Helpful resources

Announcements
PVA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Top Kudoed Authors
Users online (1,867)