Hello guys😊 I have SP list with a lot of columns, the most important columns is "Status" and "Contract #". Column "Status" obtains only 3 options: In progress, Not passed, Passed ( viz photo):
Column "Contract #" is primary key, which obtains unique numbers of contracts (viz photo):
Excel file have the same columns as my SP list. But I don't need to download all information from SP list to my excel file. I need only information where Status is Passed. If status is passed, check if this contract # is already exists in excel file( if yes just update row in excel, if no create row with this contract # from SP list to excel file).
Thank you, I am waiting for your answers😊
