I know this is simple but im having a blank moment.
How do i return another field value based on a filter value outside the gallery.
basically the user enters a ref number in one textinputand the other field value is returned
i thought it would be simple!
Solved! Go to Solution.
Thanks for responding (again :))
The textinput field (course ref) is the filter input for my gallery.
what i would like is to return another value in my sharepoint list that is a common value against the reference ie course name.
there would be multiple entries of people but the course ref and course name would be linked to each other
1234 = course 1
2345 = course 2
hopefully that clarifies?
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
This does not work unfortunately
Let me try to explain better.
I use a text input for filtering a gallery
the data is called from a sharepoint list
i have the following fields
ID Title candidate_name candidate_no course_ref course_name
person/group single text single Text Choice
the gallery is being used to return name of candidates who are on a course (i am patching signatures with pen input)
When the course ref is inputted i would like the course_name to show in another label/box but not inside the gallery itself but independant underneath the course ref input box?
There could be multiple candidates on the same course_ref
Regards Gary 🙂
HI @gazzo1967 ,
Do you want to display the course name within another Label (outside the Gallery) based on the entered course_ref value?
I have made a test on my side, please take a try with the following workaround:
Set the Text property of the Label control to following:
LookUp('YourSPList', course_ref = CourseRefTextInput.Text, course_name.Value)
LookUp('YourSPList', course_ref = CourseRefTextInput.Text).course_name.Value
Please take a try with above solution, check if the issue is solved.
Note: I assume that the entered course_ref value could only match single one course name in your SP List.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand