1. Start with creating a new automation flow in Power Automate. Choose the appropriate trigger. If you're doing it manually, select 'Manually trigger a flow'.
2. To copy the list data, add a "Get items" action for SharePoint. Specify the Site Address and List Name of the source list.
3. Next, add a "Create item" action for SharePoint. Set the Site Address and List Name to the destination list.
4. Within the "Create item" action, map the fields of the source list to the new list.
5. After successfully copying the list, we'll have to update the Totals of a column. As of my knowledge cutoff in September 2021, Power Automate does not directly support updating list view settings, which includes setting column totals.
6. However, you can do this using a "Send an HTTP request to SharePoint" action to call the SharePoint REST API. This action can be used to make changes to a SharePoint list view, which includes settings like Totals for a column.
7. Configure the HTTP request as follows:
- Method: POST
- Uri: _api/web/lists/getbytitle('Your List Name')/views/getbytitle('Your View Name')
- Headers:
- Accept: application/json;odata=nometadata
- Content-Type: application/json;odata=nometadata
- If-Match: *
- X-HTTP-Method: MERGE
- Body: Use the following template, replacing 'Field Name' with the name of your column:
```
{
"ViewQuery": "<View><Query/><ViewFields><FieldRef Name='Field Name'/></ViewFields><Aggregations Value='On'><FieldRef Name='Field Name' Type='SUM'/></Aggregations></View>"
}
```
8. Once you've done all this, save and run the flow. The Totals for your column should be set on the new list.
Please note that you'll need to replace 'Your List Name', 'Your View Name', and 'Field Name' with your specific list, view, and field names. The Type attribute in the Body JSON should be changed to reflect the type of total you want (e.g., 'SUM', 'AVG', etc.).
Also, please be aware that modifying SharePoint via REST API calls requires careful handling and adequate permissions. Always test on non-production environments first to ensure no unwanted changes are made.
