Hello everyone,
I'm currently working on a project involving Power Automate to create folders in SharePoint whenever a row is updated in Smartsheet. I want to use the updated value in a particular cell as the new folder's name in SharePoint.
I've been following these instructions, but I'm having trouble finding the "Get row" function for Smartsheet in Power Automate:
1. Open the Power Automate flow you created earlier for the sheet update trigger.
2. Add a new step after the trigger step, and search for "Initialize variable" in the action search bar. Select "Initialize variable" as the action.
3. In the "Name" field, enter a name for the variable (e.g., "FolderName").
4. In the "Type" field, select "String" as the variable type.
5. In the "Value" field, enter the name of the column that contains the folder name in the updated sheet (e.g., "Folder Name").
6. Add a new step, and search for "Get row" in the action search bar. Select "Get row" as the action.
7. In the "Sheet" field, select the sheet that triggered the flow.
8. In the "Row ID" field, select the row ID corresponding to the updated row.
9. Add a new step, and search for "Create folder" in the action search bar. Select "Create folder" as the action.
10. In the "Site Address" field, enter the URL of the SharePoint site where you want to create the folder.
11. In the "Folder path" field, enter the path of the parent folder where you want to create the new folder. You can use a static route or a dynamic path that includes the variable you created in step 3 (e.g.,/Documents/{variables('FolderName')}).
12. In the "Folder name" field, enter the name of the folder that you want to create. You can also use a dynamic character that includes the variable you created in Step 3.
13. Save and test the flow.
I've searched through the available actions in Power Automate for Smartsheet but can't find the "Get row" function. Is this feature available for Smartsheet in Power Automate, and if so, where can I find it?
Thanks in advance for any help you can provide!
