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

Site Inspection template - trouble with formulas

So I have replaced all the text box fields in the template with my own drop down boxes (with multiple choices) and I've removed the GPS because I don't need it. But I'm still having lots of trouble because I'm getting multiple errors and I'm not sure what to do (still new to PowerApps!)

 

My formula is attached.

 

So pretty much, I want to use Site Inspector in the exact same way as the template, but using drop down boxes instead of text inputs and without using GPS - what am I doing wrong? Is there anything obvious that stands out to you in my formula and would anyone please be able to advise a better one to use?

 

Thanks!

1 REPLY 1
rimatos
Community Support
Community Support

Hi @Meow_Glitter

 

Taking a look at the formula I was able to find two things:

 

-You state that you replaced all of your text box fields for dropdown boxes. However, when looking into the formula I was able to find a logic test for a text field. Was this intended?

 

image.png

 

 

Finally, I see that you are verifying the "emptiness" of the dropdown fields by using the IsBlank function. However, from my understanding I believe that this operation is not supported by Dropdown lists. With this in mind try using instead IsEmpty function.

 

You have another commuity post here with an example for this.

 

 

Hope this helps!

 

Regards,

Ricardo

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,787)