I need some help. I need to get an email value from a JSON array consistently, but have no idea how to do it.
The array could look like this:
[ "email@example.com\" ]
or this, depending on whether the other attributes are present:
[ "firstname.lastname@example.org\",\"notApiConsumer\",\"webApp" ]
Is there any way I can consistently pull the email address from within this array?
I'm not sure I can use position ids since there could be other values within this array.
Solved! Go to Solution.
Hello @Paulie78 , I would also like to mention that the domains of the email could be different.
In my example, I've put it as googlemax.edu.sg. However, in my environment, there are sub domains. Such as, visitors.googlemax.edu.sg, students.googlemax.edu.sg. This complication has me pretty stumped as I can't just split the string from @googlemax.edu.sg.
It should be straightforward, the part that makes it slightly tricky is that your array, only actually contains one value. The double quote marks are escaped, so it is an array with only 1 element.
It's kinda weird. When I test this on a clean new flow, it works. However, when I implement this filter array action in my existing flow, the flow never finishes.
Any idea what might cause this?
This is the actual output of the json.
"tags": [ "owner:email@example.com", "notApiConsumer", "webApp" ]
I'm putting this content into a tag variable and executing your steps on it. If i initialize this tag variable as a string, the flow works but I don't get the email address. If I initialize this variable as an array, the flow times out.
Appreciate your help on this.
Edit: Add 1 more screenshot.
Just wanna let you know that you're the best.
I managed to solve by it keeping the Tags variable as string, and using this expression to split the string instead.
You though, are the true rockstar 🤠.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.