cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdoerman
New Member

Listing Appended Changes from Sharepoint List on PowerApps

I've created a PowerApp that show information from a Sharepoint list.  One of the columns in my list has "append changes" active which means we can basically track changes each time this field is edited.  This is helpful because we use it as a comment sections for the item that a user can read the changes as if they were comments.

 

However, in PowerApps on an item detail screen it only lists the most recent entry (from a PowerApps template) and doesn't append the changes.  Is there any way to do this where it shows all the changes (just as plan text) that user can scroll through?

 

Thanks,

41 REPLIES 41
Anonymous
Not applicable

@systemcrash it would be interesting to see your solution as well and much appreciated a tutorial. 

@systemcrash I would also appreciate a tutorial as I don't need approvals for my solution so if I can keep it all within PowerApps that would be fabulous. Thank you in advance!

Hi,

I'm also excited to see your solution, @systemcrash 🙂 I'm quite new to PowerApps & Flow as well, so hoping to learn more here. If we cannot get the append changes type of comment box to work, we probably need to get rid of PowerApps and go back to basic sharepoint forms...

martinav
Community Champion
Community Champion

@zeippu, I definitely feel your frustration. Despite the struggles with Powerapps, there are some very nice benefits. Its the only system I have ever seen that connects so many different sources, and present them in a format that can be done on a PC, phone, or basically any device. Dont bail on it too quickly. The forums are the best help, so post for as many questions as you need, and I bet you will resolved almost all of your issues. Regards.

Sorry everyone, I was on vacation... but you know it's better later than never. I'll try to ELI5 this as much as I can. Our objective is to get something similar to an SPL field with append changes on. This involve two things : 1- NOT using a SPL field with append changes turned on 2- consider to discard your previous entries with SPL field with append changes turned on. How do you do it? Before you submit your form you need to store some information in variables. UpdateContext({StringToLog: PowerappsNewEntry.Text}); UpdateContext({StringOldLog: PowerappsHistotic.Text}); SubmitForm(EditForm1); After you submited your form, you need to do some manipulation for to store the new entry in your SPL with patch function. If( !IsBlank(StringOldLog), Patch( YourSPLName, EditForm1.LastSubmit, {AppendChangesString: User().FullName & "@" & Now() & " : " & StringToLog & Char(13) & StringOldLog & " "} ), Patch( YourSPLName, EditForm1.LastSubmit, {AppendChangesString: User().FullName & "@" & Now() & " : " & StringToLog & Char(13) & " "} ) ); Here's the variable breakdown : StringToLog = variable that store the new entry. In this case, it's a text box I named PowerappsNewEntry, where the user will input a text. StringOldLog = variable that store the previous entry. In this case, it's a text box I named PowerappsHistotic which contain previous update. The info come from SPL. Feel free to ask any question.

Good god... what happen to my formating 😞 I'll try to repost later... maybe it's chrome

Something weird is happeining in Chrome.  I cant even see the forum screen any more.  Plus, the toolbar does not come up.

Anonymous
Not applicable

Working for me in Chrome. Have you tried deleting history and cache yet? Sometimes the cache is wierd for me in Chrome even after multiple page refreshes with PowerApps but that is another topic. I have to either use another browser or delete history and cache to restore to latest version of PowerApps. 

This is the 3rd time I'm writing my proposed solution inspired by @martinav.  first time the forum RTE messed up the formating really hard.  2nd time I completed my message but Edge gave me an error related to cookies.... so I'm writing this on good old IE.
 
I'll try to ELI5 this as much as I can.


Our objective is to get something similar to an SPL field with append changes on  to follow logs and change on a string frield from an SharePoint List (SPL).


This involve two things :
1- Using a SPL string field with append changes turned OFF
2- Consider to discard your previous entries with SPL field with append changes

 

How do you do it?

 

Before you submit your form you need to store some information in variables.
UpdateContext({StringToLog: PowerappsNewEntry.Text});

UpdateContext({StringOldLog: PowerappsHistotic.Text});

SubmitForm(EditForm1);


After you submited your form, you need to do some manipulation  to store the new entry in your SPL with patch function.


If(
    !IsBlank(StringOldLog),
    Patch(
        YourSPLName,
        EditForm1.LastSubmit,
        {AppendChangesString: User().FullName & "@" & Now() & " : " & StringToLog & Char(13) & StringOldLog & " "}
    ),
    Patch(
        YourSPLName,
        EditForm1.LastSubmit,
        {AppendChangesString: User().FullName & "@" & Now() & " : " & StringToLog & Char(13) & " "}
    )
);
 
Here's the variable breakdown :
StringToLog = variable that store the new entry. In this case, it's a text box I named PowerappsNewEntry, where the user will input a text.
StringOldLog = variable that store the previous entry. In this case, it's a text box I named PowerappsHistotic which contain previous update. The info come from SPL.
EditForm1 = the form that contain your inputbox and it's connected to your SPL.


Feel free to ask any questions, comments or any recommendation to make the solution better. 😉

 

Sorry if my english sounds a bit off... I'm french canadian.

Yea, whats going on with the interface here?  Chrome give me black screen and nonesence, and edge doesnt even show me the formatting toolbar.  Also, no more pasting the clipboard into the photo editor.  That makes it a p.i.t.a. to post photos.  I'll post a new message on this.

 

https://powerusers.microsoft.com/t5/General-Discussion/Whats-happeining-to-the-forum-editor/m-p/2014...

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,282)