
Announcements
Hi Community,
I really need your help.
1. Excel files with different names are in a folder in SharePoint
2. The excel file I want to merge has the name 'ScoreXXX'.
3. The columns in the excel file I want to merge are the same, but the table names are different.
4. In this situation, please tell me how to merge the tables by using the name filter using "Get files (properties only)" action rather than importing each table individually.
I even managed to filter the names of files by using this function in Filter Query.
*Acquiring and integrating each Excel Table in this way has already been successful.
Best Regards,