Hello everyone,
I was wondering is it possible to have a flow that can accept a dynamic amount of parameters based off of a condition?
For example, let's say I have a couple SQL tables I want my PowerApp to be able to perform CRUD operations on and I need to create a flow to add data to the tables. Table 1 is called Sales with columns Date, Discount, SaleTotal, and Table 2 is called Products with columns Category, SubCategory, Price, and Manufacturer..
I think it's rather unoptimized to have to create a new version of the same flow function for every table just because they have a different set of fields. Is there a way to make it so a flow can accept an optional number of arguments so I can make a function that can either look like SubmitData('Sales', '2/24/19', '3.00', '24.50') or SubmitData('Products', 'Office', 'Desk', '119.99', 'OfficeEnsemble') depending on what the first argument is.