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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks