Answered

Cannot submit a form when selecting multiple names in the form

(0) Share

Report

Posted on by Ali79

Looking for help please.

I've created a form where user inputs data (name of the task, completed by, comments etc). "Completed by" field allows user to select multiple names from the office360Users (multiple selection is also enabled in the corresponding sharepoint column). However when I submit the form there is an error message "Network error when using Patch function. An unknown error occurred".

When returning to the form submit button has formula error (formula is: "SubmitForm('FormName');ResetForm('FormName');Navigate('FormNameEntry');NewForm('FormName')"

Everything works when I remove multiple selection in the 'Completed by" entry and sharepoint column.

Any ideas how this can be fixed? Allowing multiple names under "Completed by' would be quite handy.

Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ali79 ,

Is the completed by column in SharePoint list a Person column? If so, when it allows multiple selections, you will need a formatted table in the Update property of the completed by Data Card:

ForAll( ComboBox.Selected As CC, { Claims: "i:0#.f|membership|"&CC.Mail, Department: "", DisplayName: CC.DisplayName, Email: CC.Mail, JobTitle: "", Picture: "" } )

Best regards,

Was this reply helpful? Yes No
Ali79 28 on at

Like
a
(0)

Report
Copy link

Link copied!

just to add, i've recreated the app. And it allowed me to submit, but sharepoint didn't register multiple entries, plus my quick view tables (summary of all entries) now doesn't display Completed by names - i think I can solve it by using a list box..

Was this reply helpful? Yes No
Ali79 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, sharepoint is a person column.
Which field do i updated this at (Update? Items?) or do i updated this in the sharepoint? Thank you
Sorry, just started using power apps

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ali79 ,

Update is a property of Data Card Controls, it helps determine what values to be added into data source when using SubmitForm or Patch function:

Best regards,

Was this reply helpful? Yes No
Ali79 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, but it doesn't work, shows an error in the formula box
The field wasn't selected as a combobox. There is a function on the panel i used to allow multiple selection. I only show picture, name and e-mail.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ali79 ,

It is a Combo box, although named as DataCardValueX in the Form:

So, you need to copy the name of that Combo box into the formula I provided, place them all into Update property:

ForAll( DataCardValue.SelectedItems As CC, { Claims: "i:0#.f|membership|"&CC.Mail, Department: "", DisplayName: CC.DisplayName, Email: CC.Mail, JobTitle: "", Picture: "" } )

Best regards,

Was this reply helpful? Yes No
Ali79 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I did, but formula still shows an error

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ali79 ,

What is the error message?

BR,

Was this reply helpful? Yes No
Ali79 28 on at

Like
a
(0)

Report
Copy link

Link copied!

There is no actual error displayed, just a cross agaisnt the card and then when you click on it it askes to edit in formula.
When i run my full form, ie enter all details etc, it sys 'JSON paring error, expected 'object' but got 'array' now.
Before it was "Network error when using Patch function, an unknown error occurred'
and once before that it worked but didn't record any data in the sharepoint (ie names) and then on a second run all errors started occuring

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ali79 ,

When you see a red cross in your app, you can move mouse on it and then you will be able to see the error message.

then you can click the down arrow, it will move to the place where error occurs. If it's formula error, you will also see red waves in the formula bar.

Anyway, it seems the Form is added into App BEFORE you editing SP list column to make it allow multiple selections. If this is the case, you need to delete the form then re-add it into your app, modify the Cards and properties from the scratch.

Note: please remember refresh the connection in your App if you have not closed it after editing list column.

Best regards,

Was this reply helpful? Yes No