Get information for next line of Array

(0) Share

Report

Posted on by elikls

Hi,

I have this array:

[
 "Your Email Address:",
 "test@test.com",
 "Number:",
 "45",
 "City:",
 "Melbourne",
 "Date:",
 "14 Jan 2023",
 "Type:",
 "Placement",
 "Select Indication:",
 "Other",
]

This array is not always in that order and has extra information I do not need but there are constants;

The information I need is always the next line after the field.

Example; If I want the email, "Your Email Address:" is always going to be before the data I want which is "test@test.com"

Another example; The name of the city will always be the next line after "City:".

What would be the formula to output the next line after the "Your Email Address:", etc?

I'll be able to figure out the rest once I can get my head around this.

Thank you in advance!

Categories:

Building flows

All responses (11)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @elikls

I would suggest you to use Parse Json action for this. Giving you a video link below to understand more about it:

https://www.youtube.com/watch?v=e0dzMqoJGtY
elikls 18 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Thanks for that - I followed on with the video but and used:
{ "type": "array", "items": { "type": "string" } }

but that didn't do anything. So I am not sure how to continue
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @elikls ,

I have a test for your reference, in my scenario I get the next row of "Date" of the array.

Best Regards,
Dezhi
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-dezhili-msft,
don't you think that 'Initialize variable' is useless here?
grantjenkins 11,063 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@elikls Just wondering how you get this data as it looks unusual having properties and values as single items in an array. Is it the result of extracting the data from somewhere?
elikls 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you everyone - I will check out the solutions tomorrow at work.

As for the data it’s from an email I get forwarded to me from Formstack 🙂 I turn it into an array so it’s easier make automations
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @elikls,
did you see this: https://powerautomate.microsoft.com/en-us/connectors/details/shared_formstackforms/formstack-forms/ ?
elikls 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I have, sadly I don’t own the form. I am just a user who fills it out and gets an email back with the confirmation of what I filled in
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@elikls Are you able to show the raw data you receive before you convert it to an array? It might be that we can convert it to a proper object with key/value pairs rather than just an array of items.