Create |
DateKey |
Returns a DateKey table with a list of working days based on a list of holidays that can be defined as a separate list. |
M |
Get |
EasterDate |
Returning Date of Easter Sunday for inputted Year. |
M |
Get |
DataToJson |
Returns inputted table as a one JSON structure. |
M + R |
Get |
CumulatedValueByCategoryAndPreviousDates |
Return cumulated summary by specific category and previous dates. This function required Table, String names of columns: {Cumulation, Category, Date} and Columns thats will be used as Category and DateKey |
M |
Get |
RangeOfNumbers |
Return list of numbers between start number and latest number that an inputted count of digits can create. If you use "true" and fromStart variables, then numbers will be added to the start; otherwise, it will end. |
M |
Get |
ServiceDeskIssuesDataFromJiraCloud |
Getting all data of issues from JIRA CLOUD (including history). |
M |
Get |
WorkingMDBetweenDatesAndByWorkingHours |
Returning Time between StartDateTime and EndDateTime by Working hours and working days (without weekends). |
M |
Get |
AllWorldCountriesWithDetails |
Geting table of wold Countries with details about them. |
M |
Get |
NumbersFromText |
Returns all numbers from input text source |
M |
Get |
TableOfLanguages |
Returns a table with all defined languages and their short codes. |
M |
Get |
Metadata of Files and their subfolders |
Returns all metadata from Sharepoint files in a folder and all subfolders. |
M |
Send |
DataToPowerAutomateAsJSON |
Sending JSON structured data to Power Automate HTTP endpoint and returning TEXT value Send or Something happened. |
M |
Get |
ColoredExcelCellsExtraction |
This function extract all colored cells (can also extract just specific color or all colors without selected one) |
M |
Get |
Extract Years With Two Months With 5 FIDAYS, SATURDAYS and SUDAYS |
Returns a list of years with two months with 5 Fridays, Saturdays and Sundays. |
M |
Get |
DEC to BIN Convertor |
Transfer decimal number to binary number. |
M |
Get |
RGB Tint Modifier |
Inserted RGB color code: R: 68, G: 114, B: 196 and TINT 60% as a number and you will recive modified color code |
M |
Get |
Converter Between HEX and RGB Color codes |
Converts RGB color code to HEX code and VICE VERSA. |
M |