Others

How to Use a Dynamic Key Value in Power Automate

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to successfully pass a dynamic key value to retrieve a newly created row in Power Automate.

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Setting up a flow that adds a row from a form submission and immediately retrieves it using the newly generated unique ID.
Observed behavior: The flow fails at the 'Get a row' step because it receives a null or empty ID from the dynamic content, although manually entering a fixed ID works.

Before you start

Verify your flow run history to check the raw JSON outputs of the 'Add a row' action, ensuring that an ID is actually being generated before it is passed to the next step.

Solution 1Recommended

Seek Specialized Support from the Power Platform Community

Since dynamic ID generation issues can stem from specific data source connectors or flow configurations, consulting the Microsoft Power Platform Community is the most effective way to resolve this specific error.

Power Automate handles dynamic content differently depending on the connected data source (e.g., SharePoint, Dataverse, Excel Online). When a dynamic key value returns as null, it often requires inspecting the specific JSON schema of your flow.

The official Power Platform Community has dedicated experts who can analyze your flow's structure and provide targeted solutions for empty ID errors.

Gather your flow configuration details

Take screenshots of your current Power Automate flow in Edit mode. Make sure to expand the 'Add a row' and 'Get a row' actions so the dynamic content mapping is clearly visible.

Visit the Power Platform Community

Navigate to the official support forum thread designated for Power Automate workflow troubleshooting.

Post your issue and screenshots

Create a new reply or thread detailing that your dynamic ID is returning null. Attach your screenshots (blurring any sensitive information) so the community experts can identify the mapping error.

Official Community Link: You can post your flow details directly in the Microsoft Power Platform Community here: https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Spreadsheets and Data?

While Power Automate handles complex automated workflows for the Microsoft ecosystem, WPS Office provides a lightweight, highly compatible alternative for everyday document and spreadsheet management. If you want to manage data without the steep learning curve of advanced flow configurations, WPS Office is an excellent choice.

1. Visit the WPS Office website: Go to the official WPS website to access the free download for your operating system.
2. Install the software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
3. Open WPS Spreadsheet: Launch the application and open your existing Excel files to easily manage your data and forms.

Fully compatible with Microsoft Excel (.xlsx) and other Office formats.Lightweight application that runs smoothly on Windows, Mac, and Linux.Free alternative to Microsoft Office with a familiar, easy-to-use interface.Built-in robust spreadsheet functions for seamless data management without requiring complex automations.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the 'Get a row' action fail with an empty ID?

This typically happens when the dynamic content mapping references an output that hasn't been generated yet, or if the connection to the data source experiences a delay, causing the flow to read the newly generated ID as null.

Where do I find the dynamic content for a newly added row?

In the flow designer, click inside the ID field of your 'Get a row' action. A dynamic content menu will appear on the screen, allowing you to select the unique identifier output from the preceding 'Add a row' action.

How can I capture the dynamic ID immediately after creation?

You can use the 'Initialize variable' and 'Set variable' actions in Power Automate to capture and store the dynamic ID right after the row is created. You can then pass this variable directly into your 'Get a row' action to ensure the value is retained.

Office Quick Solutions