@Anonymous
Your formula can be shortened to the following:
With(Self.LastSubmit,
Office365Outlook.SendEmailV2("test@email.com","Updated Item: " & PartNumber,
"An item has been updated. See the following infomation: <br>
<b>PartNumber: </b>" & PartNumber & "<br>
<b>TotalQTY: </b>" & TotalBinLo & "<br>
<b>DateModified: </b>" & DateModified & "<br>
<b>From: PowerApps</b>"
)
)
Using Self, is much easier when you are in a control. IN this case, you are expected to be in a property of the control which is the form. I assume this is an OnSuccess action formula.
So, using Self refers to the current control - the form. If you are in a property in another for, then referring to Self would refer to that other control...not the form. In that case, you would need to specify the form control name.
Since you are still storing your data in a single record (for the part) with all of the columns for the inventory in it (as opposed to a more database-like way), you will be faced with putting all of your columns in by hand.
Determining which value has changed will not be apparent. PowerApps does not only keep track of what was updated, but the entire record in the last submit.
So, you will need to either gather what is being changed during the form entry, or prior to submit.
I hope this is helpful for you.
