Hi @Django
I really liked the video and over all explanation. However, I have a case where my values do not have a key.
I just have a bunch of values separated by ',,'. Is there a way to extract these values into multiple variables (one value each variable) and push those variables to some spreadsheet cell.
I am trying to parse an email and then extract some values into spreadsheet.
After trigger, I am using combination of functions to split and then join my values of interest with ',,' as delimiter.
My data looks something like this - value1,,value2,,value3,,....
Here are the steps I have performed so far. I think I can apply apply to each somehow not sure of the exact process.
Thank you!
Hi , very nice to be helpful!
In your case if you have a consistent string with always the same order, always the same separator ==> like value1,,value2,,value3,value4,,value5
- You can use split() to convert your formatted string to separate objects on one nice array
split(outputs('Compose_-_FormattedString'),',,') - Then you can reference any item from within the new array using the 0-to-n-index that an array always has:
outputs('Compose_-_FormattedStringSplitToArray')?[0]
0 at the end would be the first value of your string = value1
1 at the end would be the second value of your string = value2
and so on... 👍
Hi Django,
Thank you for your video. After importing the flow, I see two issues which I think are related
I am unable to double click on the Parameters, such as UserID, Email, inside the "Send an email". I also don't see them listed in the dynamic content. I already ran a test email with the same input data as shown in the video.
Hi Django,
This is such a helpful post. Thank you for sharing it. I've tried to run your test and the KeyToFind isn't finding what it should be right now. My data is split over several lines, could that be the cause of the issue? How would I adjust that? I'm also looking for phrases with spaces i.e. "Payment method". Would that cause an issue?
Thanks,
Liz
