Unanswered

Gallery.Selected not working when editing an item

(1) Share

Report

Posted on by Community Power Pla...

Hi,
I'm having an issue with Gallery1.Selected when editing an item. It tells me Invalid formula. It was expected a compatible value with DataSource. I've already checked and the DataSource of the Gallery and the Form are the same. Anyone know how to solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Community Power Pla... on at

Like (4)

Report

I've placed the formula Lookup('DataSource', ID=Gallery1.Selected.ID) in the item property of the form and it worked fine.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (5)

Report

@Anonymous

This is most likely due to your formula on the Items property of the Gallery. If you are shaping the data in any way (AddColumns, ShowColumns, DropColumns, GroupBy, etc.) then the schema of the record of the Gallery will not match the datasource any longer and you will get the error you saw.

The approach you took is the way to resolve that...just look up the actual record.

If the shaping of the data in the Gallery Items was relatively "slight" (i.e. only added a column), then you can also drop the added column in the Item property of the Form - it's a few more steps to be able to do that. I call this option B. So your choice of what is option A works just as well.

Was this reply helpful? Yes No
talal 2 on at

Like (0)

Report

I keep getting "Lookup is an unknown or Unsupported Function" when I add it into Item Property of Editform. Its driving me nuts since last 4 hours.. any idea what am I doing wrong? it does have the same source (SharePoint List)

picture.PNG

Was this reply helpful? Yes No
Ryan_Fitz 7 on at

Like (0)

Report

Thank you, this has resolved my own issue. As mentioned below, imagine this is due to my original gallery having multiple filters perhaps.

Was this reply helpful? Yes No
zerocool55 94 on at

Like (0)

Report

@tada1
use the correct syntax: LookUp(YourDataSource, ID=Gallery.Selected.ID)

Was this reply helpful? Yes No
AbidKhan1 2 on at

Like (0)

Report

Here is the mistake i was making.
I was using a different data source for edit forms and different data sources for Gallery that is why it kept giving me an error message when i tried to set an item. As soon as i selected the same data set the error went away.
Hope this Helps!!

Was this reply helpful? Yes No