
Announcements
Hi all,
I have pretty complex report making flow and this only part of it that I am having problem at the moment:
The problem I am struggling with is Frist table rows only returns values that are not null.
Value in Frist table row:
The same value in "rows":
As you can image when creating a csv this causes problem, mainly the columns are in different order or not present at all if there were no data in them this time.
My question is can I somehow directly feed the "rows" data the the create csv step ?
Sadly I cannot use parse Json because the columns returned in the result are dynamic.
Thanks for your help in advance!
Found it in the meantime, just writing it down so it may help someone else in the future:
outputs('Run_a_query_against_a_dataset')?['body/results']?[0]?['tables']?[0]?['rows']