Hello all,
I've been struggling with this issue for a while now and thought it was time to call some experts.
Currently, I am building a project (PowerApps Canvas) which includes a form dashboard (allowing you to view forms in a SharePoint list), as well as a form that a user can fill out. All is well up until the user submits the form. I have logic, that concatenates 3 fields in the form and puts it in the title, the formula looks like this:
Concatenate("#",TM_ID_Value, " - ",TM_UserFullName_Value,": ",'TM_Date&Time_Value')
On the second forms 'OnSuccess' property, I also have the following code which concatenates the title with the form ID field:
Patch(
'TM',
TM_Form_1.LastSubmit,
{
Title: Concatenate(
"#",
TM_Form_1.LastSubmit.ID,
" - ",
TM_Form_1.LastSubmit.Title
)
}
);
The issue is that when the form is submitted, it seems that the title doesn't update with the SharePoint ID, instead it is just blank, and I get something like:
'# - John Smith: 24/07/2023 13:11'
when it should be...
'#76 - John Smith: 24/07/2023 13:11'
any ideas would be appreciated.
Thank you,
- Proton
