Moving Files from SharePoint to ServiceNow via Microsoft Online Spoke

[BenjaminY]

Hello ServiceNow Community,

I’m working on a Flow Designer flow using the Microsoft Online Spoke to move files from SharePoint to ServiceNow. I have successfully set up access to the SharePoint folder and can retrieve files, but my challenge now is matching the "Pnumber" field in my custom ServiceNow table to the corresponding file title in SharePoint.
Once matched, attaching the correct file to the related ServiceNow record.
How would this flow be set up best?

****Edit, Files inside of folder all have different names is there a way to just grab any files within a folder.
Please advise, I have first time using spoke.

SharePoint files name example:
2023-PP-1234 John Doe 123456789

This name matches the custom table fields
Custom Table Field version
Pnumber                 Civilian First Name(firstName)    Civilian Last Name(lastName)     Znumber
2023-PP-1234                 John                                                     Doe                            123456789

[JenniferRah]

You can use the "Look Up Record" action to look up the record based on the Pnumber.

I'm not familiar with that spoke, but it looks like it has an "Attach SharePoint File To A Record" action that comes with it. You should be able use that to attach the file to the record.

[BenjaminY]

right, my problem is really extracting the files from the subfiles. Like stated previously, there are multiple folders that are titled same as some fields on the custom folder. I know there is a way to look through these folders and records on my custom field to match one another then extract every file within the matching folder. That is what I am requesting help with

[JenniferRah]

Thanks for the clarification and sorry I misunderstood the ask. Looking at the actions available in the spoke (https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/integrationhu...), it looks like there's one called "List Files in A Folder". Could you use that to get the list of files and then use the "Attach Sharepoint File To A Record" action to pull the file and add it to ServiceNow?

[AbigailSheridan]

You could use a lookup function in Flow Designer to match fields.