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

Blank value in Power BI becomes 0 instead of blank in SharePoint List

How can u identify a blank column in a Power BI Decimal Field (Order Value) using Power App formulae ? 

I have tried First([@PowerBIIntegration].Data).ordervalue=Blank() , isblank (First([@PowerBIIntegration].Data).ordervalue) , isnumeric, ="", =" ", and others with no success . When a blank value gets selected it from power BI into the PowerApp it becomes 0 in the SharePoint List where it is written and not blank.

Code for setting Default value in FORM for Order Value Box

If( ( DataCardValue1_3.Selected.Value = "No" && First([@PowerBIIntegration].Data).ordervalue=Blank()) ||(DataCardValue1_3.Selected.Value = "No" && IsBlank(First([@PowerBIIntegration].Data).ordervalue) ) ||(DataCardValue1_3.Selected.Value = "No" && IsNumeric(First([@PowerBIIntegration].Data).ordervalue)=false ), Blank() ,If ( DataCardValue1_3.Selected.Value = "No" && IsNumeric( First([@PowerBIIntegration].Data).ordervalue), First([@PowerBIIntegration].Data).ordervalue,
DataCardValue11_2 +
DataCardValue12_2 +
DataCardValue13_2 +
DataCardValue14_2 +
DataCardValue15_2) )

2 REPLIES 2
Jagadeeshk
Responsive Resident
Responsive Resident

Just try "" instead of blank(). Or value(data)=0

These 2 suggestions do not work.  This is totally puzzling. Is there a Power BI data type to Power App data type to SharePoint Data type which causes a blank value in a Power BI field to become 0.00 when it land in the Sharepoint List. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,726)