PowerApp to create SharePoint list item using flow

[A-HJ]

hope you can help me resolve this:

I have a power app that uses a mixture of text input fields, date selectors and drop down lists to create a SharePoint list item, when the users hits the submit button it runs a PowerAutomate Flow to create the SharePoint List item.

All the fields in the flow are set to Ask in PowerApps.

However PowerApps keeps say there is an error with the flow parameters in the formula bar.

Below is the formula, any help resolving this would be much appricated. 

'CreateSPListItem(Volunteer)'.Run(
'txtinpVunPerName(Vol)'.Text,
'txtinpSJACCounty(Vol)'.Text,
'txtinpSJACDivision(Vol)'.Text,
'dtpkrDOB(Vol)'.SelectedDate,
'txtinpAddressLine1(Vol)'.Text,
'txtinpTown(Vol)'.Text,
'txtinpPostCode(Vol)'.Text,
'txtinpContact#(Vol)'.Text,
'txtinpRefSJACID#(Vol)'.Text,
'txtinpReferrerContact#(Vol)'.Text,
'txtinpVunPerSJACID(Vol)'.Text,
'txtinpVunPerSJACRole(Vol)'.Text,
'drpdwnGender(Vol)'.Selected.Value,
'drpdwnEthnicity(Vol)'.Selected.Value,
'txtinpNOKName(Vol)'.Text,
'txtinpNOKRelation(Vol)'.Text,
'txtinpNOKContact#(Vol)'.Text,
'txtinpRefName(Vol)'.Text,
'txtinpReferrerRole(Vol)'.Text,
'txtinpPCR/PRF#(Vol)'.Text,
'cmbbxCareNeeds(Vol)'.SelectedItems.Value,
'drpdwnYouth(Vol)'.Selected.Value,
'dtpkrDateConcern(Vol)'.SelectedDate,
'txtinpReportDetails(Vol)'.Text,
'drpdwnDTRAware(Vol)'.Selected.Value,
'drpdwnDTRConsent(Vol)'.Selected.Value,
'drpdwnNHQAware(Vol)'.Selected.Value,
'txtinpCommsLog(Vol)'.Text
)

Usually I would create the app by using a connector to the SP List and having an edit form, unfortunately the app user cannot have access to the SharePoint List which is why I have created it in this format.

[WarrenBelz]

@A-HJ ,

The error will be either one of the references, the wrong number of references or references in the wrong place.

Firstly put each one on a label to see if it gives the result in the control. If they are all correct, then follow the "bolded" items in the top panel as you move through them to ensure each "lines up" with the "target".

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[A-HJ]

thanks, have gone through this but they all line up with the target

Could it be the date picker controls?

is the correct format   .SelectedDate

[WarrenBelz · Accepted solution]

@A-HJ ,

Yes - that is correct - have you tried each one on a label? There is to be one wrong somewhere.

You might look at this one first 'cmbbxCareNeeds(Vol)'.SelectedItems.Value - should it be .Selected.Value?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @A-HJ ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[A-HJ]

Thanks, have resolved this it looks like it was the SelectedItem that was a causing the error.

Although now I seem to geting this attached error, when the user hits submit in the app. This happens for each filed regardless of it there is data in the field or not. 

The error only appears for one field but then if you back to the screen the error is referring to an add the data or see if its still there its than the same error again but reference a different field.

The app uses multiple screens, could this be affecting it? 

[WarrenBelz]

Hi @A-HJ ,

That is a Flow error - you would have to look at the inputs you are giving on that parameter and compare it with what the flow destination expects.