In a form to add new data, I have defaults values set in a data source. I would like to populate the Default value, but I cannot seem to find the syntax of the Lookup formula.
My data source (SP) looks like this:
IndustryList
| Industry | Topic1 | Topic2 |
| Industry1 | 1 | 2 |
| Industry2 | 3 | 4 |
The topic is known from the data card that is being entered on the form. The Industry value comes from a previously selected dropdown.
I expected to set Default to something like:
Lookup(IndustryList, Industry = ThisItem.Industry, Topic1)
However, I am not getting close to whatever syntax the Lookup formula requires and cannot find any documentation, or other community questions.