Create HTML FROM ARRAY ITEMS INSIDE AN ARRAY

%3CLINGO-SUB%20id%3D%22lingo-sub-2427293%22%20slang%3D%22en-US%22%3ECreate%20HTML%20FROM%20ARRAY%20ITEMS%20INSIDE%20AN%20ARRAY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427293%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20convert%20items%20inside%20array%20which%20is%20an%20array%20to%20action%20create%20html.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esample%20data%3A%3C%2FP%3E%3CP%3E%5B%5Bname%2C%20quantity%2C%20stock%5D%2C%20%5Bpen%2C%200%2C%200%2C%200%5D%2C%20%5Bbag%2C%200%2C%200%2C0%20%5D%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ename%20quantity%20and%20stock%20are%20column%20values.%20The%20rest%20of%20the%20arrays%20are%20row%20values.%20The%20example%20is%20somewhat%20similar%20when%20you%20requested%20to%20MSGraphAPI%20using%20Range%20address%20from%20an%20excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eerror%26nbsp%3BThe%20property%20'columns'%20must%20be%20specified%20unless%20the%20'from'%20property%20value%20is%20an%20array%20of%20objects.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20knows%20how%20to%20solve%20this%20issue%3F%20Thanks%20in%20advance.%3C%2FP%3E%3CP%3Eyou%20can%20use%20this%20url%20for%20testing%20and%20look%20for%20the%20json%20response%20key%20named%20values%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fme%2Fdrive%2Fitems%2F01BYE5RZZ5OJSCSRM6BZDY7ZEFZ3NJ2QAY%2Fworkbook%2Fworksheets('Sheet1')%2FusedRange%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fme%2Fdrive%2Fitems%2F01BYE5RZZ5OJSCSRM6BZDY7ZEFZ3NJ2QAY%2Fworkbook%2Fworksheets('Sheet1')%2FusedRange%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2427293%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

How to convert items inside array which is an array to action create html.

 

 

sample data:

[[name, quantity, stock], [pen, 0, 0, 0], [bag, 0, 0,0 ]]

 

name quantity and stock are column values. The rest of the arrays are row values. The example is somewhat similar when you requested to MSGraphAPI using Range address from an excel

 

error The property 'columns' must be specified unless the 'from' property value is an array of objects.

 

Anyone knows how to solve this issue? Thanks in advance.

you can use this url for testing and look for the json response key named values

https://graph.microsoft.com/v1.0/me/drive/items/01BYE5RZZ5OJSCSRM6BZDY7ZEFZ3NJ2QAY/workbook/workshee...

 

0 Replies