Dynamic Content not showing in Logic App

Dhaval Shah 20

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

1 answer

MayankBargali-MSFT 70,016 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.
Please sign in to rate this answer.
Dhaval Shah 20 Reputation points

2024-03-19T03:47:56.9066667+00:00

Yes. we already saved the workflow after executing the query task.
Main question is to not load dynamic content after saving. Is it possible to include multiple select statements in one query?

MayankBargali-MSFT 70,016 Reputation points

2024-03-19T11:05:03.8933333+00:00

@Dhaval Shah In scenario where the action doesn't return the same data type then the dynamic content will not be loaded. For example, if your action doesn't return the array of result then you cannot use the same in the property From in the action of Create CSV table. The same is documented here. Can you share what value you have specified in your SQL action along with the SQL query.

Is it possible to include multiple select statements in one query? Do you mean for the execute sql action. Can you write multiple select query? If my understanding is correct, then yes you can use multiple queries as below:

SELECT TOP 10 * from myTable1;

SELECT TOP 10 * from myTable2

The result will be in the ResultSets i.e. body('Execute_a_SQL_query_(V2)')?['resultsets'] and to get the result for the first query you need to use the body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1'] and to get the result for your second query you need to use body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table2']

The output will be different Table1, Table2, Table3 in the response as per the sql query that you have specified.

Dhaval Shah 20 Reputation points

2024-03-19T11:10:30.3433333+00:00

We are using the below SQL query.

SELECT NIFMembershipID, NextInvoiceDate, * FROM IMS_IndividualMembership WHERE Status = 2 AND MembershipStatus = 2 AND ContactID IN (SELECT ID FROM IMS_Contact WHERE Status = 8) AND NextInvoiceDate > GETDATE()

Dhaval Shah 20 Reputation points

2024-03-19T11:11:19.4066667+00:00

We are using the below SQL query.

SELECT NIFMembershipID, NextInvoiceDate, * FROM IMS_IndividualMembership WHERE Status = 2 AND MembershipStatus = 2 AND ContactID IN (SELECT ID FROM IMS_Contact WHERE Status = 8) AND NextInvoiceDate > GETDATE()

MayankBargali-MSFT 70,016 Reputation points

2024-03-19T11:41:16.41+00:00

@Dhaval Shah What is the output of the above SQL command? Is it a list of rows?

Can you also confirm if there is any add on or extension on your browser that would be blocking the request as the dynamic parameter is not show. You can try creating a test array and see if it shows under the dynamic option. As a workaround you can use the expression to unblock you for the time being.

Dhaval Shah 20 Reputation points

2024-03-19T11:45:24.0033333+00:00

Please find the below screenshot of output of SQL command.

As a workaround you can use the expression to unblock you for the time being. - > can you please guide me for that

MayankBargali-MSFT 70,016 Reputation points

2024-03-19T11:53:50.0966667+00:00

@Dhaval Shah Click on From configuration of Create CSV table now select the Expression and copy paste the below and click on OK. For more details on body please refer to this.

body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1']

Dhaval Shah 20 Reputation points

2024-03-19T11:56:07.6333333+00:00

Can I use this expression as condition also?

MayankBargali-MSFT 70,016 Reputation points

2024-03-19T11:58:52.8366667+00:00

@Dhaval Shah That's depend on what you are trying to achieve. If you want to count the number of rows and compare them with some value in condition, then yes. If you want a specific value, then you need to loop in through the value and get the individual values.

Dhaval Shah 20 Reputation points

2024-03-19T12:02:46.52+00:00

I want to achieve below things.

If no data is found after executing SQL query then it will send an email that no data found. (True condition)

2, If there is data, it creates a CSV file and sends an email with the attachment.(false condition)
Is it possible to achieve using the above solution provided?

MayankBargali-MSFT 70,016 Reputation points

2024-03-20T04:15:42.21+00:00

@Dhaval Shah Yes you can leverage the length function reference and compare with greater than zero in your condition

length(body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1'])

Dhaval Shah 20 Reputation points

2024-03-20T04:23:37.8733333+00:00

We have tried the above solutions and it's not working.
Showing below error.
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.

MayankBargali-MSFT 70,016 Reputation points

2024-03-21T10:46:56.1966667+00:00

@Dhaval Shah Looks like your execute a SQL command doesn't return any result.

You should also validate body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1'] is not equal to null and then length(body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1'])

is greater than 0

You can refer to my private comment so I can connect with you offline for quick assistance.

Archana Pereira 0 Reputation points

2024-04-15T18:52:20.3266667+00:00

@MayankBargali-MSFT

I have followed the above steps and still facing the same issue .

MayankBargali-MSFT 70,016 Reputation points

2024-04-16T06:42:20.38+00:00

@Dhaval Shah As discussed previously you can reach out to me offline to assist you further. Please refer to my private comment.
Sign in to comment

Share via

Dynamic Content not showing in Logic App

1 answer