Share
Report
60I 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.
Regards
All responses (
Answers (
