Power Platform Community Forum Thread Details

Hi,

I finally got my sync between two excel files with the help from the forum:

https://powerusers.microsoft.com/t5/Building-Flows/Copy-excel-content-to-another-excel-file-and-skip-cell-if-data/m-p/1948398#M214588

The issue I now have is that once in a while we add new rows in the source file.

1) sometimes we don't add the key value until a day later and that will generate errors

2) sometimes we have the key value but its not added to the target file and that will generate errors

With this in mind it will generate errors and the flow gets disabled after 2-3 days.

Question 1: How can I add a feature that skips rows that have no key value. (they are empty) is it a simple select? and do I put this in the beginning or just before the update part inte example link above?

Question 2: How can i skip errors if the key value is present in the source file but not in the target file? We must manually add the key value to the target file and then it is approved to automatically sync the columns we have decided.

Thanks!

Categories:

Building flows