{"id":17309,"date":"2023-01-18T19:44:00","date_gmt":"2023-01-18T10:44:00","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=17309"},"modified":"2023-09-02T11:05:57","modified_gmt":"2023-09-02T02:05:57","slug":"powerautomate_use_case_06","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/powerautomate\/powerautomate_use_case_06\/","title":{"rendered":"Run a BOT using the list data acquired from the spreadsheet as the input value (group data) for BOT"},"content":{"rendered":"\n

<\/i> Home<\/a> > Connect<\/a> > Power Automate<\/a> > Run a BOT using the list data acquired from the spreadsheet as the input value (group data) for BOT<\/p>\n\n\n\n

<\/div>\n\n\n\n

Creating a flow<\/h2>\n\n\n\n

Create a flow that executes the list data obtained from the spreadsheet as the BOT input value (group data).<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

Schedule (Recurrence)<\/strong>
Generate a trigger at specified time.<\/p>\n<\/div>\n\n\n\n

\n

Google Sheets\uff08<\/strong><\/strong>Get multiple rows\uff09
<\/strong><\/strong>Get multiple rows of data in the spreadsheet.<\/p>\n<\/div>\n\n\n\n

\n

Control\uff08Apply to each\uff09
<\/strong>The following actions are executed sequentially for the number of rows of group data acquired by \"Get multiple rows\".<\/p>\n<\/div>\n\n\n\n

\n

Cloud BOT\uff08<\/strong>Execute BOT\uff09<\/strong>
<\/strong>Execute BOT with the array output by the control as the input value (group data).<\/p>\n<\/div>\n<\/div>\n\n\n\n

Setting a Schedule<\/h3>\n\n\n\n

1. Click \"Create\" from the navigation menu on the left side of the screen and select \"Automated Cloudflow\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Although a modal window of \"Build an automated cloud flow\" will be displayed, press the \"Skip\" button.\"<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

3. Search for \"Schedule\" in the built-in tab and select \"Recurrence\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

4. Set \"Interval\" and \"Frequency\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Setting Google sheets<\/h3>\n\n\n\n

1.Select \"New Step\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Search for \"Google Sheets\", click the icon and select \"Get Rows\".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

3. Set the action. Set \"File\" and \"Worksheet\".<\/p>\n\n\n\n

*Create a connection if it doesn't exist.<\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

You can check the output value by performing \"Test\" on the upper right after setting.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Setting control<\/h3>\n\n\n\n

In order to execute the list data obtained from Google Sheets as the BOT input value (group data), it is necessary to format the list data into the text format of the group.
Create an empty array and add Google Sheets records to the array in a sequential run. Finally, format the group into a suitable text format.<\/p>\n\n\n\n

Create a flow as follows.<\/p>\n\n\n\n