\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{RPAWorld (VJR)} \pdfinfo{ /Title (power-automate-desktop-actions.pdf) /Creator (Cheatography) /Author (RPAWorld (VJR)) /Subject (Power Automate Desktop Actions Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{0066FF} \definecolor{LightBackground}{HTML}{EFF5FF} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Power Automate Desktop Actions Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{RPAWorld (VJR)} via \textcolor{DarkBackground}{\uline{cheatography.com/153513/cs/33003/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}RPAWorld (VJR) \\ \uline{cheatography.com/vjr} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 9th July, 2022.\\ Updated 14th December, 2023.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Variables}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Truncate number}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the integral or fractional digits of a numeric value, or round up the value to a specified number of decimal places\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Generate random number}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Generate a random number or a list of random numbers that fall between a minimum and maximum value\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Clear list}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Remove all items from a list\{\{bl=2\}\}} \tn % Row Count 10 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Remove item from list}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Remove one or multiple items from a list\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Sort list}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sort the items of a list. Use items of the same type\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Shuffle list}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a random permutation of a list\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Merge lists}}} \tn % Row Count 20 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Merge two lists into one\{\{bl=2\}\}} \tn % Row Count 21 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reverse list}}} \tn % Row Count 22 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Reverse the order of the items of a list\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Remove duplicate items from list}}} \tn % Row Count 25 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Remove the multiple occurrences of items in a list, so that in the resulting list each item will be unique\{\{bl=2\}\}} \tn % Row Count 28 (+ 3) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find common list items}}} \tn % Row Count 29 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Compare two lists and create a new list with the items that are common to both\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Variables (cont)}} \tn % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Subtract lists}}} \tn % Row Count 1 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Compare two lists and create a new list with the items that are in the first list but not in the second\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Retrieve data table column into list}}} \tn % Row Count 5 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert the contents of a data table column into a list\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert JSON to custom object}}} \tn % Row Count 8 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert a JSON string to a custom object\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert custom object to JSON}}} \tn % Row Count 11 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert a custom object to a JSON string\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add item to list}}} \tn % Row Count 14 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Αppend a new item to a list\{\{bl=2\}\}} \tn % Row Count 15 (+ 1) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create new list}}} \tn % Row Count 16 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new empty list\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Increase variable}}} \tn % Row Count 18 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Increase the value of a variable by a specific amount\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Decrease variable}}} \tn % Row Count 21 (+ 1) % Row 35 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Decrease the value of a variable by a specific amount\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 36 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set variable}}} \tn % Row Count 24 (+ 1) % Row 37 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set the value of a new or existing variable, create a new variable or overwrite a previously created variable\{\{bl=2\}\}} \tn % Row Count 27 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{UI automation}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If window contains}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a conditional block of actions depending on whether a specific piece of text or UI element exists in a window\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for window content}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspends the execution of the automation until a specific piece of text or UI element appears or disappears from a Window\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If image}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action marks the beginning of a conditional block of actions depending on whether a selected image is found on the screen or not\{\{bl=2\}\}} \tn % Row Count 12 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Use desktop}}} \tn % Row Count 13 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Performs desktop and taskbar related operations\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Select tab in window}}} \tn % Row Count 16 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Selects a tab from a group of tabs\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for image}}} \tn % Row Count 18 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action waits until a specific image appears on the screen or on the foreground window\{\{bl=2\}\}} \tn % Row Count 21 (+ 3) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hover mouse over UI element in window}}} \tn % Row Count 22 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hover the mouse over any UI element on window\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Click UI element in window}}} \tn % Row Count 25 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Clicks on any UI element of a window\{\{bl=2\}\}} \tn % Row Count 27 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Select menu option in window}}} \tn % Row Count 28 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Selects an option in a menu of a window\{\{bl=2\}\}} \tn % Row Count 30 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{UI automation (cont)}} \tn % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Drag and drop UI element in window}}} \tn % Row Count 1 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Drags and drops a UI element of a window\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Expand/collapse tree node in window}}} \tn % Row Count 4 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Expands or collapses a node of a tree view residing in a window\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If window}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action marks the beginning of a conditional block of actions depending on whether a window is open or not or whether a window is the focused (foreground) window\{\{bl=2\}\}} \tn % Row Count 11 (+ 4) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for window}}} \tn % Row Count 12 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspends the execution or the process until a specific window opens, closes, get or loses the focus\{\{bl=2\}\}} \tn % Row Count 15 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{UI automation - Data Extraction}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get details of window}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets a property of a window such as its title or its source text\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get details of a UI element in window}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the value of a UI element's attribute in a window\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get selected checkboxes in window}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the names of the selected checkboxes in a checkbox group or the state of a specific checkbox\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get selected radio button in window}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the names of the selected radio button in a radio button group or the state of a specific radio button\{\{bl=2\}\}} \tn % Row Count 14 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract data from window}}} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extracts data from specific parts of a window in the form of single values, lists, or tables\{\{bl=2\}\}} \tn % Row Count 18 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Take screenshot of UI element}}} \tn % Row Count 19 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Takes a screenshot of a UI element in window\{\{bl=2\}\}} \tn % Row Count 21 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{UI automation - Form filling}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Focus text field in window}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the focus on a text box of a window and scrolls it into view\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Populate text field in window}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Fills a text box in a window with the specified text\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Press button in window}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Presses a window button\{\{bl=2\}\}} \tn % Row Count 8 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Select radio button in window}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Selects a radio button on a window\{\{bl=2\}\}} \tn % Row Count 10 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set checkbox state in window}}} \tn % Row Count 11 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Checks or unchecks a checkbox in a window form\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set drop-down list value in window}}} \tn % Row Count 14 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets or clears the selected option(s) for a drop-down list in a window form\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{UI automation - Windows}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get window}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets a running window, for automating desktop applications\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Focus window}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Activates and brings to the foreground a specific window\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set window state}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Restores, maximizes or minimizes a specific window\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set window visibility}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Shows a hidden window or hides a visible window\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move window}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the position of a specific window\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Resize window}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the size of a specific window\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close window}}} \tn % Row Count 18 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Closes a specific window\{\{bl=2\}\}} \tn % Row Count 19 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Browser automation}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If web page contains}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Mark the beginning of a conditional block of actions, depending on whether a specific piece of text or element exists in a web page\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for web page content}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspend the flow until a specific piece of text or web page element appears or disappears from a web page\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch new Internet Explorer}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launch a new instance or attach to a running instance of Internet Explorer for automating web sites and web applications\{\{bl=2\}\}} \tn % Row Count 12 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch new Firefox}}} \tn % Row Count 13 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launch a new instance or attach to a running instance of Firefox for automating web sites and web applications\{\{bl=2\}\}} \tn % Row Count 16 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch new Chrome}}} \tn % Row Count 17 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launch a new instance or attach to a running instance of Chrome for automating web sites and web applications\{\{bl=2\}\}} \tn % Row Count 20 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch new Edge}}} \tn % Row Count 21 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launch a new instance or attach to a running instance of Edge for automating web sites and web applications\{\{bl=2\}\}} \tn % Row Count 24 (+ 3) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create new tab}}} \tn % Row Count 25 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new tab and navigate to the given URL (supported in Edge, Chrome and Firefox)\{\{bl=2\}\}} \tn % Row Count 28 (+ 3) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Go to web page}}} \tn % Row Count 29 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Navigate the web browser to a new page\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Browser automation (cont)}} \tn % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Click link on web page}}} \tn % Row Count 1 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Click on a link or any other element of a web page\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Click download link on web page}}} \tn % Row Count 4 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Click on a link in a web page that results in downloading a file\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run JavaScript function on web page}}} \tn % Row Count 7 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Run a JavaScript function on the web page and get the returned result\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hover mouse over element on web page}}} \tn % Row Count 10 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hover the mouse over an element of a web page\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close web browser}}} \tn % Row Count 13 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Close a web browser window\{\{bl=2\}\}} \tn % Row Count 14 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Browser automation - Web form filling}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Focus text field on web page}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set the focus on an input element of a web page and scroll it into view\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Populate text Field on web page}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Fill a text field in a web page with the specified text\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set check box state on web page}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Check or uncheck a check box in a web form\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Select radio button on web page}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Select a radio button on the web page\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set drop-down list value on web page}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set or clear the selected option for a drop-down list in a web form\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Press button on web page}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Press a web page button\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Browser automation - Web data extraction}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract data from web page}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract data from specific parts of a web page in the form of single values, lists, rows or tables\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get details of web page}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get a property of a web page, such as its title or its source text\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get details of element on web page}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the value of an element's attribute on a web page\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Take screenshot of web page}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Take a screenshot of the web page (or an element of the web page) currently displayed in the browser and save the image into a file or to the clipboard\{\{bl=2\}\}} \tn % Row Count 15 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{HTTP}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Download from web}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Downloads text or a file from the web and stores it\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Invoke SOAP web service}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes a method from a SOAP web service\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Invoke web service}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes a web service by sending data and retrieves the response from the web service\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Mouse and keyboard}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Block Input}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Blocks user mouse and keyboard input, so that the flow can perform mouse and keyboard actions without interference from the user\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get mouse position}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the current position of the mouse cursor on the screen in pixel coordinates\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move mouse}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves the mouse to a specific position\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move mouse to image}}} \tn % Row Count 12 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves the mouse over an image found on screen or on the foreground window\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move mouse to text on screen (OCR)}}} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves the mouse over a text found on the screen or on the foreground window using OCR\{\{bl=2\}\}} \tn % Row Count 18 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send mouse click}}} \tn % Row Count 19 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sends a mouse click event\{\{bl=2\}\}} \tn % Row Count 20 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send keys}}} \tn % Row Count 21 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sends keys to the application that is currently active\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Press/release key}}} \tn % Row Count 24 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Presses (and holds) or releases one or more modifier keys (Alt, Control, or Shift)\{\{bl=2\}\}} \tn % Row Count 26 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set key state}}} \tn % Row Count 27 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the state (on or off) for the keys Caps Lock, Num Lock or Scroll Lock\{\{bl=2\}\}} \tn % Row Count 29 (+ 2) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for mouse}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Mouse and keyboard (cont)}} \tn % Row 19 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspends the execution of the flow until the mouse pointer changes, usually to or from the 'wait cursor' or hourglass\{\{bl=2\}\}} \tn % Row Count 3 (+ 3) % Row 20 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get keyboard identifier}}} \tn % Row Count 4 (+ 1) % Row 21 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the active keyboard identifier from the machine's registry\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 22 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for shortcut key}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Pause the flow run until a specific shortcut key is pressed. Shortcut keys must contain at least one key or a key and one of (ctrl, alt, shift). Multiple shortcut keys can be defined\{\{bl=2\}\}} \tn % Row Count 11 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Azure}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create session}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates an Azure session\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get subscriptions}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets subscriptions that the current account can access\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{End session}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Ends an Azure session\{\{bl=2\}\}} \tn % Row Count 7 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Azure - Resource groups}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get resource groups}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the resource groups based on the specified criteria\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create resource group}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a new resource group\{\{bl=2\}\}} \tn % Row Count 5 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete resource group}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes the specified resource group and all the contained resources\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Azure - Virtual machines}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get virtual machines}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the basic information for the virtual machines\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Describe virtual machine}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets all the information for the virtual machine(s) based on the specified criteria\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Start virtual machine}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Starts the virtual machine\{\{bl=2\}\}} \tn % Row Count 8 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Stop virtual machine}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Stops the virtual machine and deallocates the related hardware (CPU and memory) and network resources\{\{bl=2\}\}} \tn % Row Count 12 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Shut down virtual machine}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Shuts down the operating system of a virtual machine\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Restart virtual machine}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Restarts a virtual machine\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Cryptography}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Encrypt text with AES}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Encrypt a string with AES, using a key and a specified encoding format\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Decrypt text with AES}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Decrypt a string with AES based on a specified key and an encoding format\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Encrypt from file with AES}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Encrypt the contents of a file with AES, using a key and a specified encoding format\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Decrypt to file with AES}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Decrypt a string to a file with AES based on a specified key and an encoding format\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hash text}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hash a string, using a specified algorithm and an encoding format\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hash from file}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hash the contents of a file, using a specified algorithm and an encoding format\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hash text with key}}} \tn % Row Count 19 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hash a string with a key, using a specified algorithm and an encoding format\{\{bl=2\}\}} \tn % Row Count 21 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Hash from file with key}}} \tn % Row Count 22 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Hash the contents of a file with a key, using a specified algorithm and an encoding format\{\{bl=2\}\}} \tn % Row Count 25 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{CyberArk}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get password from CyberArk}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves a password for a specific application from CyberArk\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Google cognitive - Natural language}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Analyze sentiment}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Natural Language service named 'Analyze Sentiment'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Analyze entities}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Natural Language service named 'Analyze Entities'\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Analyze syntax}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Natural Language service named 'Analyze Syntax'\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Google cognitive - Vision}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Label detection}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Label Detection'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Landmark detection}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Landmark Detection'\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Text Detection}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Text Detection'\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Logo detection}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Logo Detection'\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Image properties detection}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Image Properties Detection'\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Safe search detection}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Google Cloud Vision service named 'Safe Search Detection'\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update file}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates the contents of the file specified by the file identifier.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete file}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes the file specified by the file identifier.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content using path}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets file contents using the file path.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.\{\{bl=2\}\}} \tn % Row Count 13 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create file}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Uploads a file to a SharePoint site. Make sure to pick an existing library.\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List folder}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns files contained in a SharePoint folder.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get all lists and libraries}}} \tn % Row Count 20 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get all lists and libraries.\{\{bl=2\}\}} \tn % Row Count 21 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata}}} \tn % Row Count 22 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets information about the file such as size, etag, created date, etc. Uses a file identifier to pick the file. Use Get file properties action to get to the values stored in the columns in the library.\{\{bl=2\}\}} \tn % Row Count 27 (+ 5) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata using path}}} \tn % Row Count 28 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets information about the file such as size, etag, created date, etc. Uses a file path to pick the file. Use "Get file properties" action to get to the values stored in the columns in the library.\{\{bl=2\}\}} \tn % Row Count 33 (+ 5) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$ (cont)}} \tn % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get folder metadata}}} \tn % Row Count 1 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets information about the folder. Uses a file identifier to pick the folder.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get folder metadata using path}}} \tn % Row Count 4 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets information about the folder. Uses a folder path to pick the folder.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List root folder}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns files in the root SharePoint folder.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract folder}}} \tn % Row Count 10 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extracts an archive file into a SharePoint folder (example: zip).\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get lists}}} \tn % Row Count 13 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets SharePoint lists from a site.\{\{bl=2\}\}} \tn % Row Count 14 (+ 1) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create sharing link for a file or folder}}} \tn % Row Count 15 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create sharing link for a file or folder.\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file}}} \tn % Row Count 18 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Copies a file. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new file after copy.\{\{bl=2\}\}} \tn % Row Count 22 (+ 4) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move file}}} \tn % Row Count 23 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves a file. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new file after move.\{\{bl=2\}\}} \tn % Row Count 27 (+ 4) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy folder}}} \tn % Row Count 28 (+ 1) % Row 35 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Copies a folder. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new folder after copy.\{\{bl=2\}\}} \tn % Row Count 32 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$ (cont)}} \tn % Row 36 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move folder}}} \tn % Row Count 1 (+ 1) % Row 37 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves a folder. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new folder after move.\{\{bl=2\}\}} \tn % Row Count 5 (+ 4) % Row 38 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Check out file}}} \tn % Row Count 6 (+ 1) % Row 39 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Check out a file in a document library to prevent others from editing the document, and your changes from being visible until the documented is checked in.\{\{bl=2\}\}} \tn % Row Count 10 (+ 4) % Row 40 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Discard check out}}} \tn % Row Count 11 (+ 1) % Row 41 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}If you check out a file and don't make changes to it, or you make changes that you don't want to keep you can simply discard the checkout, rather than saving the file. If your organization tracks versions, a new version is created each time you check a file back into the library. By discarding the checkout, you can avoid making new versions when you haven't made any changes to the file.\{\{bl=2\}\}} \tn % Row Count 20 (+ 9) % Row 42 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Check in file}}} \tn % Row Count 21 (+ 1) % Row 43 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Check in a checked out file in a document library, which makes the version of the document available to others.\{\{bl=2\}\}} \tn % Row Count 24 (+ 3) % Row 44 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get list views}}} \tn % Row Count 25 (+ 1) % Row 45 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets views from a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 26 (+ 1) % Row 46 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add attachment}}} \tn % Row Count 27 (+ 1) % Row 47 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Adds a new attachment to the specified list item\{\{bl=2\}\}} \tn % Row Count 29 (+ 2) % Row 48 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set content approval status}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$ (cont)}} \tn % Row 49 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the content approval status for an item in a list or library that has content approval turned on. You must provide an ETag for pages and files. You can get the ETag using the Get File Metadata action. This action is only available for SharePoint Online and SharePoint 2019.\{\{bl=2\}\}} \tn % Row Count 6 (+ 6) % Row 50 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Stop sharing an item or a file}}} \tn % Row Count 7 (+ 1) % Row 51 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete all links giving access to an item or a file and remove all people with direct access except for owners.\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) % Row 52 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update file properties}}} \tn % Row Count 11 (+ 1) % Row 53 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates the properties stored in columns in a library for the item specified by the item id. Use "Update file" action to update file contents. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.\{\{bl=2\}\}} \tn % Row Count 17 (+ 6) % Row 54 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update file properties using AI Builder model results}}} \tn % Row Count 19 (+ 2) % Row 55 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates the values stored in library columns for a file analyzed by the model specified by the ModelId.\{\{bl=2\}\}} \tn % Row Count 22 (+ 3) % Row 56 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file properties}}} \tn % Row Count 23 (+ 1) % Row 57 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the properties saved in the columns in the library for the item specified by the item id. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.\{\{bl=2\}\}} \tn % Row Count 31 (+ 8) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$ (cont)}} \tn % Row 58 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get files (properties only)}}} \tn % Row Count 1 (+ 1) % Row 59 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the properties saved in the columns in the library for all folders and files stored in the library. You can also filter down to the items that match a condition. An "Apply to each" section is usually used to work with the output from this action. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.\{\{bl=2\}\}} \tn % Row Count 9 (+ 8) % Row 60 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create item}}} \tn % Row Count 10 (+ 1) % Row 61 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a new item in a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 62 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create new folder}}} \tn % Row Count 13 (+ 1) % Row 63 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a new folder or folder path.\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 64 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete attachment}}} \tn % Row Count 16 (+ 1) % Row 65 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes the specified attachment.\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) % Row 66 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete item}}} \tn % Row Count 18 (+ 1) % Row 67 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes an item from a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 68 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Generate document using Microsoft Syntex (preview)}}} \tn % Row Count 22 (+ 2) % Row 69 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Use this action to create documents based on modern templates from Microsoft Syntex. This preview requires a Syntex license. Pricing is subject to change. For more info see: \seqsplit{https://docs.microsoft.com/en-us/microsoft-365/contentunderstanding/content-assembly}.\{\{bl=2\}\}} \tn % Row Count 28 (+ 6) % Row 70 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get attachment content}}} \tn % Row Count 29 (+ 1) % Row 71 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.\{\{bl=2\}\}} \tn % Row Count 32 (+ 3) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{SharePoint $\diamondsuit{}$ (cont)}} \tn % Row 72 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get attachments}}} \tn % Row Count 1 (+ 1) % Row 73 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns the list of attachments for the specified list item. You can add a "Get attachment content" step and use the "File identifier" property returned by this action to get to the contents of the file.\{\{bl=2\}\}} \tn % Row Count 6 (+ 5) % Row 74 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get changes for an item or a file (properties only)}}} \tn % Row Count 8 (+ 2) % Row 75 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns information about columns that have changed within a given time window. Note: The list must have Versioning turned on.\{\{bl=2\}\}} \tn % Row Count 11 (+ 3) % Row 76 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update item}}} \tn % Row Count 12 (+ 1) % Row 77 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates an item in a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 78 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get item}}} \tn % Row Count 15 (+ 1) % Row 79 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets a single item by its id from a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 80 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get items}}} \tn % Row Count 18 (+ 1) % Row 81 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets items from a SharePoint list.\{\{bl=2\}\}} \tn % Row Count 19 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Logging $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Log Message}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Adds a custom text message to the flow run action details\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneNote (Business) (Preview) $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a page in Quick Notes (Preview)}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new page in the Quick Notes section.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create page in a section (Preview)}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create new page in a specified section.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create section in a notebook (Preview)}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create section in a notebook.\{\{bl=2\}\}} \tn % Row Count 8 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete a page (Preview)}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete a page.\{\{bl=2\}\}} \tn % Row Count 10 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get page content (Preview)}}} \tn % Row Count 11 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get HTML page content.\{\{bl=2\}\}} \tn % Row Count 12 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get pages for a specific section (Preview)}}} \tn % Row Count 13 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get pages for a specific section.\{\{bl=2\}\}} \tn % Row Count 14 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get recent notebooks (Preview)}}} \tn % Row Count 15 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get recent notebooks.\{\{bl=2\}\}} \tn % Row Count 16 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get sections in notebook (Preview)}}} \tn % Row Count 17 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get sections in a specific notebook.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update page content (Preview)}}} \tn % Row Count 20 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Update HTML page content.\{\{bl=2\}\}} \tn % Row Count 21 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Word Online (Business) $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert Word Document to PDF}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets a PDF version of the selected file\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Populate a Microsoft Word template}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Reads a Microsoft Word template to then fill the template fields with selected dynamic values to generate a Word Document.\{\{bl=2\}\}} \tn % Row Count 7 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Variables - Data table}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create new data table}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Creates a new data table variable\{\{bl=1\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Insert row into data table}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Inserts a row at the end or before a specific index value\{\{bl=1\}\}} \tn % Row Count 5 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find or replace in data table}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Finds and/or replaces data table values\{\{bl=1\}\}} \tn % Row Count 8 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update data table item}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Update a data table row item on a defined column\{\{bl=1\}\}} \tn % Row Count 11 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete row from data table}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Delete a data table row item\{\{bl=1\}\}} \tn % Row Count 13 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Conditionals}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Case}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}An expression that, if met, a block of actions associated with that particular case runs\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Default case}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}A block of actions that is run, if no case expression has been met in the switch body\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Else}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a block of actions that ran if the condition specified in the preceding 'If' statements aren't met\{\{bl=2\}\}} \tn % Row Count 12 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Else if}}} \tn % Row Count 13 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a block of actions that ran if the conditions specified in the preceding 'If' statements aren't met, but the condition specified in this statement is met\{\{bl=2\}\}} \tn % Row Count 17 (+ 4) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If}}} \tn % Row Count 18 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a block of actions that is run if the condition specified in this statement is met\{\{bl=2\}\}} \tn % Row Count 21 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Switch}}} \tn % Row Count 22 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Dispatches execution to different parts of the switch body based on the value of the expression\{\{bl=2\}\}} \tn % Row Count 25 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Loops}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Exit loop}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Terminates the loop and the flow resumes at the next action or statement following the loop\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{For each}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Iterates over items in a list, data table or data row, allowing a block of actions to be executed repeatedly\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Loop}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Iterates a block of actions for a specified number of times\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Loop condition}}} \tn % Row Count 12 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Iterates a block of actions as long as a specified condition proves to be true\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Next loop}}} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Forces the next iteration of the block to take place, skipping any actions in between\{\{bl=2\}\}} \tn % Row Count 18 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Folder}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If folder exists}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Mark the beginning of a conditional block of actions depending on whether a folder exists or not\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get files in folder}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve the list of files in a folder\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get subfolders in folder}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve the list of subfolders in a folder\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create folder}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new folder\{\{bl=2\}\}} \tn % Row Count 12 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete folder}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete an existing folder and its contents (files and subfolders)\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Empty folder}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete all the contents of a folder (files and subfolders) without deleting the folder itself\{\{bl=2\}\}} \tn % Row Count 19 (+ 3) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy folder}}} \tn % Row Count 20 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Copy a folder into a destination folder\{\{bl=2\}\}} \tn % Row Count 22 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move folder}}} \tn % Row Count 23 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Move an existing folder into a destination folder\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Rename folder}}} \tn % Row Count 26 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Change the name of a folder\{\{bl=2\}\}} \tn % Row Count 27 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get special folder}}} \tn % Row Count 28 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve the path of a Windows' special folder (such as Desktop, My Pictures, Internet Cache etc)\{\{bl=2\}\}} \tn % Row Count 31 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Compression}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{ZIP files}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Compress one or more files or folders into a ZIP archive\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Unzip files}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Uncompress one or more files or folders contained in a ZIP archive\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Workstation}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Print document}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Prints a document on the default printer\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get default printer}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the name of the default printer\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set default printer}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets a printer as the default printer\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Log off user}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Logs off the current user\{\{bl=2\}\}} \tn % Row Count 11 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Shutdown computer}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Instructs the computer to shut down\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Show desktop}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Shows the desktop\{\{bl=2\}\}} \tn % Row Count 16 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Lock workstation}}} \tn % Row Count 17 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Locks the workstation's display to protect it from unauthorized use\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Play sound}}} \tn % Row Count 20 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Plays a system sound or a wav file\{\{bl=2\}\}} \tn % Row Count 21 (+ 1) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Empty recycle bin}}} \tn % Row Count 22 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes all files from the windows recycle bin\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Take screenshot}}} \tn % Row Count 25 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Takes a screenshot of the foreground window or the specified screen and saves the image in a file or to the clipboard\{\{bl=2\}\}} \tn % Row Count 28 (+ 3) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Control screen saver}}} \tn % Row Count 29 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Enables, disables, starts or stops the screensaver\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Workstation (cont)}} \tn % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get screen resolution}}} \tn % Row Count 1 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the width, height, bit count and frequency of a selected monitor\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set screen resolution}}} \tn % Row Count 4 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets the width, height, bit count and frequency of a selected monitor during an attended desktop flow run.\{\{bl=2\}\}} \tn % Row Count 7 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{System}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If process}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a conditional block of actions depending on whether a process is running or not\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for process}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspends the execution until a process starts or stops\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run application}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes an application or opens a document by executing the associated application\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Terminate process}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Immediately stops a running process\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Ping}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sends a message to determine whether a remote computer is accessible over the network\{\{bl=2\}\}} \tn % Row Count 17 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set Windows environment variable}}} \tn % Row Count 18 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Sets an environment variable to a given value\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get Windows environment variable}}} \tn % Row Count 21 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the value of an environment variable\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete Windows environment variable}}} \tn % Row Count 24 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes an environment variable from a given scope\{\{bl=2\}\}} \tn % Row Count 26 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{PDF}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract text from PDF}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract text from a PDF file\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract tables from PDF}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract tables from a PDF file\{\{bl=2\}\}} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract images from PDF}}} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract images from a PDF file\{\{bl=2\}\}} \tn % Row Count 6 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract PDF file pages to new PDF file}}} \tn % Row Count 7 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract pages from a PDF file to a new PDF file\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Merge PDF files}}} \tn % Row Count 10 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Merges multiple PDF files into a new one\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OCR}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If text on screen (OCR)}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a conditional block of actions depending on whether a given text appears on the screen or not, using OCR\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for text on screen (OCR)}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Wait until a specific text appears/disappears on the screen, on the foreground window, or relative to an image on the screen or foreground window using OCR\{\{bl=2\}\}} \tn % Row Count 9 (+ 4) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract text with OCR}}} \tn % Row Count 10 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract text from a given source using the given OCR engine\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Text}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Append line to text}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Appends a new line of text to a text value\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get subtext}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve a subtext from a text value\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Crop text}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves a text value that occurs before, after or between the specified text flag(s) in a given text\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Pad text}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a fixed length text by adding characters to the left or to the right of an existing text\{\{bl=2\}\}} \tn % Row Count 14 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Trim text}}} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Removes all occurrences of white space characters (such as space, tab, or new line) from the beginning and/or end of an existing text\{\{bl=2\}\}} \tn % Row Count 18 (+ 3) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reverse text}}} \tn % Row Count 19 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Reverses the order of letters in a text string\{\{bl=2\}\}} \tn % Row Count 21 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Change text case}}} \tn % Row Count 22 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Changes the casing of a text to uppercase, lowercase, title case or sentence case\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert text to number}}} \tn % Row Count 25 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Converts a text representation of a number to a variable that contains a numeric value\{\{bl=2\}\}} \tn % Row Count 28 (+ 3) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert number to text}}} \tn % Row Count 29 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Converts a number to text using a specified format\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Text (cont)}} \tn % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert text to datetime}}} \tn % Row Count 1 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Converts a text representation of a date and/or time value to a datetime value\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert datetime to text}}} \tn % Row Count 4 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Converts a datetime value to text using a specified custom format\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create random text}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Generates a text of specified length consisting of random characters. This can be useful for generating passwords\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Join text}}} \tn % Row Count 11 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Converts a list into a text value by separating its items with a specified delimiter\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Split text}}} \tn % Row Count 14 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a list containing the substrings of a text that are separated by a specified delimiter or a regular expression\{\{bl=2\}\}} \tn % Row Count 17 (+ 3) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Parse text}}} \tn % Row Count 18 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Parses a text to find the first or all occurrences of a specified subtext or a regular expression pattern\{\{bl=2\}\}} \tn % Row Count 21 (+ 3) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Replace text}}} \tn % Row Count 22 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Replaces all occurrences of a specified subtext with another text. It can also be used with regular expressions\{\{bl=2\}\}} \tn % Row Count 25 (+ 3) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Escape text for regular expression}}} \tn % Row Count 26 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Escapes a minimal set of characters (, *, +, ?, |, \{, {[}, (,), \textasciicircum{}, \$,., \#, and white space) by replacing them with their escape codes\{\{bl=2\}\}} \tn % Row Count 29 (+ 3) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Recognize entities in text}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Text (cont)}} \tn % Row 35 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Recognizes entities in text, such as numbers, units, data/time and others expressed in natural language across multiple languages\{\{bl=2\}\}} \tn % Row Count 3 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{XML}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Read XML from file}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Read the contents of an XML file into a variable\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Write XML to file}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Write the contents of an XML node variable into a file\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Execute XPath expression}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Extract values from an XML document based on the provided XPath query\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get XML element attribute}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the value of an attribute of an XML element\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set XML element attribute}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set the value of an attribute of an XML element\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Remove XML element attribute}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Remove an attribute from an XML element\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get XML element value}}} \tn % Row Count 19 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the value of an XML element\{\{bl=2\}\}} \tn % Row Count 20 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set XML element value}}} \tn % Row Count 21 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set the value of an XML element\{\{bl=2\}\}} \tn % Row Count 22 (+ 1) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Insert XML element}}} \tn % Row Count 23 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Insert a new XML element into an XML document\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Remove XML element}}} \tn % Row Count 26 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Remove one or more XML elements from an XML document\{\{bl=2\}\}} \tn % Row Count 28 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Database}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Open SQL connection}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Open a new connection to a database\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Execute SQL statement}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Connect to a database and execute a SQL statement\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close SQL connection}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Close an open connection to a database\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{CMD session}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Open CMD session}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Open a new CMD session\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Read from CMD session}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Read the output of a CMD session\{\{bl=2\}\}} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Write to CMD session}}} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Execute a command on an open CMD session\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for text on CMD session}}} \tn % Row Count 8 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Wait for a specific text on a previously opened CMD session\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close CMD session}}} \tn % Row Count 11 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Close a previously opened CMD session\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Windows services}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If service}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a conditional block of actions depending on whether a service is running, paused, stopped or installed on the computer\{\{bl=2\}\}} \tn % Row Count 5 (+ 4) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for service}}} \tn % Row Count 6 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspend the execution of the automation until a service is running, paused or stopped on the computer\{\{bl=2\}\}} \tn % Row Count 9 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Start service}}} \tn % Row Count 10 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Start a stopped Windows service\{\{bl=2\}\}} \tn % Row Count 11 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Stop service}}} \tn % Row Count 12 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Stop a running Windows service\{\{bl=2\}\}} \tn % Row Count 13 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Pause service}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Pause a running Windows service\{\{bl=2\}\}} \tn % Row Count 15 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Resume service}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Resume a paused Windows service\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Azure - Virtual machines - Snapshots}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get snapshots}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the snapshots based on the specified criteria\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create snapshot}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a snapshot from the specified disk\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete snapshot}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes the snapshot with the specified name and resource group\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Azure - Virtual machines - Disks}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get disks}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the disks based on the specified criteria\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Attach disk}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Attaches an existing disk to the virtual machine with the specified name and resource group\{\{bl=2\}\}} \tn % Row Count 7 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Detach disk}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Detaches the disk from the virtual machine with the specified name and resource group\{\{bl=2\}\}} \tn % Row Count 11 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create managed disk}}} \tn % Row Count 12 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a managed disk with the specified settings\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete disk}}} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes the managed disk with the specified name and resource group\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Active Directory}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Connect to server}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Connects to an Active Directory server\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close connection}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Closes the connection with the Active Directory server\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Active Directory - Group}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create group}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a group in the Active Directory\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get group info}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets information about a group from the Active Directory server\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get group members}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the members of a group in the Active Directory\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Modify group}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Modifies a group in the Active Directory\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Active Directory - Object}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create object}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates an object in the Active Directory\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete object}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes an object in the Active Directory\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move object}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves an object in the Active Directory\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Rename object}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Renames an object in the Active Directory\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft cognitive - Bing spell check}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Spell check}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Bing Spell Check'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft cognitive - Computer vision}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Analyze image}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Analyze Image'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Describe image}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Describe Image'\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{OCR}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'OCR'\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Tag image}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Tag Image'\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft cognitive - Text Analytics}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Detect language}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Text Analytics - Detect Language'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Key phrases}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Text Analytics - Key Phrases'\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Sentiment}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the Microsoft Cognitive service named 'Text Analytics - Sentiment'\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Clipboard}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get clipboard text}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Gets clipboard text.\{\{bl=1\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set clipboard Text}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Sets clipboard text.\{\{bl=1\}\}} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Clear clipboard contents}}} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=1\}\}Clears clipboard contents.\{\{bl=1\}\}} \tn % Row Count 6 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{AI Builder $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create text with GPT}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get a response generated by GPT.\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Office 365 Outlook (Preview) $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create contact (V2)}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a new contact in a contacts folder.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create event (V4)}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a new event in a calendar.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete contact (V2)}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes a contact from a contacts folder.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete email (V2)}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes an email by id.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete event (V2)}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes an event in a calendar.\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Export email (V2)}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Export the content of the email in the EML file format.\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find meeting times (V2)}}} \tn % Row Count 19 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Find meeting time suggestions based on organizer, attendee availability, and time or location constraints\{\{bl=2\}\}} \tn % Row Count 22 (+ 3) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Flag email (V2)}}} \tn % Row Count 23 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates an email flag.\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Forward an email (V2)}}} \tn % Row Count 26 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Forward an email.\{\{bl=2\}\}} \tn % Row Count 27 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get Attachment (V2)}}} \tn % Row Count 28 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets an email attachment by id.\{\{bl=2\}\}} \tn % Row Count 30 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Office 365 Outlook (Preview) $\diamondsuit{}$ (cont)}} \tn % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get calendar view of events (V3)}}} \tn % Row Count 1 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets all events (including instances of recurrences) in a calendar using Graph API. Recurrence property is null in this case.\{\{bl=2\}\}} \tn % Row Count 5 (+ 4) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get calendars (V2)}}} \tn % Row Count 6 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation lists available calendars.\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get contact (V2)}}} \tn % Row Count 9 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets a specific contact from a contacts folder.\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get contacts (V2)}}} \tn % Row Count 12 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets contacts from a contacts folder.\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get email (V2)}}} \tn % Row Count 15 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets an email by id.\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get emails (V3)}}} \tn % Row Count 18 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets emails from a folder via graph apis. Please note that filtering related to these fields: To, Cc, To Or Cc, From, Importance, Fetch Only With Attachments, Subject Filter, is performed using first 250 items in a given mail folder. To avoid that limitation you can use 'Search Query' field.\{\{bl=2\}\}} \tn % Row Count 25 (+ 7) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get event (V3)}}} \tn % Row Count 26 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets a specific event from a calendar using Graph API. (V3)\{\{bl=2\}\}} \tn % Row Count 28 (+ 2) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get events (V4)}}} \tn % Row Count 29 (+ 1) % Row 35 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets events from a calendar using Graph API. (V4)\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Office 365 Outlook (Preview) $\diamondsuit{}$ (cont)}} \tn % Row 36 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get room lists (V2)}}} \tn % Row Count 1 (+ 1) % Row 37 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get all the room lists defined in the user's tenant\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 38 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get rooms (V2)}}} \tn % Row Count 4 (+ 1) % Row 39 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get all the meeting rooms defined in the user's tenant\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 40 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get rooms in room list (V2)}}} \tn % Row Count 7 (+ 1) % Row 41 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the meeting rooms in a specific room list\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 42 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Mark as read or unread (V3)}}} \tn % Row Count 10 (+ 1) % Row 43 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation marks an email as read/unread.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 44 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move email (V2)}}} \tn % Row Count 13 (+ 1) % Row 45 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation moves an email to the specified folder within the same mailbox.\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 46 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reply to email (V3)}}} \tn % Row Count 16 (+ 1) % Row 47 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation replies to an email.\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 48 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Respond to an event invite (V2)}}} \tn % Row Count 19 (+ 1) % Row 49 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Respond to an event invite.\{\{bl=2\}\}} \tn % Row Count 20 (+ 1) % Row 50 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send an email (V2)}}} \tn % Row Count 21 (+ 1) % Row 51 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation sends an email message.\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 52 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send an email from a shared mailbox (V2)}}} \tn % Row Count 24 (+ 1) % Row 53 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation sends an email from a shared mailbox. Your account should have permission to access the mailbox for this operation to succeed.\{\{bl=2\}\}} \tn % Row Count 28 (+ 4) % Row 54 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set up automatic replies (V2)}}} \tn % Row Count 29 (+ 1) % Row 55 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set the automatic replies setting for your mailbox.\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Office 365 Outlook (Preview) $\diamondsuit{}$ (cont)}} \tn % Row 56 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update contact (V2)}}} \tn % Row Count 1 (+ 1) % Row 57 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates a contact in a contacts folder.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 58 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update event (V4)}}} \tn % Row Count 4 (+ 1) % Row 59 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates an event in a calendar using Graph API.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft Forms $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get response details}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action retrieves a form response\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft Teams $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add a member to a tag}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation adds a user to a tags.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add a member to a team}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation adds a member to a team.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a channel}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation is used to create a new channel for a specific Team.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a chat}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a one on one or group chat\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a tag for a team}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a tag.\{\{bl=2\}\}} \tn % Row Count 14 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a team}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation a creates a new team.\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create a Teams meeting}}} \tn % Row Count 18 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a meeting with a link at the bottom of the invite to join the meeting online on Teams\{\{bl=2\}\}} \tn % Row Count 21 (+ 3) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete a member from a tag}}} \tn % Row Count 22 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes a member from a tag.\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete a tag}}} \tn % Row Count 25 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes a tag.\{\{bl=2\}\}} \tn % Row Count 26 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get a team}}} \tn % Row Count 27 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation returns details for a team using the team's unique ID.\{\{bl=2\}\}} \tn % Row Count 29 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get an @mention token for a tag}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft Teams $\diamondsuit{}$ (cont)}} \tn % Row 21 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a token that can be inserted into a message or adaptive card sent as a user in a channel to @mention a tag.\{\{bl=2\}\}} \tn % Row Count 3 (+ 3) % Row 22 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get an @mention token for a user}}} \tn % Row Count 4 (+ 1) % Row 23 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a token that can be inserted into a message or adaptive card to @mention a user.\{\{bl=2\}\}} \tn % Row Count 7 (+ 3) % Row 24 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get message details}}} \tn % Row Count 8 (+ 1) % Row 25 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets details of a message in a chat or a channel.\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 26 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get messages}}} \tn % Row Count 11 (+ 1) % Row 27 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation is used to get messages from a channel in a specific Team.\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 28 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List all tags for a team}}} \tn % Row Count 14 (+ 1) % Row 29 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation retrieves a list of tags.\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 30 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List channels}}} \tn % Row Count 17 (+ 1) % Row 31 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation retrieves a list of all the channels for a specific Team.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 32 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List chats}}} \tn % Row Count 20 (+ 1) % Row 33 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation retrieves a list of recent chats.\{\{bl=2\}\}} \tn % Row Count 22 (+ 2) % Row 34 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List members}}} \tn % Row Count 23 (+ 1) % Row 35 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation list members based on a threadtype (chat, channel, etc).\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 36 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List teams}}} \tn % Row Count 26 (+ 1) % Row 37 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation retrieves a list of all the Teams (Office 365 Groups) you are a member of.\{\{bl=2\}\}} \tn % Row Count 29 (+ 3) % Row 38 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List the members for a tag}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Microsoft Teams $\diamondsuit{}$ (cont)}} \tn % Row 39 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation lists the members for a tag.\{\{bl=2\}\}} \tn % Row Count 2 (+ 2) % Row 40 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Post a feed notification}}} \tn % Row Count 3 (+ 1) % Row 41 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation posts a feed notification.\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 42 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Post card in a chat or channel}}} \tn % Row Count 6 (+ 1) % Row 43 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation posts a card to a chat or a channel.\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 44 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Post message in a chat or channel}}} \tn % Row Count 9 (+ 1) % Row 45 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation posts a message to a chat or a channel.\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 46 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reply with a message in a channel}}} \tn % Row Count 12 (+ 1) % Row 47 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation replies with a message in a channel.\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 48 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reply with adaptive card in a channel}}} \tn % Row Count 15 (+ 1) % Row 49 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation replies with an adaptive card to a channel.\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 50 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update an adaptive card in a chat or channel}}} \tn % Row Count 18 (+ 1) % Row 51 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates an existing adaptive card.\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{RSS $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List all RSS feed items}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation retrieves all items from an RSS feed.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Flow control}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Comment}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}User comment\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{End}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set rules and manage the course of the flow\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Exit subflow}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Exits current subflow and returns to the point it was called from\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get last error}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the last error that occurred in the flow\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Go to}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Transfers the flow of execution to another point, indicated by a label\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Label}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Acts as the destination of a 'go to' statement\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{On block error}}} \tn % Row Count 18 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a block to handle actions errors\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run subflow}}} \tn % Row Count 21 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Run a subflow specifying any required arguments\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Stop flow}}} \tn % Row Count 24 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Terminates the flow\{\{bl=2\}\}} \tn % Row Count 25 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait}}} \tn % Row Count 26 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspends the execution of the flow for a specified amount of seconds\{\{bl=2\}\}} \tn % Row Count 28 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Run flow}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run desktop flow}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Runs a desktop flow which can receive input variables and may produce output variables. The parent flow run will be paused until the called desktop flow completes.\{\{bl=2\}\}} \tn % Row Count 5 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{File}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{If file exists}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Marks the beginning of a conditional block of actions depending on whether a file exists or not\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for file}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Suspend the execution of the automation until a file is created or deleted\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file(s)}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Copy one or more files into a destination folder\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move file(s)}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Move one or more files into a destination folder\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete file(s)}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete one or more files\{\{bl=2\}\}} \tn % Row Count 15 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Rename file(s)}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Change the name of one or more files\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Read text from file}}} \tn % Row Count 19 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Read the contents of a text file\{\{bl=2\}\}} \tn % Row Count 20 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Write text to file}}} \tn % Row Count 21 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Write or appends text to a file\{\{bl=2\}\}} \tn % Row Count 22 (+ 1) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Read from CSV file}}} \tn % Row Count 23 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Read a CSV file into a data table\{\{bl=2\}\}} \tn % Row Count 24 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Write to CSV file}}} \tn % Row Count 25 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Write a data table, data row or list to a CSV file\{\{bl=2\}\}} \tn % Row Count 27 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file path part}}} \tn % Row Count 28 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve one or more parts (directory, filename, extension etc) from a text that represents a file path\{\{bl=2\}\}} \tn % Row Count 31 (+ 3) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{File (cont)}} \tn % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get temporary file}}} \tn % Row Count 1 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a uniquely named, empty temporary file on disk, and get the file object (which is a representation, and can access the file and all its information)\{\{bl=2\}\}} \tn % Row Count 5 (+ 4) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert file to Base64}}} \tn % Row Count 6 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert a file to Base64 encoded text\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert Base64 to file}}} \tn % Row Count 9 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert a Base64 encoded text to file\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert file to binary data}}} \tn % Row Count 12 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert a file to binary data.\{\{bl=2\}\}} \tn % Row Count 13 (+ 1) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert binary data to file}}} \tn % Row Count 14 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Convert binary data to file.\{\{bl=2\}\}} \tn % Row Count 15 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Email}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Retrieve email messages}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves email messages from an IMAP server\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Process email messages}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Moves, deletes or marks as unread an email (or a list of emails) retrieved by a Retrieve emails action\{\{bl=2\}\}} \tn % Row Count 7 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send email}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates and sends a new email message\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Exchange}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Connect to Exchange server}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Open a new connection to an Exchange server\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Retrieve Exchange email messages}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve email messages from the specified Exchange server\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send Exchange email message}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create and send a new email message\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Process Exchange email messages}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Move, delete or mark as unread an email message (or a list of email messages)\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Outlook}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch Outlook}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launch Outlook and create a new Outlook instance\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Retrieve email messages from Outlook}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve email messages from an Outlook account\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send email through Outlook}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create and send a new email message through Outlook\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Process email messages in Outlook}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Move or deletes an email (or a list of email messages) retrieved by a 'Retrieve emails from Outlook' action.\{\{bl=2\}\}} \tn % Row Count 13 (+ 3) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Save Outlook email messages}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Save Outlook email messages given an account\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Respond to Outlook mail message}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Respond to an Outlook message, by replying, replying to all or forwarding it\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close Outlook}}} \tn % Row Count 20 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Close a previously launched Outlook instance\{\{bl=2\}\}} \tn % Row Count 22 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel - Advanced}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Resize columns/rows in Excel worksheet}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Resizes a selection of columns or rows in the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run Excel Macro}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Runs a specified macro on the document of an Excel instance\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get active Excel worksheet}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves an Excel document's active worksheet\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get all Excel worksheets}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves all worksheet names of an Excel document\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete Excel worksheet}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes a specific worksheet from an Excel instance\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Rename Excel worksheet}}} \tn % Row Count 16 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Renames a specific worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Activate Cell in Excel Worksheet}}} \tn % Row Count 19 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Activate a cell in the active worksheet of an Excel instance, by providing column, row and offset\{\{bl=2\}\}} \tn % Row Count 22 (+ 3) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Select cells in Excel worksheet}}} \tn % Row Count 23 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Selects a range of cells in the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get selected cell range from Excel worksheet}}} \tn % Row Count 26 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve the selected range of cells in a structure consisting of first column, first row, last column and last row\{\{bl=2\}\}} \tn % Row Count 29 (+ 3) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy cells from Excel worksheet}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel - Advanced (cont)}} \tn % Row 19 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Copies a range of cells from the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 2 (+ 2) % Row 20 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Paste cells to Excel worksheet}}} \tn % Row Count 3 (+ 1) % Row 21 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Pastes a range of cells to the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 22 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete from Excel worksheet}}} \tn % Row Count 6 (+ 1) % Row 23 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes a cell or a range of cells from the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 24 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Insert row to Excel worksheet}}} \tn % Row Count 9 (+ 1) % Row 25 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Inserts a row above a selected row of an Excel instance\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 26 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete row from Excel worksheet}}} \tn % Row Count 12 (+ 1) % Row 27 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes a selected row from an Excel instance\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 28 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Insert column to Excel worksheet}}} \tn % Row Count 15 (+ 1) % Row 29 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Inserts a column to the left of a selected column of an Excel instance\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 30 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete column from Excel worksheet}}} \tn % Row Count 18 (+ 1) % Row 31 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes a selected column from an Excel instance\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 32 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find and replace cells in Excel worksheet}}} \tn % Row Count 21 (+ 1) % Row 33 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Finds text and replaces it with another in the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 34 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get first free row on column from Excel worksheet}}} \tn % Row Count 25 (+ 2) % Row 35 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieve the first free row, given the column of the active worksheet\{\{bl=2\}\}} \tn % Row Count 27 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Launch Excel}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Launches a new Excel instance or opens an Excel document\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Attach to running Excel}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Attaches to an Excel document that's already open\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Read from Excel worksheet}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Reads the value of a cell or a range of cells from the active worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 10 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get active cell on Excel worksheet}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get the active cell in the active worksheet of the Excel document\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Save Excel}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Saves a previously launched Excel instance\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Write to Excel worksheet}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Writes a value into a cell or a range of cells of an Excel instance\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close Excel}}} \tn % Row Count 20 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Closes an Excel instance\{\{bl=2\}\}} \tn % Row Count 21 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set active Excel worksheet}}} \tn % Row Count 22 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Activates a specific worksheet of an Excel instance\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add new worksheet}}} \tn % Row Count 25 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Adds a new worksheet to the document of an Excel instance\{\{bl=2\}\}} \tn % Row Count 27 (+ 2) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get first free column/row from Excel worksheet}}} \tn % Row Count 28 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the first free column and/or row of the active worksheet. This is useful for adding new data into a worksheet that already has data in it\{\{bl=2\}\}} \tn % Row Count 32 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel (cont)}} \tn % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get column name on Excel worksheet}}} \tn % Row Count 1 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets the name of the column\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Message boxes}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display message}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays a message box\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display input dialog}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays a dialog box that prompts the user to enter text\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display select date dialog}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays a dialog box that prompts the user to enter a date or date range\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display select from list dialog}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays a dialog box with options that lets the user select from a list\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display select file dialog}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays the select file dialog and prompts the user to select one or more files\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display select folder dialog}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Displays the select folder dialog and prompts the user to select a folder\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Display custom form}}} \tn % Row Count 18 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Display a customized form that can include multiple types of elements, like text, number or file inputs etc.\{\{bl=2\}\}} \tn % Row Count 21 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Datetime}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add to datetime}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Adds (or subtracts) a specific number of seconds, minutes, hours or days to a datetime value\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Subtract dates}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Finds the time difference between two given dates in days, hours, minutes, or seconds\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get current date and time}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Retrieves the current date or the current date and time\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Scripting}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run DOS command}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes a DOS command or console application in invisible mode and retrieves its output upon completion\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run VBScript}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes some custom VBScript code and retrieves its output into a variable\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run JavaScript}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes some custom JavaScript code and retrieves its output into a variable\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run PowerShell script}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes some custom PowerShell script and retrieves its output into a variable\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run Python script}}} \tn % Row Count 14 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes Python 2 script code and retrieves its output\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run .NET script}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Executes a user provided .NET script and stores its output in variables.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{FTP}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Open FTP connection}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action establishes a specific connection to a remote FTP server, and stores that connection as a variable for later use.\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List FTP directory}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action returns the subdirectories and files contained in the current directory of an FTP connection\{\{bl=2\}\}} \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Open secure FTP connection}}} \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action establishes a specific secure connection to a remote FTP server, and stores that connection as a variable for later use\{\{bl=2\}\}} \tn % Row Count 12 (+ 3) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close connection}}} \tn % Row Count 13 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action closes an open FTP connection\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Change working directory}}} \tn % Row Count 16 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This action sets the current working directory for an FTP connection\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Download file(s) from FTP}}} \tn % Row Count 19 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Downloads one or more files from an FTP server\{\{bl=2\}\}} \tn % Row Count 21 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Download folder(s) from FTP}}} \tn % Row Count 22 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Downloads one or more folders from an FTP server\{\{bl=2\}\}} \tn % Row Count 24 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Upload File(s) to FTP}}} \tn % Row Count 25 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Uploads one or more files to an FTP server\{\{bl=2\}\}} \tn % Row Count 27 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Upload folder(s) to FTP}}} \tn % Row Count 28 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Uploads one or more folders to an FTP server\{\{bl=2\}\}} \tn % Row Count 30 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{FTP (cont)}} \tn % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete FTP file}}} \tn % Row Count 1 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes one or more files from an FTP server\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Rename FTP File}}} \tn % Row Count 4 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Renames a file that resides on an FTP server\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create FTP directory}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a directory on an FTP server\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete FTP directory}}} \tn % Row Count 10 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Deletes a directory from an FTP server\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Invoke FTP command}}} \tn % Row Count 13 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the given literal FTP command on the server\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Synchronize directories}}} \tn % Row Count 16 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Synchronize the files and subdirectories of a given Folder with a given remote FTP directory\{\{bl=2\}\}} \tn % Row Count 19 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{AWS - EC2}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create EC2 session}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create an EC2 client to automate EC2 web services\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{End EC2 session}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Dispose an open EC2 client\{\{bl=2\}\}} \tn % Row Count 5 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{AWS - EC2 - Instances}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Start EC2 instance}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Start EC2 instance(s)\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Stop EC2 instance}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Stop EC2 instance(s)\{\{bl=2\}\}} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Reboot EC2 instance}}} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Reboot EC2 instance(s)\{\{bl=2\}\}} \tn % Row Count 6 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get available EC2 instances}}} \tn % Row Count 7 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get information for the relevant EC2 instances\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Describe instances}}} \tn % Row Count 10 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Returns all the information for the specified EC2 instance(s)\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{AWS - EC2 - Snapshots}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create snapshot}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a snapshot of an EBS volume and stores it in Amazon S3\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Describe snapshots}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Describes the specified EBS snapshots available\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete snapshot}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete the specified snapshot\{\{bl=2\}\}} \tn % Row Count 8 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{AWS - EC2 - Volumes}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create volume}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create an EBS volume\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Attach volume}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Attach an EBS volume to an EC2 instance\{\{bl=2\}\}} \tn % Row Count 5 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Detach volume}}} \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Detach an EBS volume from an EC2 instance\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Describe volumes}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Describe the specified EBS volumes\{\{bl=2\}\}} \tn % Row Count 10 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete volume}}} \tn % Row Count 11 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete the specified EBS volume\{\{bl=2\}\}} \tn % Row Count 12 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Active Directory - User}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create user}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Creates a user in the Active Directory\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get user info}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Gets a user's information in the Active Directory\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Modify user}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Modify a user in the Active Directory\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Unlock user}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Unlocks an Active Directory user\{\{bl=2\}\}} \tn % Row Count 11 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update user info}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates a user's information in the Active Directory\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Terminal emulation}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Open terminal session}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Open a new terminal session\{\{bl=2\}\}} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Close terminal session}}} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Close an open terminal session\{\{bl=2\}\}} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move cursor on terminal session}}} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Move the terminal's cursor on the specified position\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get text from terminal session}}} \tn % Row Count 8 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get text from a terminal session\{\{bl=2\}\}} \tn % Row Count 9 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Set text on terminal session}}} \tn % Row Count 10 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Set text on a terminal session\{\{bl=2\}\}} \tn % Row Count 11 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Send key to terminal session}}} \tn % Row Count 12 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Send a control key to a terminal session\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Wait for text on terminal session}}} \tn % Row Count 15 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Wait for a specific text to appear on a terminal session\{\{bl=2\}\}} \tn % Row Count 17 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{IBM cognitive - Document conversion}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert document}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the IBM service named 'Convert Document'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{IBM cognitive - Visual recognition}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Classify Image}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the IBM service named 'Classify Image'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{IBM cognitive - Language translator}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Translate}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the IBM service named 'Translate'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Identify language}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the IBM service named 'Identify Language'\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{IBM cognitive - Tone analyzer}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Analyze tone}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Invokes the IBM service named 'Analyze Tone'\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Work queues (Preview) $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Process work queue items (preview)}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Indicates to the orchestrator that the machine is ready to process one or more work queue items, if available\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update work queue item (preview)}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Updates the status and processing result of a specific work queue item\{\{bl=2\}\}} \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add work queue item (preview)}}} \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Add a work queue item into a work queue\{\{bl=2\}\}} \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Requeue item and add delay (preview)}}} \tn % Row Count 11 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Requeue a work queue item and delay it until a specified date and time\{\{bl=2\}\}} \tn % Row Count 13 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneDrive for Business $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation copies a file within OneDrive.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file using path}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation copies a file within OneDrive by path.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create file}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a file.\{\{bl=2\}\}} \tn % Row Count 8 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create share link}}} \tn % Row Count 9 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a share link for a file.\{\{bl=2\}\}} \tn % Row Count 11 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create share link by path}}} \tn % Row Count 12 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a share link for a file using the path.\{\{bl=2\}\}} \tn % Row Count 14 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete file}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes a file.\{\{bl=2\}\}} \tn % Row Count 16 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract archive to folder}}} \tn % Row Count 17 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.\{\{bl=2\}\}} \tn % Row Count 20 (+ 3) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find files in folder}}} \tn % Row Count 21 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation finds files within a folder using search or name pattern match.\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find files in folder by path}}} \tn % Row Count 24 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation finds files within a folder by path using search or name pattern match.\{\{bl=2\}\}} \tn % Row Count 27 (+ 3) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content}}} \tn % Row Count 28 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the content of a file.\{\{bl=2\}\}} \tn % Row Count 30 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneDrive for Business $\diamondsuit{}$ (cont)}} \tn % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content using path}}} \tn % Row Count 1 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the content of a file using the path.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata}}} \tn % Row Count 4 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the metadata for a file.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata using path}}} \tn % Row Count 7 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the metadata of a file using the path.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file thumbnail}}} \tn % Row Count 10 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.\{\{bl=2\}\}} \tn % Row Count 13 (+ 3) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List files in folder}}} \tn % Row Count 14 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the list of files and subfolders in a folder.\{\{bl=2\}\}} \tn % Row Count 16 (+ 2) % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List files in root folder}}} \tn % Row Count 17 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the list of files and subfolders in the root folder.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move or rename a file}}} \tn % Row Count 20 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation moves or renames a file.\{\{bl=2\}\}} \tn % Row Count 22 (+ 2) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move or rename a file using path}}} \tn % Row Count 23 (+ 1) % Row 35 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation moves or renames a file using the path.\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 36 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update file}}} \tn % Row Count 26 (+ 1) % Row 37 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates a file.\{\{bl=2\}\}} \tn % Row Count 27 (+ 1) % Row 38 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Upload file from URL}}} \tn % Row Count 28 (+ 1) % Row 39 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation uploads a file from a URL to OneDrive.\{\{bl=2\}\}} \tn % Row Count 30 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel Online (Business) $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add a key column to a table}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Add a key column to an Excel table. The new column will be appended to the right.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Add a row into a table}}} \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Add a new row into the Excel table.\{\{bl=2\}\}} \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create table}}} \tn % Row Count 7 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new table in the Excel workbook.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create worksheet}}} \tn % Row Count 10 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Create a new worksheet in the Excel workbook.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete a row}}} \tn % Row Count 13 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Delete a row using a key column.\{\{bl=2\}\}} \tn % Row Count 14 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get a row}}} \tn % Row Count 15 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get a row using a key column.\{\{bl=2\}\}} \tn % Row Count 16 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get tables}}} \tn % Row Count 17 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get a list of tables in the Excel workbook.\{\{bl=2\}\}} \tn % Row Count 19 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get worksheets}}} \tn % Row Count 20 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Get a list of worksheets in the Excel workbook.\{\{bl=2\}\}} \tn % Row Count 22 (+ 2) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{List rows present in a table}}} \tn % Row Count 23 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}List rows present in a table.\{\{bl=2\}\}} \tn % Row Count 24 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run script}}} \tn % Row Count 25 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Runs an Office Script against an Excel workbook. Use this action when the script is saved in the default location.\{\{bl=2\}\}} \tn % Row Count 28 (+ 3) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Run script from SharePoint library}}} \tn % Row Count 29 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Runs an Office Script against an Excel workbook. Use this action when the script is saved outside of the default location.\{\{bl=2\}\}} \tn % Row Count 32 (+ 3) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Excel Online (Business) $\diamondsuit{}$ (cont)}} \tn % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update a row}}} \tn % Row Count 1 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the "Get a row" action to retrieve the content first.\{\{bl=2\}\}} \tn % Row Count 7 (+ 6) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneDrive $\diamondsuit{}$}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert file}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation converts a file to another format. The list of supported conversions can be found at https://aka.ms/onedriveconversions\{\{bl=2\}\}} \tn % Row Count 4 (+ 3) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Convert file using path}}} \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation converts a file to another format using the path. The list of supported conversions can be found at https://aka.ms/onedriveconversions\{\{bl=2\}\}} \tn % Row Count 9 (+ 4) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file}}} \tn % Row Count 10 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation copies a file within OneDrive.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Copy file using path}}} \tn % Row Count 13 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation copies a file within OneDrive by path.\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create file}}} \tn % Row Count 16 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a file.\{\{bl=2\}\}} \tn % Row Count 17 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create share link}}} \tn % Row Count 18 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a share link for a file.\{\{bl=2\}\}} \tn % Row Count 20 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Create share link by path}}} \tn % Row Count 21 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation creates a share link for a file using the path.\{\{bl=2\}\}} \tn % Row Count 23 (+ 2) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Delete file}}} \tn % Row Count 24 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation deletes a file.\{\{bl=2\}\}} \tn % Row Count 25 (+ 1) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Extract archive to folder}}} \tn % Row Count 26 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation extracts an archive file into a folder (example: .zip). Maximum archive size is 50 MB and 100 files inside.\{\{bl=2\}\}} \tn % Row Count 29 (+ 3) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find files in folder}}} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneDrive $\diamondsuit{}$ (cont)}} \tn % Row 19 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation finds files within a folder using search or name pattern match.\{\{bl=2\}\}} \tn % Row Count 2 (+ 2) % Row 20 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Find files in folder by path}}} \tn % Row Count 3 (+ 1) % Row 21 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation finds files within a folder by path using search or name pattern match.\{\{bl=2\}\}} \tn % Row Count 6 (+ 3) % Row 22 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content}}} \tn % Row Count 7 (+ 1) % Row 23 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the content of a file.\{\{bl=2\}\}} \tn % Row Count 9 (+ 2) % Row 24 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file content using path}}} \tn % Row Count 10 (+ 1) % Row 25 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the content of a file using the path.\{\{bl=2\}\}} \tn % Row Count 12 (+ 2) % Row 26 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata}}} \tn % Row Count 13 (+ 1) % Row 27 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the metadata for a file.\{\{bl=2\}\}} \tn % Row Count 15 (+ 2) % Row 28 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file metadata using path}}} \tn % Row Count 16 (+ 1) % Row 29 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the metadata of a file using the path.\{\{bl=2\}\}} \tn % Row Count 18 (+ 2) % Row 30 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Get file thumbnail}}} \tn % Row Count 19 (+ 1) % Row 31 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the thumbnail of a file. The thumbnail will only be valid for 6 hours.\{\{bl=2\}\}} \tn % Row Count 22 (+ 3) % Row 32 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List files in folder}}} \tn % Row Count 23 (+ 1) % Row 33 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the list of files and subfolders in a folder.\{\{bl=2\}\}} \tn % Row Count 25 (+ 2) % Row 34 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{List files in root folder}}} \tn % Row Count 26 (+ 1) % Row 35 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation gets the list of files and subfolders in the root folder.\{\{bl=2\}\}} \tn % Row Count 28 (+ 2) % Row 36 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move or rename a file}}} \tn % Row Count 29 (+ 1) % Row 37 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation moves or renames a file.\{\{bl=2\}\}} \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{OneDrive $\diamondsuit{}$ (cont)}} \tn % Row 38 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Move or rename a file using path}}} \tn % Row Count 1 (+ 1) % Row 39 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation moves or renames a file using the path.\{\{bl=2\}\}} \tn % Row Count 3 (+ 2) % Row 40 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Update file}}} \tn % Row Count 4 (+ 1) % Row 41 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation updates a file.\{\{bl=2\}\}} \tn % Row Count 5 (+ 1) % Row 42 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{{\bf{Upload file from URL}}} \tn % Row Count 6 (+ 1) % Row 43 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{\{\{bl=2\}\}This operation uploads a file from a URL to OneDrive.\{\{bl=2\}\}} \tn % Row Count 8 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}