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

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

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!

 

1 REPLY 1
CedrickB
Power Apps
Power Apps

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 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,182)