cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Unable to Filter "Ready to Foster" and Dropdown.Selected

Hello, 
Please, I am currently unable to apply two filters to my Gal Animal table, I have tried several Power FX expressions but I still encounter errors such as "Unsupported comparison types". I tried to also filter my animal table view to Ready for Foster View but it is still not working. 

I will appreciate a solution to fixing this issue please. 
Attached is what my formula currently looks like, I can only filter to the shelter location successfully at the moment, but can't filter the Shelter Status to "Ready for Foster".Screenshot (83).png

 

8 REPLIES 8
kashjoyin
Frequent Visitor

This is what i used to filter successfully

Filter(
    'Animals Data','Animals Data (Views)'.'Ready for Foster','Shelter Name' = drpShelterStatus.Selected.'Shelter Name'
)
kashjoyin_0-1716141280053.png

 

Thanks @kashjoyin 
I tried using this formula as well, but it keeps giving me an error message 😥

 

Oyin
Advocate V
Advocate V

@Dianah_Ebere , @kashjoyin 

After a few hours of research, I finally found the formula that worked for me. So I used a combo box and the formula works in a way that when nothing is selected it returns my full Ready to Foster view. It should work for dropdown as well. Combo box data is my Shelters table.

 

You should try this Dianah.

 

For your gallery

 

Items = If(
    IsBlank(cmbShelterName.Selected),
    Filter(
        'Animal Details',
        'Animal Details (Views)'.'Ready for Foster'
    ),
    Filter(
        'Animal Details',
        'Animal Details (Views)'.'Ready for Foster',
        'Shelter Name' = cmbShelterName.Selected.'Shelter Name'
    )
)

 

 Then for the combo box

 

Items = 'Shelter Info'.'Shelter Name'

 

Nothing selected

ifisblank.png

 

 

 

 

 

 

 

 

 

Selected

selected.png

Thanks @Oyin  It helped me as well.  but when I use the view from dataverse table, I am not able to see the image of the pets. Any suggestion on how to display images here ? 
PS: i have uploaded the photos of the pets.

Hi @Poovarasan27 , 

 

Go to insert, search for image and drag into your gallery. Highlight it, then use the formula:

Image = ThisItem.'Photo URL'

 Depending on your column name, Photo URL or Photo.

jsl6v8
New Member

sorry to hijack this but looks like you are working on the same thing I am.  I have been trying to get my form to update shelter status once someone picks an animal to foster but haven't been able to get it to work, do you have any suggestions?

Hi @jsl6v8 ,

 

What I did was add the choice option 'Claimed for Foster' in the Shelter Status column of the animals table and use the patch formula below.

OnSuccess = Patch(
    'Animal Details',
    {
        'Animal Detail': Form1.LastSubmit.'Animal Detail',
        'Shelter Status': 'Shelter Status (Animal Details)'.'Claimed for Foster'
    }
);
Refresh('Animal Details');
Navigate('Home Screen');
Notify(
    "You have succesfully claimed an animal to foster",
    NotificationType.Success
)

 

BCBuizer
Multi Super User
Multi Super User

Hi @Dianah_Ebere ,

 

Try setting the Items property of the Drop Down control used to select the shelter status to:

Choices(AnimalFamilies.'Shelter Status')

 

Then in the Items property of the gallery, include a filter condition like this:

Filter(
    AnimalFamilies,
    'Shelter Status' = DropDown.Selected.Value
)


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.

Helpful resources

Announcements

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

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

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.

Users online (658)