Conditional Background color in Pivot on expression to check if file exists

MrBosch — Sun, 30 Oct 2022 03:52:49 GMT

I am trying to create a pivot table that will show if a persons file is complete. It is complete if five images are available online.

It is working. The person and five online images are shown in my pivot table: you can see rows with and without these images (so some are complete others are still not):

What should I do to replace these images by a solid green background if they are found?

The expressions are built like:

='https://www.demo.org/uploads/'&code&'_image1.png'

So attempts to enter a condition in the expressions background, like:

=IF Len(FileSize('https://www.demo.org/uploads/'&code&'_image1.png')>0,Green()

doesn't go well...

topic Conditional Background color in Pivot on expression to check if file exists in App Development

Conditional Background color in Pivot on expression to check if file exists