Skip to main content

Notifications

Power Apps - AI Builder
Unanswered

Extract Name and Date of Birth from unstructured and semi-structured data in sharepoint list

(0) ShareShare
ReportReport
Posted on by

I have input data in a sharepoint list like the first table below.

CASE IDNAMEDOB
12345Jane DoeThis is the date of birth 01/02/22 isn't it
23456Jane L. DoeLook at the fox 1/02/2022 it jumps
45678Jane L DoeHelp me with this data 1/2/22
56789Jane Louise Doe01/2/22 etc etcetera
67890Doe, Jane L IVi love football
78901Jane Doe AKA Janeous Doe NKA John Doethe beautiful sport

 

From the data above, I am trying to extract the following entities into the same sharepoint list or a different list, file, etc.

CASE IDFirst NameMiddle NameLast NameSuffixMonthDayYear
12345Jane Doe 01022022
23456JaneLDoe 01022022
45678JaneLDoe 01022022
56789JaneLouiseDoe 01022022
67890JaneLDoeIV   
78901Jane Doe    

 

I have been able to achieve this with Syntex where each record is on separate structured PDF files. I can't figure out how to use each sharepoint list row as a separate input.

 

Thanks so much for your help!

 

Categories:
  • CedrickB Profile Picture
    CedrickB on at
    Re: Extract Name and Date of Birth from unstructured and semi-structured data in sharepoint list

    If you use Power Automate, you can use this connector to list the items of your list 

    CedrickB_0-1653295579203.png

     

    Then either, use the Ai Builder prebuilt entity extraction model https://docs.microsoft.com/en-us/ai-builder/prebuilt-entity-extraction to get the name and date, finally apply some text function to split it.

     

    Alternatively, you can build a custom entity extraction model to directly extract the name, first name, day, month and year with https://docs.microsoft.com/en-us/ai-builder/entity-extraction-overview 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard