SharePoint has no record/it produces no data

Question

I have a flow that extracts data from SP.  When there is data, there is no issue, but when there is no data, it cannot produce a table.  How can I trick Alteryx to do so?  Note: I cannot add a dummy row in SP.

Imaizumi · Answer

Have you tried using control containers with a filter tool?

So for the true filer to control container, you place your Table and Report Header.

In your false filter, inside the control container place a text tool to create a dummy table with Table And Report Header.

Please take a look to get an idea.

Tool Mastery | Control Container - Alteryx Community

Dean4U · Answer

Hi @YUICHIFUJISHIMA,

Thanks for reaching out to the Community. Please make sure your SharePoint tools are up to date. Could you clarify a bit further? Does the SharePoint input return 0 rows with a schema or no schema at all? Also, please check the connections/authentications setup to see if it is part of the issue.

Please check out the links below for help:

SharePoint & Alteryx Guide

Data Connection Manager

Also, here's a post from a user who faced a similar concern while using the SharePoint tool, as it covers a similar SharePoint no-data behavior.

Hope this helps.

Take care.