cancel
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.:

This:

 

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