Unanswered

Empty questions on a form. - ActionFailed. An action failed. No dependent actions succeeded.

(0) Share

Report

Posted on by LukeSykes

I see lots of questions on this but none of them help me ☹️

Eree be my problem

The MS form is used the submit records of transactions made which I need to create an item in SharePoint, problem is, if its one or the other type of transactions and not the other, well of course the box is left blank.

So if its a cash transaction only, Invoice, BACS and the others are left blank on the form. Power Automate fails no matter how I try to fix the empty question problem.

Flow...

Outcome...

Please help!

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

When using the answers to the questions in the Sharepoint Create item put each one inside a Coalesce() function with a suitable empty value as the alternate. That way if the answer is null the alternate value will be used.

Blank, Coalesce, IsBlank, and IsEmpty functions in Power Apps - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Thank you does the coalesce() function go in the chosen value box under condition?

Also, I have no idea how to structure that expression...

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

Like (0)

Report

There are examples in the documentation I linked to. The Coalesce() function reads the values supplied from left to right and uses the first non-null value. So if you put a Coalesce around the value for each form response, instead of using the response by itself, you can supply a default value to use if its null. So yes you use it in the fields where you are using the responses now.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Thank you

This is the string I am using in the column field in 'create an item', from a form submission

coalesce(outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc'],'0')

I'm expecting that if the field in the form is empty it will add a zero in the item. If the field is not empty it will add the value from the form.

Am I doing this right? because its still failing every time with

ActionFailed. An action failed. No dependent actions

on apply to each and

'OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Cash' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.'

on create item.

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

Like (0)

Report
Instead of Coalesce you may need to use If(IsBlank()... Coalesce works with Null values, but blank values will be passed through. In Power apps it does both blank and null values. Try using

if(IsBlank(outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc']),'0',outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc'])

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Thank you so much for your help and i'm sorry about this but now I get this error

InvalidTemplate. Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template function 'IsBlank' is not defined or not valid.'.

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

Like (0)

Report

Sorry, not thinking right. IsBlank() is a Power Apps expression, not Power Automate. Us If(<<dynamic contentname>> = "","default value",<<dynamic contentname>>)

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

You'll be getting fed up of me now. I'm using your expression with my dynamic content but power automate says it invalid

if(outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc']="","0",outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc'])5e8e3b4535a457a145b6bac5cc'])

I tried it using spaces where the '=' sign is in your example but this doesn't do anything

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

Like (0)

Report

Use Single quotes in place of the double quotes.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

I'm sorry but that just doesn't seem to work either.

I'm using this in the create item column fields, is that right? and if its wrong is that why its not working?

I removed the condition because i assumed it would work fine doing it like this...

Was this reply helpful? Yes No