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.
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
167 | |
94 | |
67 | |
64 | |
63 |
User | Count |
---|---|
223 | |
160 | |
94 | |
85 | |
80 |