You’re offline. This is a read only version of the page.
Share
Report
All responses (
Answers (
xpath(
xml(outputs('Compose')),
'//body/*/DT_RowId/text()'
)outputs('Compose')['body'][item()]It looks like the issue comes from the dynamic keys in your JSON response. Since the outermost keys (16126468098270, 16126468436010, etc.) are always changing, a normal Select action won't work directly because it expects fixed properties.
The best way to handle this in Power Automate is to first use Parse JSON on the HTTP response. Then, instead of referencing specific keys, loop through the JSON dynamically. You can do this with an Apply to each, setting the input to json(outputs('Parse_JSON')). Inside the loop, use expressions like item()?['amount'], item()?['cardId'], and so on to extract the values properly.
If Select is returning null, it's likely because it's trying to find fixed property names that don’t exist. Converting the JSON object into an array before processing will help fix this. Try using an expression like json() to transform the data, and you should start seeing the actual values instead of null.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
