How to find if an image is blank

[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.

[v-xiaochen-msft · Accepted solution]

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

[hadimarashy]

Thank you @v-xiaochen-msft