TL;DR: Convert a two-column Name/Value table to a JSON record and run it through Parse JSON so you can access each entry directly.
💡 Challenge
Working with two-column tables, specifically ‘Name’ and ‘Value’ pairs, in Power Automate can be tedious when trying to access individual entries efficiently.
✅ Solution
Streamline the selection of individual entries by converting the table into a JSON record and using the “Parse JSON” action.
🔧 How It’s Done
-
Convert your ‘Name’ and ‘Value’ table into a JSON record. This transformation allows more flexible data manipulation.
-
Use the “Parse JSON” action in Power Automate to structure the data, enabling straightforward access to any entry within your flow.
🎉 Result
Accessing and selecting data from two-column tables becomes seamless, saving time and reducing complexity.
🌟 Key Advantages
🔸 Efficiency: Quickly convert tabular data into a manipulable format.
🔸 Simplicity: Access individual data points without complex expressions.
🔸 Flexibility: Adapt the method for various data structures beyond simple name-value pairs.
🎥 Video Tutorial
🛠️ FAQ
1. Can this method handle tables with multiple columns beyond name-value pairs?
Yes, but you’ll need to modify the JSON structure to accommodate additional columns, creating more complex object structures.
2. What happens if my table contains special characters or spaces in the names?
Special characters may need escaping in JSON. Consider using the replace() function to sanitize field names before conversion.
3. Is there a size limit for tables when converting to JSON?
While there’s no strict limit, very large tables may impact flow performance. Consider batch processing for tables with thousands of rows.
Marcel Lehmann
Microsoft MVP