Unanswered

PowerApps Show multiline value

(0) Share

Report

Posted on by ctedesco3307

699

Hi All - I know PowerApps is funky with SharePoint multiline appended text fields ... Ideally I'd like to show all the appended notes - but I know that's not OOB -- my more important issue is .....

I can enter a new value into that field and save it thru Power Apps - works fine where I see the last entry I made - but my problem is if I submit the form again - updating a different field - no this multiline one -- when I go back into it the last entry doesn't display anymore. Is there a way to always see at least just the last one?

I tried these 2 options - no go

First(Split(ThisItem.ClarificationNotes, Char(10))).Result
FormCustomer.LastSubmit.ClarificationNotes

Thx in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@ctedesco3307

Add a new multiline text field to your SharePoint list. Call it NotesHistory

Set the Update property of NotesHistory to

ThisItem.NotesHistory & " " & DataCardValue7.Text // where DataCardValue7.Text is the ClarificationNotes textbox, not the one in the NotesHistory card!

Set the DisplayProperty of the NotesHistory card to Disabled to prevent users from changing the history

Bells and Whistles to Identify the time and date of the comment change:

ThisItem.NotesHistory & Char(10) &
"Note Date: " & Text(Now(), ShortDate) & Char(10) &
DataCardValue7.Text

Was this reply helpful? Yes No
ctedesco3307 699 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp - thanks for the tip!! - it almost works but every time i submit the form that last value entered keeps appending on over and over again is there a way to stop that and just shoe the last value entered?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ctedesco3307

Please read my instructions again. You need a separate multiline NoteHistory column in SharePoint different from the multiline ClarificationNote column. The DataCardValue mentioned in the Update property of the NoteHistory card refers to the textbox in the ClarificationNote card. not the one in the NoteHistory. The NoteHistory card should have a DisplayMode property of Disabled.

From your screenshot, it doesn't appear that you did any of these things.

Was this reply helpful? Yes No
ctedesco3307 699 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp I don't know what screen shot you are looking at but I clearly DID all of those things. You can clearly see the ClarificationNotes field and the NotesHistory field being separate on the form. The SharePoint screenshot only shows how the values from ClarificationNotes are appended. Please read my response again.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ctedesco3307

Sorry if I misunderstood but please post the name of the textbox control in the ClarificationNotes card, the name of the textbox control in the NotesHistory card and the Update property of the NotesHistory card.

Is the ClarificationNotes card where the user puts in his notes?

Was this reply helpful? Yes No
ctedesco3307 699 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
No problem. I actually got what I needed though flow to see all the version history entries, but to answer your question - DataCardvalue35 is my ClarificationNotes field - in my original example it was DataCardValue7, I can see where the confusion came in. I recreated the form.

Was this reply helpful? Yes No