Unanswered

Form.LastSubmit.ID is null

(0) Share

Report

Posted on by johnjohn123

3,506

I have a Main form named "frmItem", where inside it i have a Data-card which contain 3 input fields and a gallery as follow (to represents a Parent / child relation):-

now on the Onsuccess of the main form i want to set the SID value of the subform to be equal the main form item ID.. the Onsuccess code for the main form is shown above .. but currently when the value got saved to sharepoint it will show null (the SID will be null).. any idea?

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@johnjohn123

Please consider changing your OnSuccess Formula to the following:

Collect(SNMItems, ForAll(colSItems As _item, {'Vendor Price': _item.'Vendor Price', Vendor: Vendor, 'Vendor Part No.': _item.'Vendor Part Number', SID: Self.LastSubmit.ID } ) )

This assumes that all the columns in your record are the correct types.

I hope this is helpful for you.

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@RandyHayes ok thanks will try your formula, but why my formula will not work? i got it from this YouTube videos which work for the author @ https://www.youtube.com/watch?v=xgznk4XlPCo check starting at minute 23 .. any idea?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@johnjohn123

His formula is backward, but essentially should still work - just not well.

Give the suggestion formula a try and see if that helps in any way.

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@RandyHayes I tried your formula, but still the SId will be null!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@johnjohn123

What type of column is SID in your list?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@RandyHayes of type Number. thanks

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@johnjohn123

Well LastSubmit.ID will not be null. So, your formula is not doing anything then because of an error.

I would take a look in the Monitor Tool and see what is interacting in the OnSuccess.

To be clear though, are you stating that new records get created properly and have the proper 'Vendor Price', Vendor, and 'Vendor Part No.' in them, but no SID?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@RandyHayes Yes 100% correct.. the records will be created correctly with the Price,Part No and Vendor,, but the SID will be null!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@johnjohn123

What did you see in the monitor tool for the SID column?

OR

Add the following to the OnSuccess action:

UpdateContext({lclLastID: Self.LastSubmit.ID})

Then look a your variables and see what that value is.

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@RandyHayeswhen i added this to the OnSuccess for the form
UpdateContext({lclLastID: Self.LastSubmit.ID})

and i checked the variables, it will say that "No Value"

any idea?
Thansk

Was this reply helpful? Yes No