Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Fromulas Chaining aka Fluent Interface

I would love to be able to write formulas with chaining instead of nesting them so i.e.:



ClearCollect(MyCollection, AddColumns(AddColumns(Employees, "FirstName", "johnny"), "ProperName", Proper(FirstName)));
UpdateContext({varLastID: First(FirstN(Sort(sharepoint_list, ID, Descending), 1)).ID});



Would look like this:


ClearCollect(MyCollection, Employees.AddColumns("FirstName", "johnny").AddColumns("ProperName", Proper(FirstName)));
UpdateContext({varLastID:  Sort(sharepoint_list, ID, Descending).FirstN(1).First().ID});


Status: New