cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmirZolf
Helper I
Helper I

Change the rule to produce a {0} value

I am trying to show a single item in a label but it shows me the error: "Change the rule to produce a {0} value"

I am filtering by ID that is unique and I also tried converting it to text with no luck:

 

Filter('myTable',ID=varSelectedID).Name

or

Text(Filter('myTable',ID=varSelectedID).Name)

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

@AmirZolf 

Filter returns multiple records so that's the reason for the error. If you want to display the first item that matches the condition, you would call the LookUp function.

Lookup('myTable',ID=varSelectedID).Name

View solution in original post

2 REPLIES 2
timl
Super User
Super User

@AmirZolf 

Filter returns multiple records so that's the reason for the error. If you want to display the first item that matches the condition, you would call the LookUp function.

Lookup('myTable',ID=varSelectedID).Name
AmirZolf
Helper I
Helper I

Thank you, that works.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,160)