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

Site Inspection drop down help

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Site Inspection drop down help

Hi @Meow_Glitter ,

Do you want to save the new Site Inspection entry back to your Excel table?

 

Within this Site Inspection template app, when you press the "Done", the new entered Site Inspection entry would be saved into the SiteInspectorcollect collection in default.

 

If you want to save the new Site Inspection entry back to your Excel table, you need to replace the SiteInspectorcollect collection with your own Excel table as data source within this template app.

You must make sure your Excel table contains the following columns:

3.JPG

Within the OnSelect property of the "Done" button, please replace all SiteInspectorcollect collection with your own Excel table.

 

If you replaced Text Input box with Dropdown box within this template app, when referencing entered value from these Dropdown boxes, please use the following formula:

Dropdown1.Selected.Value
Dropdown2.Selected.Value
Dropdown3.Selected.Value

...

...

 

So on your side, the OnSelect Property formula of the "Done" button should be like below:

If(
    !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && !IsBlank(AddressDropdown.Selected.Value) && !IsBlank(StateDropdown.Selected.Value) && !IsBlank(CityDopdown.Selected.Value) && !IsBlank(ZipText.Text) || !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && Radio1.SelectedText.Value = "Use GPS for current Location",
    Collect(
        SiteInspectorcollect,
        {
            ID: Value(Max(SiteInspectorcollect,ID) + 1),
            Title: TitleDropdown.Selected.Value,
            SubTitle: SubTitleDropdown.Selected.Value,
            Description: DescriptionText.Text,
            Address: AddressDropdown.Selected.Value,
            City: CityDopdown.Selected.Value,
            State: StateDropdown.Selected.Value,
            Zip: Value(ZipText.Text),
            Notes: NotesText.Text,
            Latitude: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                Value(Location.Latitude),
                ""
            ),
            Longitude: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                Value(Location.Longitude),
                ""
            ),
            IsGPSCoordinates: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                true,
                false
            )
        }
    );
    If(

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Site Inspection drop down help

Hi @Meow_Glitter ,

Do you want to save the new Site Inspection entry back to your Excel table?

 

Within this Site Inspection template app, when you press the "Done", the new entered Site Inspection entry would be saved into the SiteInspectorcollect collection in default.

 

If you want to save the new Site Inspection entry back to your Excel table, you need to replace the SiteInspectorcollect collection with your own Excel table as data source within this template app.

You must make sure your Excel table contains the following columns:

3.JPG

Within the OnSelect property of the "Done" button, please replace all SiteInspectorcollect collection with your own Excel table.

 

If you replaced Text Input box with Dropdown box within this template app, when referencing entered value from these Dropdown boxes, please use the following formula:

Dropdown1.Selected.Value
Dropdown2.Selected.Value
Dropdown3.Selected.Value

...

...

 

So on your side, the OnSelect Property formula of the "Done" button should be like below:

If(
    !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && !IsBlank(AddressDropdown.Selected.Value) && !IsBlank(StateDropdown.Selected.Value) && !IsBlank(CityDopdown.Selected.Value) && !IsBlank(ZipText.Text) || !IsBlank(TitleDropdown.Selected.Value) && !IsBlank(SubTitleDropdown.Selected.Value) && Radio1.SelectedText.Value = "Use GPS for current Location",
    Collect(
        SiteInspectorcollect,
        {
            ID: Value(Max(SiteInspectorcollect,ID) + 1),
            Title: TitleDropdown.Selected.Value,
            SubTitle: SubTitleDropdown.Selected.Value,
            Description: DescriptionText.Text,
            Address: AddressDropdown.Selected.Value,
            City: CityDopdown.Selected.Value,
            State: StateDropdown.Selected.Value,
            Zip: Value(ZipText.Text),
            Notes: NotesText.Text,
            Latitude: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                Value(Location.Latitude),
                ""
            ),
            Longitude: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                Value(Location.Longitude),
                ""
            ),
            IsGPSCoordinates: If(
                Radio1.SelectedText.Value = "Use GPS for current Location",
                true,
                false
            )
        }
    );
    If(

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,724)