Unanswered

NO DYNAMIC CONTENT AVAILABLE - SQL Stored procedure

(2) Share

Report

Posted on by EJ-07080649-0

106

This is an old and returning issue that have returned. PowerAutomate is no longer finding a dynamic content from the SQL Stored Procedure. Any advice how this can be solved? It has worked perfectly before.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you able to show screenshots of your current flow, how you've configured your action, and then showing what you see in a "Compose" under the dynamic content options?

Have you tried using a Parse JSON on the output from the procedure? Or is that not even available?

Was this reply helpful? Yes No
JairoGarcia 9 on at

Like (0)

Report
Copy link

Link copied!

I have the same problem, when loading an action with everything required to execute a stored procedure, obtaining the parameters from the suggestions made by the "Execute stored procedure (V2)" control, where it is guaranteed that there is a connection to the database. data, which is reading the procedures contained in the database, completing the required parameters; In the end, the dynamic content associated with the action is not being loaded.

I test by loading all the records of a table and that does generate the dynamic content, but the call to the stored procedure does not create the calls to the fields dynamically.

Was this reply helpful? Yes No
EJ-07080649-0 106 on at

Like (1)

Report
Copy link

Link copied!

It seems like this unstability is not uncommen problem with PowerApps in different areas (PowerAutomate call do not function anymore and needs to be recreated, settings in Graph). This may be an error by design, but its anoying and one need to check the app from time to time just to be sure that everything works.

Was this reply helpful? Yes No