So I've searched this quite a bit, I've found quite a few articles that detail the process, but I can't seem to get it working, so here I am looking to see if I can get help, I've got a lookup in a flow that does a Get Items from a SharePoint list, the filter is working just fine, but the items that it does get, I want to GET a specific field (text field, that has email addresses in it) and send out ONE approval with all of those, I've tried various different things using data operations but cannot seem to get it to work correctly, and I'm at the point now where I don't know which I should even be using. I've come pretty close using a "Select" & "Join" process, but the output isn't quite what I need, see screenshots.
It's outputting the correct fields, but just not as the raw text that I need, it's including the JSON, and I cannot seem to figure out how to strip the JSON out of there, this is how close I've got it, the output is (as shown in the screenshot below):
"{"Email":"EmailAddressatdomain.com"};{"Email":"EmailAddressatdomain.com"};{"Email":"EmailAddressatdomain.com"}"
I need it to read like:
Emailaddressatdomain.com; emailaddress2atdomain.com; emailaddress3atdomain.com
In summary, these are the steps I'm trying to have, seemingly pretty basic.
Here's a screenshot:
Thanks
Solved! Go to Solution.
Hi @BigShotRob
You could use replace expression function.
First try to replace "{"Email":" with ''
Next replace "}; with ''
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Hi @BigShotRob
You could use replace expression function.
First try to replace "{"Email":" with ''
Next replace "}; with ''
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
So simple, how embarrassing.. I was so fixated on way more complex solutions 🙂
Thanks for your help, I've got it working.
That said, is there a way to do both actions in a single compose action? Just so it's more clean?
Something like
replace(body('StripJSON'),'{"":"','') && Replace(outputs('StripJSON'),'"}','')
Hi @BigShotRob
You could Replace within Replace or Concat to combine together.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
User | Count |
---|---|
68 | |
50 | |
47 | |
27 | |
17 |
User | Count |
---|---|
26 | |
26 | |
22 | |
20 | |
20 |