Marcel Lehmann

I love this approach, which I use more and more often, especially after this video. Before that, I always used a filter array and first to get to this data. By changing the search text as a key, I can directly access the underlying data without any major detours.

For example, if you have a form where users can enter their salutation in their local language or local convention (like “Mr”, “M.”, “Monsieur”, etc.), you can use this JSON object to map these salutations to the corresponding terms (“Herr” or “Frau”). This way, you can handle the data in a consistent way in your system, regardless of the input language or convention.

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.