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

I have the same question (0)

All responses (8)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No