web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Setting the Default va...

Power Apps

Unanswered

Setting the Default value in a Gallery

(0) Share

Report

Report

Posted on by Yoshimitsu411

82

Hello

I have a filter gallery on my form and I am looking to set one of the values as the default.

For example:

Calcelled

Late

New <- I want to set New as the default

Closed

Items code uses a collection and works perfectly

Gallery > Items > Sort(Distinct(EmpCollection, 'Employee Status'.Value),Result,Ascending)

Default code does not work

Gallery > Default > LookUp(EmpCollection, 'Employee Status'.Value="New")

Error message - Invalid Formula. Expected a value compatible with 'Items'

Any suggestions?

Thanks,

Yoshi

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Ramole Super User 2024 Season 1 on at

Like (0)

Report

Re: Setting the Default value in a Gallery

Hi @Yoshimitsu411

This post will explain how to do it
How to set default item in a Gallery

Gallery control in Power Apps

Was this reply helpful? Yes No
Yoshimitsu411 82 on at

Like (0)

Report

Re: Setting the Default value in a Gallery

Thanks @Ramole I tried that link and a few others before posting to this forum. Unfortunately, it doesn't work.

Was this reply helpful? Yes No
Verified answer

Yoshimitsu411 82 on at

Like (1)

Report
Re: Setting the Default value in a Gallery

I fixed it.

Based on the error message "Invalid Formula. Expected a value compatible with 'Items'", the formula is looking for a record, so I simply wrapped my Items code in a Lookup.

Gallery default code now looks like this.

LookUp(Sort(Distinct(EmpCollection, 'Employee Status'.Value),Result,Ascending), Result="New")

Thanks
Yoshi

Was this reply helpful? Yes No
Golly 127 on at

Like (0)

Report

Setting the Default value in a Gallery

Yoshimitsu411's fix worked for me, even though I have an if() statement in my Gallery.items!

Weird.

Was this reply helpful? Yes No

Join the conversation