best way to improve the workflow building would be improving the basic nodes and functionalities in the first place.
see e.g.
- String Manipulation (Multi Col) still has no column selection by type
- Math Operation (Multi Col) still has no column selection by type
- String to Date&Time still has no column selection by type
- The new Row Filter can’t wildcard filter Path
There is no easy way to combine a Date column and a Time column into a Datetime except for concatenating casted Strings- Lag column can only lag forward (1,2,3,…) but not backward (-1,-2,-3,…)
- most of the new nodes (e.g. Value Lookup) cannot use the RowID. requiring you to cast it into the dataset before using those nodes
- We had a Date&Time based Row Filter for ages but no Splitter - always requiring a subsequent Reference Row Splitter
- There is no Number to Duration node. Column Expression now officially Legacy but Expression node not covering that either
- No way to combine two columns of type Duration into one without casting
- There is a Parallel Chunk Loop extension but no Concurrent Loop option
- Parquet Files cannot be read from \Server\DriveLetter$ paths. Further, encrypted .parquet files cannot be read (or written).
Add 'append' option to the SharePoint Online List Writer (which will hopefully become resolved after 2 years and 9 months