Announcements
Hello! I want to do something like inner join in my program. I have a SP list where i enter trainigs for people(ss1) and in the first Gallery i have the trainigs that a person just done like ss2/3. My problem is that i have a database where i have all the trainigs and the job title that have this trainig(its multiple choice)ss4. As you can see in ss2 i have trainigs with no name because i have the same trainigs for two jobs names. I want something like ss5 to be the IDTipFormare from SP list FormariPersonal the same as SP list TipFormare(the id from this table is the same) and to verify from Choice if the name of job is the same to not display all. Can you please help me?
ss1
ss2
ss3
ss4
ss5
Hi @Antal_Bogdan ,
Can you please add ss5?
@BCBuizer its photo and under the photo is ss name sorry
Can you explain this sentence?
"As you can see in ss2 i have trainigs with no name because i have the same trainigs for two jobs names."
What I see is you have a mapping between people (MichelinID) and trainings (IDTipFormare). Your gallery filters this for the selected MichelinID, so you should only have a list of trainings in there that are relevant for that person (ss2). Per item, a LookUp is performed that gives the name (DenumireFormare) per item, based on the IDTipFormare (ss3).
Unfortunately I don't see anything that may cause any items to be blank.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 355 Most Valuable Professional
11manish 209 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2