I have around 500 lines in my excel file.
I am using the excel module “list work sheet row” on make and I would like a module that returns my the row ID of a specific line (to be precise I would like the row ID of the line with the name “Nicolas Durand”)
Can you help on that ?
You can add a filter on the dotted line immediately after this module, so that only the bundle containing the row you want is allowed to reach the next module.
For more information about filters, see https://www.make.com/en/help/scenarios/filtering
If you need more help,
Please provide the output bundles of the module by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a
bundle.json file, and upload it here into this discussion thread:
This will allow others to better assist you. Thanks!
Thanks, the filter is not working since I want to retrieve the row ID of a specific excel line (all the date is inside the excel file)
To rephrase it, I have my excel file with 500 lines.
I need to get the value of the row ID with a specific property (in my case I need the row ID value of the line which has in column A the value “Nicolas Durand” for instance)
I need to be able to use the value of this row ID in the next module so the filter would not work since I need to value
I could not save it as Json but I put everything in word file
Can you let me know about this situation ?
I have client where I try to implement your solution make and I need to answer this.
When you List Worksheet Rows, the output bundles each contain the Row ID and bundle order position. The first row returned is the first bundle and the row ID is 2 (because the first row is headers and not included).
When you set up a filter after the Excel module, the entire bundle will be sent to the next module if it is filtered through. In the next module, you can get the Row ID from the bundle.