Animal shelter canvas App

[SaifMahdi]

Hi all,

1. I am trying to make a formula to my shelter status drop down button to make it show just the selected option, like adopted show mw just the adopted status on my animal information gallery?

2. How to let my form when i hit (Foster me) button direct me to the animal info form?

Please I need the formulas for both. 

Thank you

[BCBuizer]

Hi @SaifMahdi ,

1. Use a Filter function: Filter, Search, and LookUp functions - Power Platform | Microsoft Learn

2. Use a Navigate function: Back and Navigate functions - Power Platform | Microsoft Learn

[SaifMahdi]

Thank you. But, still I don't know how its work in my case. 

[BCBuizer]

Hi @SaifMahdi ,

1. In general to filter data in a gallery control by a Choice type column using a drop down control, you need to:

• Set the Items property of the drop down control to (replace TableName and ColumnName with the actual names):

Choices(TableName.ColumnName)

• Set the Items property of the gallery to:

Filter(
    TableName,
    ColumnName = DropDown.Selected.Value
)

2. Chain the Navigate function to the existing formula in the "Foster Me" button (replace AnimalInfoScreen with the actual name of the screen that has the animal info form on it):

<existing formula>;
Navigate(AnimalInfoScreen)

[SaifMahdi]

Thank you @BCBuizer still not working. 

[BCBuizer]

Hi @SaifMahdi ,

Can you please share what you have tried and what is not working? In case you receive any errors, please share them.

[SaifMahdi]

Hi @BCBuizer I really appreciate your help. 

Attached to you the dropdown error. 

and this is the gallery error.

and this is the navigate error.

and when I hit foster me this what happened, is doesn't show mw the animal information.

Thank you

[SPepe]

Hello, @SaifMahdi,

Replace Choices for Distinct and give it a try 

[SaifMahdi]

Same.

[BCBuizer]

Hi @SaifMahdi ,

For the Items property of the Drop Down control, you need to type he name of the column as it is:

'Shelter Status'