Hoping someone can help with the following scenario:
We have a Forms form containing a few NPS type questions. We use branching to make one of the NPS questions only appear if the previous question result is Yes. I take the form responses into a SharePoint list using a Power Automate Flow and store the NPS results in a number column in SharePoint.
The issue I have is that if the branching causes the optional NPS question to be omitted, I need to return a blank value into the SharePoint list (as opposed to a zero value indicating the question has been answered but the user filled in a rating of zero).
It seems that flow returns the results correctly....
This is where the question 'How likely are you...' was omitted:
And this is what is returned if the user rates us as a zero:
Trying to use:
int(outputs('Get_response_details')?['body/rd4c5590be4854ee78e742aaa6b920e18'])
Fails when the question has been omitted, I assume because int('') will fail.
The only way round this I have found so far is to use a Condition on the result of the previous question to detect if to expect an answer, and do two separate 'Create Item' actions, one with the NPS question and one without.
Like this...
Is there a more elegant way to do this, my flow is quite complex already so i could do without another condition being added if possible!
