DefaultValue formula error: invalid formula expected a value compatible with items

(0) Share

Report

Posted on by iwonder

1,146

Thank you for taking the time to read my question.

I have a gallery that gets it's Items from a Collection. I want to set the default value of this gallery because I have another gallery that is filtered based on the first gallery's selected item. The Collection only has one record ever.

I tried the following formula but got the error: invalid formula expected a value compatible with items

The formula works great for a Label.

I have not been able to find a similar error message on line, most say "Datasource" instead of "items".

Formula: First(FacilityAccess).FacilityList

Thanks again for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@iwonder

Your Default property must match the schema of the Items property.

If that doesn't provide a clue, then post your Default and your Items formulas to start.

I hope this is helpful for you.

Was this reply helpful? Yes No
iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes

Thank you very much for your reply. I must admit, I'm not sure what you mean by Schema.

Note: I just realized I stated incorrectly that there is only one record in my Collection "FacilityAccess" I meant there is only one Column.

Gallery1_2 (I'll be renaming this shortly)
Items: FacilityAccess.FacilityList
Default: First(FacilityAccess).FacilityList

If I add a label to my screen
Label2.Text = First(FacilityAccess).FacilityList
Gallery1_2.Default = Lookup(FacilityAccess,FacilityList = Label2.Text)
This works.... but I don't understand why.

Thanks

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@iwonder

This is because your Default is a Text value and you need to supply a Record to the Default for a Gallery.

So, either change your Items property to : FacilityAccess

Or change your Default to : {FacilityList: LookUp(FacilityAccess,FacilityList = Label2.Text, FacilityList)}

Which will then be a record with the corresponding schema of your Items property.

Was this reply helpful? Yes No
iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much @RandyHayes

My final solution is

Gallery.Items = Filter(FacilityLines,Facility = Gallery1_2.Selected.Title1_2.Text)

Thanks!

Was this reply helpful? Yes No