Dataverse table not returning value in power apps

[action1]

I have a Dataverse table with 4000 rows that is used to store pricing. I have a button on the power apps which has the logic to map all the fields and based on that combination pull the pricing from the Dataverse table. The logic works for some combinations and return the expected price but for the scenarios where its not working still all the parameters are returned as expected.

The code on OnSelect button is here-

UpdateContext({
selectedPrice: LookUp(
'Price Master Files',
Region= Text(FieldOnScreenOne)&&
Supplier=Text(SupplierParam)&&
'Waste Type'= Text(WasteTypeParam)&&
'Bin/Receptacle size '=Text(BinSizeParam) &&
'Collection Frequency'= Text(SerFreqParam)&&
'Pricing Type' = Text(DataCardValue33.Selected.'Price Type')
).'Collection ($/Pick-Up)',
selectedPrice1: LookUp(
'Price Master Files',
Region= Text(FieldOnScreenOne)&&
Supplier=Text(SupplierParam)&&
'Waste Type'= Text(WasteTypeParam)&&
'Bin/Receptacle size '= Text(BinSizeParam) &&
'Collection Frequency'= Text(SerFreqParam)&&
'Pricing Type' = Text(DataCardValue33.Selected.'Price Type')
).'Additional Disposal Costs ($/Tonne, Excluding Land'
})

For a working scenario , I see all the parameters and pricing value pulled correctly.

Scenario where the pricing is not pulled(selectedPrice, selectedPrice1 as blank) at all, still the parameters are returned as shown below-

 The Dataverse table structure is as shown below-

Please help me understand if I am missing something here and how to pull the price for all the combinations that we have in the pricing table.

[BCBuizer]

HI @action1 ,

Just to rule things out: for the combination of parameters where this is not working as expected, does an entry in your table even exist?

[action1]

Hi @BCBuizer ,

Thanks for your response. Yes, the entry for the combination exists in the database. 

I created a table with just 9 rows to see if the code works for all combination, but there also the 2 red marked combinations are not working, while rest all are working as expected.

The code used is here-

UpdateContext({
selectedPrice: LookUp(
Pricings,
Region= Text(FieldOnScreenOne)&&
Supplier= Text(SupplierParam)&&
'Waste Type'= Text(WasteTypeParam)&&
'Bin Type'=Text(BinEquipmentType)&&
'Bin/Receptacle size '=Text(BinSizeParam) &&
'Collection Frequency'= Text(SerFreqParam)&&
'Pricing Type' = Text(DataCardValue33.Selected.'Price Type')
).'Collection ($/Pick-Up)',
selectedPrice1: LookUp(
Pricings,
Region= Text(FieldOnScreenOne)&&
Supplier= Text(SupplierParam)&&
'Waste Type'= Text(WasteTypeParam)&&
'Bin Type'=Text(BinEquipmentType)&&
'Bin/Receptacle size '=Text(BinSizeParam) &&
'Collection Frequency'= Text(SerFreqParam)&&
'Pricing Type' = Text(DataCardValue33.Selected.'Price Type')
).'Additional Disposal Costs ($/Tonne, Excluding Land'
})

Not sure what is the reason for this. Appreciate your help.

[BCBuizer]

Hi @action1 ,

For the combination of parameters you said didn't work in the opening post, I don't see an entry in the table, so if there are only these 9, that's the issue for those.

As for the 2 entries in the table you say are not working, can you post a screenshot of the parameters that you are using? The issue may be in a typo or casing.

[action1]

Hi @BCBuizer ,

Please find the screen shots below for the 2 scenarios not working, the variables are returned correctly but price is not pulled-

Table shows the below scenarios marked in red-

Thanks

[BCBuizer]

HI @action1 ,

Given that the only common denominator between the two non-workin scenarios is in the supplier name, can you check if there's maybe a hidden space in for those values in the table (e.g. "Cleanaway " instead of "Cleanaway")?

[action1]

Hi @BCBuizer ,

I already checked that there is no space. I am not able to fix this issue. Can this be an issue with Dataverse table?

[BCBuizer]

Hi @action1,

I highly doubt the issue is with the table. Perhaps try and delete these two items and then re-create them.