How to parse a CSV file in Power Automate
Parses a CSV file into JSON using only built-in actions, then reads each value by reference.
CATEGORY
Microsoft
Welcome to my Microsoft hub, the starting point for everything I write about the Microsoft ecosystem. Here you'll find tutorials, references, and practical tips across the Microsoft 365 and Power Platform family, grouped into focused areas so you can jump straight to what you need. If you build automations, start with Power Platform, where I cover Power Automate, Power Apps, and Power BI. For everyday productivity, browse Excel for formulas and data tricks, Microsoft Teams for collaboration, and Microsoft Planner and Microsoft To Do for keeping tasks organized. Working with data and files? OneDrive, Microsoft Lists, and Microsoft Forms each have their own space with hands-on guides. Developers and admins can dig into Microsoft Graph and PowerShell for scripting across SharePoint, Azure, and Microsoft 365. I also cover Microsoft 365 Copilot, Microsoft Outlook, OneNote, and Shifts, showing how these products fit together in real workflows.
Power Automate: int Function
Converts a string to an integer. Floats error; 19+ digit numbers silently corrupt.
Power Automate: Convert Excel Number to Date
Power Apps: Trim Function
Removes leading, trailing, and extra internal spaces from text.
Microsoft Forms: Format Submitted Data
Microsoft Teams: How to create a community in Teams
SharePoint: Choose Function
Returns one value from a set based on an index number. Up to 29 items.
When to use OneDrive vs SharePoint Sites Libraries
Power Apps: TrimEnds Function
Removes leading and trailing spaces. Inner spaces stay intact.
Power Apps: Calculate totals based in Gallery results
Power Automate: Send email with Options
