{"id":17308,"date":"2023-01-18T19:43:44","date_gmt":"2023-01-18T10:43:44","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=17308"},"modified":"2023-09-02T10:53:05","modified_gmt":"2023-09-02T01:53:05","slug":"powerautomate_use_case_05","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/connect\/powerautomate\/powerautomate_use_case_05\/","title":{"rendered":"Add group data acquired by BOT to spreadsheet"},"content":{"rendered":"\n

<\/i> Home<\/a> > Connect<\/a> > Power Automate<\/a> > Add group data acquired by BOT to spreadsheet<\/p>\n\n\n\n

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

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

Create a flow that sequentially executes the process of writing to a spreadsheet using the list data obtained in the cloud BOT.<\/p>\n\n\n\n

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

Cloud BOT\uff08When BOT execution is completed\uff09<\/strong>
Get the BOT execution result when the BOT execution is completed.<\/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 the trigger.<\/p>\n<\/div>\n\n\n\n

\n

Google Sheets\uff08insert row\uff09<\/strong>
Insert row data into the spreadsheet.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Setting Cloud BOT<\/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 \"Cloud BOT\" and click the icon.<\/p>\n\n\n\n

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

4. Select \"When the BOT execution is completed\" for the trigger.<\/p>\n\n\n\n

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

5. Set the trigger. Click here<\/a> for setting values.<\/p>\n\n\n\n

*Create a connection if it doesn't exist. Click here<\/a> for information on creating a connection.<\/small><\/p>\n\n\n\n

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

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

In order to process the group data sequentially, it is necessary to create an array for the number of columns of the group data. Also, you need to create an INDEX variable to refer to the row during sequential execution. Reference the next row in the array by incrementing the INDEX variable at the end of the sequence.<\/p>\n\n\n\n

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