Unanswered

how to save the flow when used two Response in flow

(0) Share

Report

Posted on by Community Power Pla...

Hi Team,

based on the condition there are two Select(action), and those have different columns to respond to Power app.

so when I try to save flow it throws error, In-fact there is no error in the schema, if I use any one response(verified both sections with only one response) then I can save and work fine, but not with two responses

Is there any alternate solution?

The reply would be appreciate.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

You can't use two different respond to Power Apps actions in a single flow. You need to build a schema that will work for either Select and then use a single response action with that schema and the output of the select in the parallel branch that is followed. In other words bring the parallel paths back together to a single response action.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous

I will suggest you a method here. Try that.

Add that condition inside a scope.

Then after that scope, add a compose.

In that write the following expression:

if(equals(result('Scope')[0].inputs.expressionResult,true),body('Select'),body('Select_2'))

After that make another compose and make a json structure in that.
And then pass this to the response action.

@Pstork1
This is the old post, and I suggested him to use 2 Select actions.
https://powerusers.microsoft.com/t5/Using-Connectors/how-to-bypass-the-blank-field-values-in-Select-action/m-p/1883707#M16741
Do you have a better solution?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Instead of using two Data Selects I would try using a coalesce() in the value field of the data select for the fields that may be returned as null. In the coalesce substitute some default value for the null values. Something like this

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Pstork1

Actually in his scenario, the field called companyName is not coming and sometimes its coming. I tried the above function but it didnt work. So, as the field is not coming sometimes, it giving error that this property is not available.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I would have to play around with it more to see if there is still a way to get the coalesce to work. But if there isn't then as I said the answer is to bring everything back together at the end and use one HTTP response with a custom schema where that one column isn't listed as required.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

I just tried the coalesce() again with a field that doesn't even exist in the Get Items I am pulling it from and the data select worked just fine. Make sure you have the ? in between the items() and the field name. That's what allows it to be null. I used the following

coalesce(item()?['CompanyName'],'empty') and got this output.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Pstork1
Thanks. Learned something new today. 🙂
My bad, actually I had missed that question mark only. Hehe. Sorry!!!

@Anonymous

So, follow @Pstork1 method, dont use two selects, instead use coalesce function.

Was this reply helpful? Yes No