Hi @sajarac ,
Could you please share a bit more about your scenario?
Do you want to populate your SPL prices with values retrieved from the SPL States multiply by the corresponding item value?
Further, could you please share more details about the "Value" column, "CA" column, "CO" column, .... in your SPL prices? Are they all Currency type column?
Based on the needs that you mentioned, I think the ForAll function and Patch function could achieve your needs. I assume that the "Value" column, "CA" column, "CO" column, .... are all Currency type column in your SPL prices, please take a try with the following workaround:
1. Create a Blank app, then add your two SP List data sources (Prices & States) in it.
2. Add a "Submit" button in your app, set the OnSelect property to following:
ForAll(
RenameColumns(Prices, "Items", "Items1", "Value", "Value1"), // Prices represents your SPL Prices
Patch(
Prices,
LookUp(Prices, Items = Items1),
{
CA: LookUp(States, State = "CA", Value) * Value1, // States represents your SPL States
CO: LookUp(States, State = "CO", Value) * Value1,
CT: LookUp(States, State = "CT", Value) * Value1,
FL: LookUp(States, State = "FL", Value) * Value1,
IA: LookUp(States, State = "IA", Value) * Value1,
IN: LookUp(States, State = "IN", Value) * Value1,
KS: LookUp(States, State = "KS", Value) * Value1
}
)
)
Please consider take a try with above solution, check if the issue is solved.
Note: I assume that the "Value" column, "CA" column, "CO" column, .... in your SPL prices configured as below:
Best regards,
