SharePoint table1 has a lookup field, field1, from SharePoint table2. table 2 is comprised of ID column and three lookup fields, each from one of three other SP tables.
In my Power App, form1 is an edit form linked to table1. In form1, I want a dropdown for field1 showing to the user the 3 lookup fields in table2. I have collection1: table2.ID (as “idTmp”)|table2.col1|table2.col2|table2.col3 linked to dropdown1 (“modern”). It displays as required.
I have update for the data card for field1: LookUp(table2,ID= Dropdown1.Selected. idTmp).
It doesn’t work. A record is created or edited in table1 O.K. but field1 is blank. Any ideas? Thank you.

Report
All responses (
Answers (