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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,891)