Label Value To Refer To Datasource in equation

[yearlus]

I have an issue where i have multiple sources, where i am searching for data from an input.

I currently have a label which tells me which datasource this lookup is in.

I now want to use the result of the to put into subsequent lookups as the data source, so that the whole search is not looking through 5 datasources again.

I have tried refering to the text and the value but with no luck, any suggestions please?

[v-jefferni · Accepted solution]

Hi @yearlus ,

If I understand correctly, would you like to make LookUp function reference to Label Text as the data source? If so, it's not possible. Normally, data type of data sources is Table, with a static name.

The workaround to achieve you goal is to use Switch function"

Switch(
       Label.Text,
       "Data source1"
       LookUp(DataSource1,...),
       "Data source2"
       LookUp(DataSource2,...),
       "Data source3"
       LookUp(DataSource3,...),
       ...
)

Hope this helps.

Best regards,