Power Platform Community Forum Thread Details

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!

Categories:

Building flows