Below you will find pages that utilize the taxonomy term “CSV”
posts
Group and Concatenate CSV Data Using XML in Power Automate
Table of Contents Introduction Business Scenario CSV Data Structure Step-by-Step Implementation 1. File Upload Trigger 2. Get File Content 3. Parse CSV Data 4. Filter Data 5. Extract Unique Combinations 6. XML Grouping 7. Concatenate Users 8. Create SharePoint Items Complete Flow Overview References Introduction This guide demonstrates how to use Power Automate to group CSV data and concatenate users by Team and Channel using XML processing techniques to save to a SharePoint list.
posts
Bulk Import CSV to SharePoint with Power Automate
Table of Contents Introduction CSV vs Tab-Delimited: Which to Use? Step-by-Step Flow Setup 1. Trigger: File Upload 2. Settings (Parse JSON) 3. Get File Content 4. Parse CSV or Tab-Delimited Data 5. Generate SharePoint Data 6. Batch Processing and Create Items Full Flow Diagram References Introduction Importing large amounts of data from CSV or tab-delimited files to a SharePoint list is a common business need. This guide explains how to build a Power Automate flow for bulk import, highlights key challenges, and provides practical tips for reliable results.
posts
Handling Special Characters within CSV with PowerShell using Encoding
When working with CSV files in PowerShell with special characters you might encounter an issue where special characters (e.g., em dashes —) are incorrectly represented as a question mark inside a diamond �. This common issue arises due to PowerShell’s default encoding not matching the encoding used in the CSV file.
Problem Statement The root of this problem lies in the encoding mismatch. Encoding is a method of converting characters into a format that can be easily stored or transmitted.