Howdy,
So I have an excel file with a few hundred rows and a bunch of columns.
Its being synced to a third party vendor every two hours and my question is how to do this in the most effective way.
I created a simple "List rows present in a table" and then just updated rows in the target file.
I guess this will push/overwrite the data in the target file even if its already the same value?
Is there a good method I can apply that checks whether or not the value in the target file is the same, then skip. if not the same then it should update/overwrite?
I guess this will be more efficient and could save both resources and time - but my idea is also that if a value in some of the columns are updated it should be published in a Teams chat as well.
thanks!


Report
All responses (
Answers (