Unanswered

Values from variables not being saved after submission of an item

(0) Share

Report

Posted on by TrayH

383

Hi, I have a SharePoint customized form I've built in Power Apps, and am working on creating an approval process for it. As part of that, within the form I'd like to record the name/date of each person that approves it.

Here is a screenshot of the relevant section -

And here is the OnSelect property of the Approve button -

I have the default property of the datacard values for the Approved By and Approval Date fields set to those variables -

This setup works initially, and will populate the Approver Name and date when I click on the Approve button. The problem is that after submitting the form, if I go back into that same item those fields are once again blank. I'm assuming I need to put something for the variables into the various OnSave, OnEdit etc properties of SharePoint Integration object, but would like some guidance on what and where that needs to be.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@TrayH - variables behave differently with customised forms. The variables remain persistent, even if you close the Form.

On the Default property of the Approval DataCard, use:

If( IsBlank(varUnderwriterApprovedBy), ThisItem.'Your Approver Name Field', varUnderwriterApprovedBy )

On the OnSelect property of your Approve button, use:

Set( varUnderwriterApprovedBy, User().FullName )

For the following properties of SharePointIntegration, use:

OnNew:

NewForm(SharePointForm1); Set( varUnderwriterApprovedBy, Blank() )

OnSave:

SubmitForm(SharePointForm1); Set( varUnderwriterApprovedBy, Blank() )

OnCancel:

ResetForm(SharePointForm1); Set( varUnderwriterApprovedBy, Blank() )

Apply similar logic to your Approval Date Field.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
TrayH 383 on at

Like (0)

Report

I ran a few tests and I think that's working. Thank you!

One question I have regarding the set variables in the SharePoint intergration object. Will I also need to add that to OnView of the SP Integration Object and OnSuccess of the SharePointForm1 object?

The reason I ask is because in this same form, I followed a video from Reza where I used variables as part of setting up checkboxes in multiselect choice fields. In that he said for SP customized forms, to add the Set(varname,Blank()) to the following locations -

SharePoint Integration -
OnCancel
OnEdit
OnNew
OnView

And for the SharePointForm1 object:
OnSuccess

I just want to make sure I'm not missing anything. Thank you again!

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

Hi @TrayH ,

I am not aware of Reza's video and I do not know in what context he is applying his advice to (although I am glad the advice I gave you is similar to his overall approach).

In your context, I would only see a need to update the properties I outlined above (OnSave, OnNew, OnCancel).

I do not see a need to update the OnSuccess property because this is already being handled by the OnSave property. I do not see any need to update the OnView property either because the example I gave should behave correctly without it.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
kmw1130 988 on at

Like (0)

Report

@Amik I have a similar question and wondering if I your solution would work. I'm not using variables, but I am selecting a default value on the DataCardValue card using a lookup (this is to send approvals to), but I want to be able to update the DataCard (ThisItem.Field) to the approver that completed the approval process, because it could be different that my default in the DataCardValue. But what is happening in my Update action in Flow, it is not updating the DataCard (ThisItem.Field), it keeps the default value of the DataCardValue with the Lookup. I'm sure I am missing something, just not sure what.

Was this reply helpful? Yes No