Hello,
I have several questions and answers in Bookings that I would like to have answered in it's separate column in SharePoint however for now it spits out all of the questions/ answers in one column. How can I automate this for each question to land in its prospective column?
For instance it looks like:
<div class="ExternalClassF815EA085B944D0498744012"><p class="editor-paragraph"><strong>Case Name</strong>Shrek<br>
<strong>Case Number</strong>11525 <br>
<strong>Region</strong>5<br>
<strong>Who are the mental health concerns related to?</strong>Parent<br>
<strong>Was the child previously adopted?</strong>No<br>
<strong>Where is the child currently located?</strong>Adult Jail
<strong>Case Name</strong>Shrek<br>
<strong>Case Number</strong>11525 <br>
<strong>Region</strong>5<br>
<strong>Who are the mental health concerns related to?</strong>Parent<br>
<strong>Was the child previously adopted through DFPS?</strong>No<br>
<strong>Where is the child currently located?</strong>Adult Jail
</p></div>
