Share
Report
1,133I have several rows of data in my data source (SharePoint list). Here is the sample of it. The goal is to calculate "official fees" as per the formula defined in the last column. The problem here is for almost every incoming combination of Jurisdiction, task type and number of classes/designs the formula varies.
For example if incoming values are like Jurisdiction = "EUIPO", task type = "trademark filing" and number of classes/designs = 5, then official fees = x+[y*(number of classes-3)] = 1050+[150*(5-3)] = 1350. Incoming data can be of several combinations and each combination have its unique formula. I have closely 200 rows with different formulae.
Is Power Automate helpful at all here? In a most inefficient way I can use odata filter query to pick the unique row and use several parallel branches to calculate the official fees. But I think there is a limit on number of parallel branches nor that method is efficient. How can I build this using the most efficient way? Can someone please advice. Thanks a lot in advance.
All responses (
Answers (
