Multiple line of text column with rich text always triggers column change when Infopath form saved - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Multiple line of text column with rich text always triggers column change when Infopath form saved

Last post 02-16-2024 08:52 AM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 01-30-2024 07:15 AM

    Multiple line of text column with rich text always triggers column change when Infopath form saved

    I have an issue with Sharepoint list in combination with field of type "multiple lines of text" with enabled rich text and Infopath form. Data are edited through the linked Infopath form. When the multiline field is empty, it is just fine. But once I put any value to this field, it always triggers column changed when the form is saved. This happens every time I save the Infopath form. If I edit directly in grid view of the list, no change. This is visible in Version History, every save is there as a value change. It also triggers me Power Automate flows linked to column value changes. I even do not have this field directly placed in the Infopath form, just that it exists in the list and have some value, it always triggers column changed. Can somebody help? Thank you.
  • 02-16-2024 08:03 AM In reply to

    Re: Multiple line of text column with rich text always triggers column change when Infopath form saved

    Hi - sorry I'm so slow to notice this post. I don't have any experience with this. But I wonder - as a work around, have you tried in your Flow getting the actual prior version of the list item and just terminating the Flow if the Rich Text field in the prior version = the current value? I would probably use a couple of compose actions so I could manually take a look at the "before" and "after" data and see if I could see what is actually triggering the list to think there is a difference in the field.
    Hilary Stoupa

  • 02-16-2024 08:36 AM In reply to

    Re: Multiple line of text column with rich text always triggers column change when Infopath form saved

    Hi, thank you for your response. In fact, have not tried to physically compare the values. But because Sharepoint "thinks" it has been changed, it is very possible that Infopath form alters the value everytime I save the form. If the multiline field is without formatting, no changes are triggered. I had to use another workaround. Created another field, where I store unformatted value of the same, what I have in the rich text field. On this unformatted value I am am hooking the flow. And the rich text value I am using to show to the users. It works. But that problem is there still. I somebody is trying to go through the history of changes, he can see every time, that somebody changed the rich text comment. But nobody did. Not very nice...If this will be fixed sometimes (probably not any more), I will just remove the extra column and hook it back.
  • 02-16-2024 08:52 AM In reply to

    Re: Multiple line of text column with rich text always triggers column change when Infopath form saved

    Oh good plan. Since rich text is xhtml, it is very possible that there is a difference between the data submitted by InfoPath and the data stored in SharePoint. Sort of like when we upload a document with illegal chars, SharePoint will just change them to "_". I'm glad you found an approach that at least works, but yes, this does make version history messy for users to be sure.
    Hilary Stoupa

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.