Answered

How to find if an image is blank

(0) Share

Report

Posted on by hadimarashy

Hi all,

I am hoping you can help me out.

I have a form connected to the SQL database, and I want to check if an image is null by using If(IsBlank(Image38.Image),false,true).

However, after checking Image38.Image value is showing appres://datasources/inspection_plant_daily/table/%5Bdbo%5D.%5Binspection_plant_daily%5D/rows/97/inline/accumulated_debris_image even though its null in the database.

I also tried If(IsBlank(daily_inspection_gallary.Selected.all_oil_levels_image),false,true) and I get same result.

What is the best way to find if the image is null?

Thanks in advance for any suggestions.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @hadimarashy ,

I reproduced your problem.

This happens because "appres://" is just a reference. Regardless of whether the image/varbinary column in the database has a value, the reference will exist. So you can't use blank()/Isblank() to check if the image is blank.

You could use JSON function to solve it.

I did a test for you .

You could add a button to create a collection or variable.

ClearCollect(Col,ForAll(Gallery1.AllItems,JSON(ThisRecord.Image2.Image,JSONFormat.IncludeBinaryData)))

If the record has an image , 'appres://...' will be changed to base64.

Then you could use this rule to check which column has image value.

Best Regards,

Wearsky

Was this reply helpful? Yes No
hadimarashy 34 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-xiaochen-msft

Was this reply helpful? Yes No