This is my situation I can not solve:
Gallery1:OnSelect= Set(varSelectedLink;ThisItem.Link);;Navigate(Screen2)
The 2 columns for the connected List are: “Title” and “Link” (sample value of Link: 3.4)
Gallery2:OnSelect= Set(varSelectedCode;ThisItem.Code);;Navigate(Screen2)
The 2 columns for the connected List here are: “Name” and “Code” (Sample value of Code: RB)
Gallery3 should return selected items on the basis of the var’s from Gallery1 and 2
For Gallery3 I use: Items= Filter(TestTblSAK2;varSelectedLink in Link1 && (varSelectedCode in RB && RB.Value ="Ja"))
The colomns in this List “TesttblSAK2” are: Naam, Telnr, EB, RB,ZE,Link1,Link2.
Sample Values for EM,RB and ZE are “Ja”or “Nee” (Choicefield), samples for Link1 and Link2 are: 3.4, 5.6 etc)
If for example the chosen item in Gallery1/ Column “Link” is 3.4 AND the chosen Value in Gallery2 Column “Code” is RB, the Gallery3 should be filtered on both items. So the search should be: Is there a row with the value “3.4”in the Columns “Lik1”OR in “link2” AND a value “Yes” in the Column RB.
If so, The value of the column”Namm”en “Telnr” should become visible in Gallery3.
Hopefully someone can help 😊

Report
All responses (
Answers (