cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Search variable key name?

I have a flow that is getting input in a structure like below.

{
"1: Title": "SHOW",
"2: Client": "John Doe",
"3: E-mail": "johndoe@email.com",
}


It has more questions and a few of the items get hidden if something is not answered, so the numbers in the Keys change, in a way that "2: Client" can become "3: Client"

 
Is there a way to search keys to get variables based on the part that doesn't change?
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I ended up solving it by concatanating the possible keys to ta variable.
Like so:

"2: Who's asking?": "John Doe" + "3: Who's asking?": "John Doe" + "4: Who's asking?": "John Doe",

Since only one would return a string and the others are null, the resulting string is the answer I need.

What I noticed is that I don't have that issue with Zapier, so I guess they're creating the input in different way from Microsoft's Flow trigger for Typeform.

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

Sorry for I couldn't understand your requirement from your description.

Could you please explain more details about your requirement so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Anonymous
Not applicable

I'm using Typeform to trigger the creation of a task in Planner.

From what I can see from the Flow, it's getting the input from Typeform in a structure like so:

{
"1: What show?": "NEWS SHOW",
"2: Who's asking?": "John Doe",
"3: What's your e-mail?": "johndoe@email.com",
}

But Typeform has what it calls "logic jumps" and I'm using it to get answers in case a certain answer comes up.
The problem is that if a question in the form goes unanswered, it changes the # in the keys names.
So in my use case, question "1: What show?" might be answered as "another", which leads to a new question "2: What's the name of the show?" that would have been jumped if "1: What show?" was answered as one of the options.

The problem is that because of the new entry "2: What's the name of the show?", all other keys are changed and this is the new input:

{
"1: What show?": "another",
"2: What's the name of the show?: "SPORTS SHOW", "3: Who's asking?": "John Doe", "4: What's your e-mail?": "johndoe@email.com", }


But it seems the full name "3: Who's asking?" is what I need to use in flow. I was wondering if there was a way to get the key that contain "Who's asking", ignoring the "3: " part, so I can pass the correct value to flow.

Anonymous
Not applicable

I ended up solving it by concatanating the possible keys to ta variable.
Like so:

"2: Who's asking?": "John Doe" + "3: Who's asking?": "John Doe" + "4: Who's asking?": "John Doe",

Since only one would return a string and the others are null, the resulting string is the answer I need.

What I noticed is that I don't have that issue with Zapier, so I guess they're creating the input in different way from Microsoft's Flow trigger for Typeform.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,567)