I need to get one drive Microsoft excel data, when i change the status ( done ) in column b through Api call

How To
1

i need to get one drive Microsoft excel data, when I change the status ( done ) in column B, through Api call or if it is possible directly on make modules , how can I do? I tried but there is no option for that ,any help will be much apricated

2

I would suggest you implement the following logic:

  1. add one more extra column into the Sheet that would contain info if that row was already processed via the Make scenario - for example, column “Make”
  2. use in the scenario as a trigger module the “List Table Rows” module.
  3. set up behind this module a filter that column B must be “done” and the column “Make” is empty.
  4. use the data in the scenario as you need.
  5. add into the scenario “Update a Table Column” module to update the column “Make” for the row that passed the filter. (Enter there e.g. value “Yes”).
2 Likes