Finding Maximum Value,,,,,

[ravisinghdas199]

Scenario:-
You have a list of dictionaries where each dictionary represents a product with a “Name” and “Price” field. How would you find the product with the highest price using LINQ in UiPath?

[ashokkarale]

@ravisinghdas199,

Use this LINQ

maxPriceProduct = products.OrderByDescending(Function(product) Convert.ToDouble(product("Price"))).First()

Thanks,
Ashok

[rlgandu (Rajyalakshmi Gandu)]

@ravisinghdas199

highestPriceProduct = products.OrderByDescending(Function(p) Convert.ToDecimal(p("Price"))).First()

[bavyaravu133]

@ravisinghdas199

highestPriceProduct = products.OrderByDescending(Function(p) Convert.ToDecimal(p(“Price”))).First()

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @ravisinghdas199

Let’s say ProductPrice is the Dictonary of String, Object datatype variable.
HighestPricedProduct is the String variable which stores the Product which has high cost

Use the below linq expression in assign activity,

- Assign -> HighestPricedProduct = ProductPrice.OrderByDescending(Function(p) Convert.ToDouble(p("Price"))).First()("Name").ToString()

The above expression will get the Highest price product in the Dictionary variable.

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

Check the below workflow for better understanding,

Result-

Hope it helps!!