Power Platform Community Forum Thread Details

Retrieve data from a table of a recently created excel

It is known, that for retrieving data from a recently created excel there are numerous work arounds that arent part of the out of the box solutions but they work, in my case I use "Initialize variable option" and put the file ID in the value section.

When applying for each row, it actually retrieves the values for all the rows ¡

The problem is when trying to Add a row to another table in an Excel in other Sharepoint the outputed value goes like this:

{"@odata.context":" h t t p s://excelonline-wus.azconn-wus.p.azurewebsites.net/$metadata#drives('b%21udymwjQ6NECRJbcweLGLdKNyuruCU45LupSUNMLyeEbPBypd6fqiRoSmNw3-4urE')/Files('01V3SQAAZNYUUJCX4UMRDYW7WNQKOBINKN')/Tables('Tabla1')/items","value":[{"@odata.etag":"","ItemInternalId":"a4f6a1de-1d80-4c3e-b486-4418b436cb7a","Campo1":"50","Campo2":"100"}]}

The real values are the las integers, for column 1 is 50 and for column 2 is 100, How can I retrieve the values from the original table ? Of course in a normal case you could just link the column names, but because this is dynamic you cannot retrieve the column names so you need to find workarounds, any ideas why im getting the output like that ? thanks a lot ¡

Quick Links