Unanswered

SharePoint forms integration app gives a blank error back

(0) Share

Report

Posted on by sandero

I have a custom SharePoint forms integration app.

With three Submitforms on the on save( SubmitForm(SharePointForm1);;SubmitForm(FormBegrootkosten);; SubmitForm(Formfactuur);; ) and every page have a title field include.

On the onstart the save the errors to sharepoint page.

And every time when make the first new record. I get a blank row in my error sharepoint.

How to fiks it?

Many thanks

the item of the first form is If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected);Defaults([database);SharePointIntegration.Selected)

Categories:

Building Power Apps

2023-03-04_16h22_...

I have the same question (0)

All responses (8)

Answers (0)

v-jefferni on at

Like (0)

Report
Hi @sandero ,

Try below formula in Item property of all those forms:

If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected); First([database]); SharePointIntegration.Selected )

Best regards,

Was this reply helpful? Yes No
sandero 13 on at

Like (0)

Report

Thanks,

It doesn't works... the create still te blank records on my error sharepoint.
And now get also two records(with same title) on my production sharepoint list.

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

Like (0)

Report

Hi @sandero ,

Please share more details about your scenario. Why there are three Edit forms each with a Title column, for a single list?

Best regards,

Was this reply helpful? Yes No
sandero 13 on at

Like (0)

Report

Hallo @v-jefferni

Because if i put everthing on one page. Then Power Apps see: you have to many controls on one page.
On one page i have only 1 form. The other two page the have a form and a gallery with a look up inside to a other sharepoint page. With some logic en controls inside.
If i don t do the title on the screen 2 and 3 forms. Power Apps gives me then error that the Title is mandatory. I hope it's easier to understand now? Otherwise i will show it to you.

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

Like (0)

Report
Hi @sandero ,

Using multiple Edit forms for a single entry needs Patch function instead of SubmitForm. Every time SubmitForm triggers, it will generate a new entry or update an existing one based on form mode. Please try below formula and only one Title Data Card is needed in the first Form (or rather, there must be no duplicate column cards in these forms):

If( SharePointForm1.Mode = FormMode.New; Patch( YourList; Default(YourList); SharePointForm1.Updates;FormBegrootkosten.Updates;Formfactuur.Updates); Patch( YourList; SharePointIntegration.Selected; SharePointForm1.Updates;FormBegrootkosten.Updates;Formfactuur.Updates ) )

Best regards

Was this reply helpful? Yes No
sandero 13 on at

Like (0)

Report

@v-jefferni
It works many thanks!! I put the code one the onsave in the sharepointintergration. i dont't get an error any moree. But when i am open for the the app for the second time and i wanne update the forms. The onsave don't update any more. He save no vaule any more :(.. i hope you have the solution?

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

Like (0)

Report

Hi @sandero ,

Please show your formulas of following properties:

SharePointIntegration

OnSave/OnEdit/OnNew

Best regards,

Was this reply helpful? Yes No
sandero 13 on at

Like (0)

Report

@v-jefferni See the attachements. i hope you see the problem?

Edit.png

onview.png

onnew.png

Was this reply helpful? Yes No