Unanswered

Submit Form and ThisItem doesn't update

(0) Share

Report

Posted on by senna

180

I have a canvas app, very basic run off a SP list, when I submit the form I stay on the form page and the SP list is updated but "ThisItem.XXXX.Value" will not get updated. I have some logic for thisitem but that logic doesn't get updated as thisItem seems to stay on the value from when the form loaded.

Any suggestions on refreshing it?

Categories:

General Questions

All responses (6)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Submit Form and ThisItem doesn't update

HI @CiaranCampbell,

Well, you need to check how you set the Item property of your edit form.

You could retrieve the latest status value by the formula you set for the Item property of your edit form.

if you set the property of your edit form as Gallery.Selected, then you could set the Label text property with:

Gallery.Selected.Status.Value
senna 180 on at

Like (0)

Report

Re: Submit Form and ThisItem doesn't update

Thank you @v-qiaqi-msft but resetForm does not update the value of ThisItem.status.Value
v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Submit Form and ThisItem doesn't update

Hi @CiaranCampbell,

I think you could set the following formula for the OnSuccess property of the edit form:

ResetForm(FormName)

Remember to set the DefaultMode of your form as Edit.
senna 180 on at

Like (0)

Report

Re: Submit Form and ThisItem doesn't update

Thank you @Ramole & @v-qiaqi-msft
Here is an example, its a choice field in SP list called Status, for test here i have a label in the field that shows what the ThisItem.status.Value is.
1. When I open form it is New Application;
2. In the DefaultSelectedItems for this dropdown i have some logic like;
If(
DataCardValue39.Selected.Value="Yes",
LookUp(
Choices([@myList].status),
Value = "Equipment Ordered"
)
)
3. I change "DataCardValue39.Selected.Value" to be Yes and click button with SubmitForm(MyForm) on select
4. My SP List is now has correct Status
5. The value for "ThisItem.status.Value" still stays at New Application;
This is update for my card, it is correct because my list is correct

I need the form to be refreshed in some way but do not want to have the user navigate away and back to form again
Ramole Super User 2024 Season 1 on at

Like (0)

Report

Re: Submit Form and ThisItem doesn't update

Hi @CiaranCampbell
Are referring a lookup column or Choice field? if in that case check your Update of the Data Card, check what you have and make sure the datacardvalue name you should have something like this DataCardValue.Selected
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Submit Form and ThisItem doesn't update

Hi @CiaranCampbell,

More details are needed about "ThisItem.XXXX.Value" will not get updated.

Which control and which property you set for this "ThisItem.XXXX.Value"