UPDATE:
I fixed the error. The error was caused by the "Update" in the DataCard, I just have to change the DataCard Update Function to either DataCardValue38.SelectedText.Value or DataCardValue38.SelectedText.Result then the error disappeard. However my Allowed Value drop down doesn't work. It doesn't five me the list of selection from the
Distinct(Filter('DataSourceA', Country in "US"),Available Fruit) function .
Please help!
Hello community,
I am trying to build an edit form from DataSource B, one of the edit field DataSourceB_Fruits will be set to have Allowed Values because DataSourceB_Fruits can only have values from DataSourceA_Available_Fruit
I have the Allowed Values Item function set as follow:
Distinct(Filter('DataSourceA', Country in "US"),Available Fruit)
However, when I set the Allowed Values to come from DataSourceA, the DataCard in the form then appeared to have error - with error msg as "Name isn't valid. This identifier isn't recognized", I am assuming the reason for the error is because DataCard is reading from DataSource B.
To have a further example: I have two tables
Table 1 - Country_With_Available_Fruit
| PK | Country | Available_Fruit |
| 1 | US | Apple |
| 2 | UK | Apple |
| 3 | Canada | Apple |
| 4 | France | Apple |
| 5 | Gernamy | Apple |
| 6 | US | Banana |
| 7 | UK | Banana |
| 8 | Canada | Banana |
| 9 | France | Banana |
| 10 | Gernamy | Banana |
DataSourceB Table 2 - US_Available_Fruit - with Price
| PK | Fruit | Price |
| 1 | Apple | $10 |
| 2 | Banana | $5 |
Is it possible to achieve this in PowerApps in anyway, if so, how?
Thank you in advance!
