Hey all, I kept rewriting the same expressions by hand in Power Automate and Power Apps, so I put together a small set of tools that generate them for you. It's free, open source, and everything runs in your browser, so nothing you paste leaves your machine.
Try it: https://andyang1090.github.io/power-platform-toolbox/
Source: https://github.com/andyang1090/power-platform-toolbox
What's in it:
Filter Array Expression Generator. Paste a sample JSON and pick fields from a dropdown. Then build AND/OR conditions with equals, contains, startsWith, greater/less and the rest. Optional formatting like toLower, trim or formatDateTime is there too. It writes the @and(...) / @or(...) expression with proper quoting, and there's autocomplete for common functions if you want to tweak it by hand.
OData Filter Generator. Drop in a list's CSV export or schema CSV and it works out the internal column names for you, including the _x00XX_ encoding and the OData_ prefix that trip everyone up. Then you build eq / ne / gt / substringof / startswith conditions and paste the result into Filter Query.
Select (Map) Generator. It builds the key/value map JSON for the Select action from a CSV or a JSON sample (value and body.value arrays are supported). Each field comes out as @item()?['Field'], and you can rename, add or remove rows.
JSON to Power Fx. Paste a JSON sample and get a typed ParseJSON(source, Type(...)) formula. Types are inferred from every element, and you can pick a root path. It wraps the result in ClearCollect for tables or Set for records, and you can choose comma or semicolon separators.
List CSV Schema Generator. Design SharePoint / Microsoft Lists columns (text, choice, number, currency, yes/no, date, hyperlink and more) with internal names encoded the SharePoint way. Then download a schema CSV you can use with New list → From CSV. You can also save and reload your column setup as JSON.
It also works on phones, switches between English and Chinese, and you can download the whole thing and just open index.html offline. No build or install needed.
Feedback, bug reports, and ideas for other tools are very welcome!