Answered

Error in Gallery Note Field

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Phineas ,

I feel you added extra closing bracket at char(13).

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Phineas

I have noticed that you may forget a bracket for the If function at the end of the formula:

Best regards,
Sylvia

Was this reply helpful? Yes No