Hello, I have set up a solution utilising MS Forms, MS Lists and PowerAutomate that sends the data from the forms to the lists using a number of flows to do so. In addition, there's a flow that generates a unique ID (based upon the row ID of the list where the data from the form feeds into) and then sends an email to the submitter with this unique ID.
I've recently had to make some amends to the forms and the lists, which in turn have required amends to the flows too. I've attempted to carry out a test on one of the flows by submitting a test form, but I've had the flow fail that is meant to create an entry in the list once the form has been submitted. The error is: Action 'Create_item' failed. The error details advise: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Unscripted_x002d_Howmanyleadersh' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.
To give some context to the above, the form has a question that asks what programme type and you answer either Scripted or Unscripted, which then using branching, asks you a set of questions (and has the same answers) that are the exact same except for the first question on each set, which is the same question but has a different context depending on if it's Scripted or Unscripted:
Basically, if you answer Scripted, the Unscripted set of questions are not answered as the branching moves past these and vice versa.
Looking at the raw inputs, the values then applied to these questions that are not answered due to the branching are as follows:
The questions on the form have number restrictions on that mean a number has to be entered, which then are meant to feed into a number column type on the associated list.
I've got 2 questions to the above:
- Is there a way to get around this without taking the number restriction off? I'd rather not do this as the numerical data will be used for business information analysis, so if people add data in that isn't numerical it will skew the figures.
- Also, I realise the way I've set up the form and list - where there's 6 questions on the form and 6 columns in the list that are essentially the same - perhaps isn't the most efficient and is what is causing the above error. How can I tweak the form so that it only shows the context for Scripted / Unscripted, which would then mean I only had to use 3 follow up questions and 3 columns on the list? Would it be through using a section element?
