Help with updating 1 parent field using multiple screens

(0) Share

Report

Posted on by olsen9

378

User enters data in screen 1 (there is a number field they will enter)

Next user goes into form and sees second screen. (screen2) There is a hidden counter (number field +1)

Need that field to be updated from screen 1.

I've tried Patch and I've tried the update section in the datacard but is not taking any updates.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @olsen9

In your navigate to change screens: try: Navigate(screen2, cover, {varCounter: Value(NumberField.Text) + 1})

Then in Screen 2, set the default for your hidden field to varCounter - and when you submit the form this figure should be written to your datasource.

Is my understanding of your use case correct? - Hope this helps

Was this reply helpful? Yes No
olsen9 378 on at

Like (0)

Report
Copy link

Link copied!

That is how I have it written however when it creates a new record the value updates but not in the parent record only in the new record that is created

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

How have you defined the item property in each form? - Also need to make sure the form in screen 2 is in edit mode and the item matches that of the record you are trying to update.

Was this reply helpful? Yes No
olsen9 378 on at

Like (0)

Report
Copy link

Link copied!

My screen 2 is in edit mode, just need the previous field updated, that is all

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @olsen9 - Can you provide some more info with screen grabs to help illustrate what you are trying to achieve?

Thanks

Was this reply helpful? Yes No
olsen9 378 on at

Like (0)

Report
Copy link

Link copied!

Here you go, the item test has a value as 1, when I open the record "test" and click add additional finding, I want the value of the "test" record to update. I already have the counter, for this recording it didn't update but that's not any worries, just the previous record I need updated.

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!
@olsen9 - Thank you for the GIF, which is a big help,

I now understand things a bit more, but there are still a few gaps I need filled in relation to how things are hooked up behind the scenes:

The columns in the RIFT list are hidden and the majority of fields in the form on screen 2 are different to those on screen 1 - are both these forms connected to the RIFT List or is the form on screen 2 updating a different list, resulting in a 1 to many relationship between the RIFT list and the other list?
Please confirm the following for Screen 1:
The Form data source is RIFT list
the Code in the Form Item property
the Code for the 'OnSelect' property of 'Add additional Finding' Button
Please confirm the following for Screen 2:
The Form data source? RIFT list or another list?
Code in the Form Item property
TaskHolder_NextValue - What should this be? - should this be 2 in your GIF? - what code is in the default property of this control and the DataCard update property?
Code in the 'OnSelect' of you Checkmark/submit button
Any other code that is relevant to the process - You mentioned trying a patch, which wasn't working properly? - Can you share this also, if not included in one of the controls above?

Many thanks

Was this reply helpful? Yes No
olsen9 378 on at

Like (0)

Report
Copy link

Link copied!

1. correct, just hidden fields from 1 list
2. Data source is rift only, If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'RIFT']),SharePointIntegration.Selected)
NewForm(subtaskform);UpdateContext({varRequireFields:false});UpdateContext({varSetID:TextInput2});Navigate(Screen1,ScreenTransition.Fade);
3. Screen 2 code is RIFT Only just
The next number should be 2. I suppose patch would work for a previous record. Just maybe need to create a filter to bring in the legacy item.

Was this reply helpful? Yes No