Dynamic Content not showing in Logic App

Dhaval Shah 20 Reputation points
2024-03-18T08:30:19.11+00:00

Hello,

We have created the Logic App to execute SQL query on the database. dynamic content are not showing which we are using for specifying the condition for sending responses on the email.
Please find the below snapshot for reference.
User's image

Can you please help me for this

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,825 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 68,066 Reputation points
    2024-03-19T03:41:39.0033333+00:00

    @Dhaval Shah Thanks for reaching out.

    Make sure you are saving the workflow once you have created and configure the Execute a SQL query (V2) action. Now when you add the Create CSV table action you should see the dynamic content.

    If you are not saving your workflow then you could observe the issue that you have mentioned. I was able to reproduce the issue if I am not saving my workflow. In that case you need to manually type the expression as body('Execute_a_SQL_query_(V2)')?['resultsets']

    Let me know if you need any assistance.

    Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.