How to build a auto-search system in a particular inhouse database on Make.com?

Questions
1

:bullseye: What is your goal?

I want to build a workflow that it can help me to search items from my excel database, and output tell me what the items belong to what category.

:thinking: What is the problem & what have you tried?

I have no idea with module to be able for me to do the searching process. Hope anyone here can inspire me.

Thanks a lot!

2

Hello @FH,

If you search “Excel” you’ll get at least these two options for working with Excel files

image
image546×232 13.8 KB

3

Welcome to the Make community!

Unfortunately, MS 365 Excel does not have a “Search Rows” module.

See if such an endpoint exist in the Microsoft Excel Developer API reference. If it exists, you can integrate the endpoint in Make using the app’s universal module (Make an API call) or generic HTTP “Make a request” module.

I’m sure others will agree that a “Search Rows” module for MS 365 Excel would be nice to have too!

If this is important to you, please submit this suggestion to the Idea exchange, under App Improvement Ideas. However, do search for a similar request first (and also upvote), just in case it has already been suggested to avoid duplicates.

Alternatively, you can use the Google Sheets “Search Rows” module —

Returns results matching the given criteria.

For more information about the “Search Rows” module and Google Sheets app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew