Announcements
I want to display notes for an item that were written by the logged user; I typed this code, but it returns the error "Expected text value"
Filter('datasource','Created By'.Email=User().Email & ID.Value=Gallery.Selected.ID).notes
Hello @Al_Rawan ,
That's because the "Filter" function return a Collection.
You can use the "Lookup" function to get the element :
LookUp('datasource','Created By'.Email=User().Email && ID.Value=Gallery.Selected.ID).notes
You can also put a "First" before your "Filter" to take the first element of the collection returned :
First(Filter('datasource','Created By'.Email=User().Email && ID.Value=Gallery.Selected.ID).notes)
Tell me if It's ok for you 🙂
Henri
Thank you @HenriDesmet59
Lookup is worked with me! but only returned the first item, I want to return all items.
I have changed display form to gallery and that's worked thanks
Ah so keep the filter, and If you want to display all notes you can display them in a gallery
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
