cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
forstera
Helper III
Helper III

Null value detected but data ...

Hello all,

I've a question about my understanding 🙂

I make a REST API call to our database to retrieve some data. As the amount of data is important, I can't view them when having a look on my process. Instead of that, I've the option to 'Click to download the result' : 

forstera_0-1625060514287.png

If I click the link, i've plenty of data displayed : 

forstera_1-1625060595851.png

 

So, everything looks fine.

But when I'm trying to make a loop to 'Apply to each' element of my list, I get the following error : 

forstera_2-1625060711394.png

 

is it possible, because of this option 'click to download' that the result is empty ?

Thanks to all for your help

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

No, the click to download also shows when the data is too large to be displayed in the preview. In your example output you need to target "Result" which contains an array which you could do an apply to each action on.

You need something like:

body('JSON_ListeClasses')['Result']

 

 

View solution in original post

2 REPLIES 2
Paulie78
Super User
Super User

No, the click to download also shows when the data is too large to be displayed in the preview. In your example output you need to target "Result" which contains an array which you could do an apply to each action on.

You need something like:

body('JSON_ListeClasses')['Result']

 

 

View solution in original post

@Paulie78 Thanks very much .. I did not see that (I shouldnt trust the Dynamic content) ..

and it worked very fine the way you said 🙂

Thanks very much

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,511)