- The article discusses a SharePoint integration involving multiple subfolders within a parent folder for file management.
- Files are dropped into specific subfolders representing customer numbers, triggering the creation of corresponding documents in D365FO.
- The flow starts with the trigger 'When the file is created or modified' using the SharePoint connector.
- Metadata for the file is retrieved using the 'Get file properties' function, including details like ID, modified date, editor information, and file path.
- The URL of the file is obtained using the 'Link' property response from the 'Get file properties' action.
- The folder path is extracted using the metadata property 'Path' and split into an array using the 'split' function with the delimiter '/'.
- The customer number, located in the fifth column of the split array, is extracted using the outputs function.
- The flow progresses to create an attachment for the identified customer based on the extracted customer number from the folder path.
Registered users can view the full text for FREE!
Sign In Now!