Forum Discussion
Solved
If There is No Data, Continue
Hello I am pulling price information from companies; if there is no data for the company, it throws an error and does not proceed. When it encounters an error, can it continue and move on to the nex...
#"Özel İşlev Çağrıldı" = Table.AddColumn(#"Kaldırılan Sütunlar", "Fiyat Fonksiyon", each try #"Fiyat Fonksiyon (2)"([Kod]) otherwise #table({"Column1.HGDG_TARIH", "Column1.HGDG_KAPANIS", "Column1.DOLAR_BAZLI_FIYAT", "Column1.HGDG_HACIM"},{})),
1. read about try ... otherwise
2. familiarize yourself with manual status handling in Web.Contents
3. Power Query MUST return something that looks like a table. Add a blank table to your query flow as a placeholder.