
Announcements
I have a flow that grabs the users from the Graph API each day - at first i was having issues with the data types and so removed the businessPhone section as this wasn't needed. The flow then proceeded past the the Parse Json and on to the Create CSV Table where i get the following error.
BadRequest
Hi @nathant,
A parse json would not be necessary in this case. You could use the value property of the outputs of your HTTP request directly in the Create CSV Table. In addition to that you can also use a $select query parameter to only retrieve certain fields (and for example ignore the businessPhones field, if you don't want to retrieve this).
Below is an example
1. The Graph API URI with a $select
https://graph.microsoft.com/v1.0/users?$select=displayName,mail,id
2. The outputs with an expression directly in the Create CSV table action
outputs('HTTP')?['body']['value']