Power Apps

Various pages into one line on SharePoint list

(1) Share

Report

Posted on by berkenmi

Good day

I have 8 pages all linked to one data source, that when submitted should lie on one line in the list.

I have tried to 'Patch' but it keeps on giving an error.

I have a 'navigate' button to move from one page to the other.

The final 'submit' button is on page 8

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @berkenmi,

Could you please post the error here?

The possible reason:

Patch functino expects a record (a single object with field:value pairs). Each FormX.Updates is itself a record. When you pass multiple .Updates directly, Power Apps sometimes can’t merge them cleanly, especially if there are overlapping fields or if the syntax isn’t wrapped correctly.

Let's combie all the form updates into one record before patching. The right way is to use the Patch function with Defaults and then merge the updates:

Patch( 'Site Stream SHE Checklist', Defaults('Site Stream SHE Checklist'), { // Merge all updates here Field1: PDForm1.Updates.Field1, Field2: PDForm2.Updates.Field2, Field3: PDForm3.Updates.Field3, ... } )

A short-hand .Updates

Patch( 'Site Stream SHE Checklist', Defaults('Site Stream SHE Checklist'), PDForm1.Updates, PDForm2.Updates, PDForm3.Updates, PDForm4.Updates, PDForm5.Updates, PDForm6.Updates, PDForm7.Updates, PDForm8.Updates )

Please let me know if this helps.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
berkenmi 22 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the short-hand.updates option above and receive the error below:

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Probably you need to move the Patch function to control's OnSelect property.

Please select the button (or control) that triggers your submission. Go to the OnSelect property of that button and paste that short-hand code.

If you want the button to change color after submission, you can use a variable:

OnSelect = Set(varSubmitted, true); Patch(...) PressedFill = If(varSubmitted, Color.Green, Color.LightBlue)

We have a similar thread here.

Was this reply helpful? Yes No
berkenmi 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Issue resolved, thank you for the assistance

Was this reply helpful? Yes No