I have two forms on a screen for different data sources. Source 1 contains a field called "ID" . Source2 contains a field called "Source1_ID" which ties the specific record back to its associated record in Source 1.
The form for source 1 pulls the item based on the item selected from a gallery (same source for both). I am now trying to get its associated record in Source 2 to show in the Source 2. I have tried a filter formula on the item property of the form, but its erroring out saying it returns a table instead of a specific record. How do I filter/search to a specific record for a form?
Solved! Go to Solution.
Yea that is what I tried first and it errors out stating it was expecting a record. I just added the First formula to the beginning of my filter to change the results from a table to a single record (the filter returned a single record anyways) and that worked.
Try this on your Item for source 2 form:
Lookup(Source2, Source1_ID = Galleryx.Selected.ID)
That will lookup in the source 2 list a specific record where the Source1_ID column is equal to the ID selected in the Gallery
I hope this is helpful for you.
Yea that is what I tried first and it errors out stating it was expecting a record. I just added the First formula to the beginning of my filter to change the results from a table to a single record (the filter returned a single record anyways) and that worked.
Lookup returns single records. Filter returns a table of matching records.
Glad you got it working.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
186 | |
70 | |
37 | |
34 |
User | Count |
---|---|
349 | |
277 | |
121 | |
78 | |
59 |