I am facing this problem many times. I try many ways to solve this problem. But, I don't know how to solve this problem. If anyone gives me a suggestion. It will be helpful for me.
If the code within the screenshot is written in the Text property of the label, it should work. I unfortunately was unable to recreate the issue on my end.
However with Explicit Column selection turned on (will be by default), it might be beneficial to check whether (1) ThisItem.rep_id actually has a value in your gallery and (2) whether the Filter actually returns something. It might be that the Filter() is simply not retrieving values due to there being no matching values (check your data) or rep_id not having a value caused by Explicit Column selection.
Should rep_id not have a value, the only 2 workarounds I know of is:
(option 1) In the Items property of your gallery, hardcode the needed columns with the ShowColumns() formula
(option 2) Create a new label in the gallery, set it to ThisItem.rep_id and make it invisible
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
Thanks for your response. But for this error, my data is not showing the gallery. so what should I do?
Hi @Sohan014,
The message you are receiving is not exactly an error but more of a notification that the editor cannot evaluate the line of code since it is using the scope of a gallery or form.
In other words, if the text is displaying correctly - you have nothing to worry about. This notification will always appear when using scope (e.g. ThisItem) - even with very simple formulas such as ThisItem.Name. As a note: ThisItem can only be used in a Gallery or Form - which will refer to a particular row in the data set.
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
60
stampcoin
48