Announcements
I have Gallery1 in which I am attempting to create a 'Notes' input.I would like each not appended to the SharePoint list to lead with the user's full name and the date/time the note was appended.I am getting and error at the end of my formula; It doesn't like the last ampersand for some reason.The note above red error circle are the existing notes coming in from the data source to which I am attempting to append the new note. Every note 'item' should include the name, date/time, and note content in order of creation.
Hi @Phineas ,
I feel you added extra closing bracket at char(13).
I removed the second bracket. The error now as shown below, and appears after the ThisItem.Client_Notes. Adding a bracket at the end does not correct the error.- "Unexpected characters. The formula contains 'EoF' where 'ParenClose' is expected."If(IsBlank(Client_Detail_New_Note_Fld.Text),User().FullName &" "& Now() &" "& Client_Detail_New_Note_Fld.Text & Char(13) & ThisItem.Client_Notes
Hi @Phineas
I have noticed that you may forget a bracket for the If function at the end of the formula:
Best regards,
Sylvia
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 551
WarrenBelz 430 Most Valuable Professional
Valantis 298