Hi all,
So, I have a Power Apps form which allows for a submit using a button. I want the title of the form (when submitted) to be the "ID+full name+date and time". I have concatenated that into the title box on the form, and am pulling the unique ID from sharepoint. However, my issue is that the unique ID of the title, does not appear until after the form is submitted, and by that point the title is already set.
I was wondering if I could set the unique ID of the form when it is being modified, rather than submitted, or if there is anyway to update the title automatically after.
Please let me know if you have any questions. 🙂
Regards,
Professor P.
Solved! Go to Solution.
Hi @professor_proto,
You just need to use the OnSuccess property of the form and refer to Form.LastSubmit to update the last submit record with the new concatenated string in the Title.
Set the OnSuccess property of the form as below:
Patch(List,Form.LastSubmit,{Title:Concatenate(User().FullName," ",Form.LastSubmit.ID," ",Text(Now(),"dd/mm/yyyy hh:mm"))})
Hi @professor_proto,
You just need to use the OnSuccess property of the form and refer to Form.LastSubmit to update the last submit record with the new concatenated string in the Title.
Set the OnSuccess property of the form as below:
Patch(List,Form.LastSubmit,{Title:Concatenate(User().FullName," ",Form.LastSubmit.ID," ",Text(Now(),"dd/mm/yyyy hh:mm"))})
User | Count |
---|---|
255 | |
114 | |
94 | |
48 | |
38 |