Importing SharePoint files to existing records on custom table

[BenjaminY]

I am trying to create a one-time flow in ServiceNow Flow Designer that imports files from SharePoint Online and attaches them to existing records in a custom table. The files stored in SharePoint have names formatted like:

Example File Name in SharePoint:
2023-CP-001 Doe John (111222333).pdf

These should be matched to records in ServiceNow based on multiple fields:

• Number: 2023-CP-001
• Last Name: Doe
• First Name: John
• a number: 111222333

What I Have Done So Far:

1. The Microsoft SharePoint Online spoke is installed and connected in ServiceNow.
   
   Please Advise!

[jcmings]

How are you distinguishing between users that have the same first and last name?

[BenjaminY]

Hello,

As in the example the SharePoint number will have something like " 2023-CP-012" which can differentiate between all other records. Which will mirror the record on the custom table record number field

[jcmings]

Can you share a screenshot of your flow? I'm curious to see what you've tried so far.