topic Publish Sheet Block not working in Qlik Automate

Publish Sheet Block not working

Meghann_MacDonald — Wed, 08 Dec 2021 19:20:21 GMT

Hi all, running an automation to publish all sheets and then publish app whenever a new app is created in my space, please see the screenshot:

The automation successfully gets the app id I need, lists out all the correct sheet ids (unpublished sheets), and then DOESN'T successfully publish the sheets. The steps after that work - publishing the app to a managed space. As of now it publishes a blank app because the sheets don't get published. Can anyone help with this or is the block not working properly?

Re: Publish Sheet Block not working

T-Lambourne — Wed, 08 Dec 2021 19:59:00 GMT

Could you share the editor diagram?

You might already have it this way but my first thought is that the Publish sheet should be a part of the List sheets block (See below).

Re: Publish Sheet Block not working

Meghann_MacDonald — Wed, 08 Dec 2021 20:01:11 GMT

Yes, I do have that set up in the same way.

Re: Publish Sheet Block not working

T-Lambourne — Thu, 09 Dec 2021 14:34:26 GMT

I tried building it on my end as I was wanting something like this also. I received the same erroneous result. It seems to be b bug in the Publish Sheet block. Hopefully Qlik will resolve it soon.

If you do find resolution please post it here so I can get it also.

Thanks

Re: Publish Sheet Block not working

Meghann_MacDonald — Fri, 24 Dec 2021 16:20:06 GMT

Hi @T-Lambourne , the Qlik team was able to identify my issue.

My Publish sheet block was publishing a list of sheets rather than the id, which wasn't going to work. This is the correct way:

As you can see we also changed around the automation a bit for a better result, which ran and published sheets successfully! Let me know if it works for you

Meghann