cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
SaifMahdi
Frequent Visitor

Animal shelter canvas App

‎06-30-2024 12:57 PM

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

Labels:
Message 1 of 19
1,661 Views
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Multi Super User
Multi Super User

‎07-03-2024 08:35 AM

Hi @SaifMahdi ,

 

Please confirm you have tried the below and share any errors you receive or at least describe what is not working as expected. Saying "it's the same" doesn't get you any closer to finding the issue. 

 

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('Animal Information'.'Shelter Status')
  • Set the Items property of the gallery to:
Filter(
    'Animal Information',
    'Shelter Status' = DropDown.Selected.Value
)

 

2. If you want the form to show the selected item from the gallery, you need to:

  • Instead of using the NewForm function in the OnSelect property of the 'Foster Me Button', use the EditForm function:
EditForm('Claim Form');
Navigate('Foster Me');
  • Also you need to set Item property of the form to reference the selected item in the gallery, in your case:
'Animal information'.Selected

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

Message 12 of 19
1,056 Views
0 Kudos
18 REPLIES 18
BCBuizer
Multi Super User
Multi Super User

‎06-30-2024 02:33 PM

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



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Message 2 of 19
996 Views
SaifMahdi
Frequent Visitor

‎06-30-2024 05:41 PM

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

Message 3 of 19
978 Views
0 Kudos
BCBuizer
Multi Super User
Multi Super User

‎06-30-2024 11:52 PM

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)

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Message 4 of 19
964 Views
0 Kudos
SaifMahdi
Frequent Visitor

‎07-01-2024 02:40 PM

Thank you @BCBuizer still not working. 

Message 5 of 19
792 Views
0 Kudos
BCBuizer
Multi Super User
Multi Super User

‎07-02-2024 07:27 AM

Hi @SaifMahdi ,

 

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



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Message 6 of 19
718 Views
0 Kudos
SaifMahdi
Frequent Visitor

‎07-02-2024 09:30 AM

Hi @BCBuizer I really appreciate your help. 

Attached to you the dropdown error. 

SaifMahdi_0-1719937643717.png

and this is the gallery error.

SaifMahdi_1-1719937707005.png

and this is the navigate error.

SaifMahdi_2-1719937748561.png

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

SaifMahdi_3-1719937814192.png

Thank you

 

Message 7 of 19
715 Views
0 Kudos
SPepe
Advocate II
Advocate II
In response to SaifMahdi

‎07-02-2024 08:01 PM

Hello, @SaifMahdi,

 

Replace Choices for Distinct and give it a try 

Message 8 of 19
686 Views
0 Kudos
SaifMahdi
Frequent Visitor

‎07-02-2024 10:10 PM

Same.

SaifMahdi_0-1719983442960.png

 

Message 9 of 19
680 Views
0 Kudos
BCBuizer
Multi Super User
Multi Super User

‎07-03-2024 04:33 AM

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'


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Message 10 of 19
479 Views
0 Kudos

Helpful resources

Announcements
Important Update | Power Up Community READ ONLY July 22 – July 28

Important Update | Power Up Community READ ONLY July 22 – July 28

Dear Community Members, As you may have read, the Power Platform communities are transitioning to a new platform and to access will be set to READ-ONLY mode during the transition. Key DatesTo ensure current learners have adequate support in the final week of the cohort, the Power Up Program Community will transition to READ-ONLY mode starting July 22nd, the platform will transition to READ-ONLY mode until July 28th. Power Apps, Power Automate, and Power Pages communities will be read-only July 16-22, 2024.During this period, members will not be able to start new threads or Kudo, Comment, or Reply to any posts, but will be able to search and review past threads or solutions. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. Learners will be able to sign in to the new Power Up Program community experience, starting July 29th. If you registered for community using your learnwithpowerup account, you will not receive an email, but should be able to sign in successfully if you are signed in to My hub.  If you need help with your community account, please submit a request at aka.ms/PPCommSupport We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead! 

Learn what to expect in the Power Up Program

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.