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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,458)