Question:I wish to expand a table that contains data from an invoked column pulling data from the web.
The issue is that not every row finds a desired result on the web and returns an error. Although I don’t mind the result failing for this row it causes an issue when trying to expand the table because the table relies on all rows having the same captured headers for the expansion.
Below is an image showing the errors and the result of the expansion.
My desired output is simply the same expansion but rows with errors just appear empty in the expanded section.
Answer:You just replace errors with null before your expansion.
If you have better answer, please add a comment about this, thank you!