web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue in Dataverse Dat...
Power Automate
Unanswered

Issue in Dataverse Datatype Yes/No

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I have the Column which is Yes/No datatype and default it is No set. Yes-0 No - 1 value set

 

I have condition if my input csv column BO is empty then this datatype in dataverse column boaddedtoAD group should be No

Else it will go no statement and check the name if the person is not added in group member then set flag variable is true otherwise false

if(varflag(BO),true,false)- this is my code i put it while updating row in dataverse

 

Below screenshot it goes to YES branch as there is no name in csv colum is empty but updating in dataverse i could see the default is yes and the column is false. but default is no only how to fix this?

 

Priyanka03_0-1700046102001.png

 

Priyanka03_1-1700046207421.png

 

 

Categories:
  • Anchov Profile Picture
    1,986 on at

    Can you do a screen shot of your condition in the Power Automate editor:
    I just tested a Yes\No condition from data verse and this one is working as expected:

    Anchov_1-1700057216398.png


    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Cheers!
    Rick Hurt

  • Priyanka03 Profile Picture
    2 on at

    Hi,

     

    If my column is empty then the datatype should take it is as No because i set No as a default instead NO it is taking YES.

    This is No Side Branch

    Checking group members are added in group if yes nothing i'm doing and if no i set the flag variable is true

    After updating row

    if(varflagbo,true,false) it is working fine as expected but when the bo column is empty no value it should take default set value but it is not taking that it is changing into yes

    Please see the screenshot

    Priyanka03_0-1700060543020.png

    Priyanka03_1-1700060583272.png

     

     

  • Anchov Profile Picture
    1,986 on at

    Okay here is one way to capture the value of my boolean category null or false using a condition and an expression. 

    Anchov_0-1700063355252.png

    Expression used:

    if(equals(triggerOutputs()?['body/cr6c0_instock'], null), 'Instock is null', 'Instock is false')

    You could also write an expression that accounts for all 3 scenarios in a single step:

    if(equals(triggerOutputs()?['body/cr6c0_instock'], null), 'Instock is null', If(equals(triggerOutputs()?['body/cr6c0_instock'], true), 'Instock is true','Instock is false'))

     

  • Priyanka03 Profile Picture
    2 on at

    My condition is if(BO) eq to Null

    yes branch set flag1 variable is true 

    Priyanka03_0-1700064153987.png

    In no statement

    Priyanka03_1-1700064197532.pngPriyanka03_2-1700064225912.pngPriyanka03_3-1700064284628.png

    I'm adding a row in dataverse so i need to check the csv data BO column has a name or empty . if its empty default the datatype should be No to set . 

    Could you please help me where i need to change it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard