Read excel table, extract data and approval

[wsolano1989]

Hello,

I hope someone with more knowledge than me in PowerAutomate can give me a hand. I have a SharePoint folder where one team will upload excel files containing business proposals. The goal is to read information from a couple of tables in that excel and start and approval flow however; I am having issues getting it to work.

Here is what I have so far.

Output of the GetAMDetails

[

{

"@odata.etag": "",

"ItemInternalId": "4cba16c8-b71c-474e-8013-dcf9fd78e3d9",

"Pre-Sales Engineer": "abc@abc.com",

"Account Manager": "abc@abc.com",

"Application Date": "",

"Version": ""

}

]

So I know I am getting the information, I try using a Parse JSON to get the values out of the response to be able to use it.

Here is the structure that I set

{

"type": "array",

"properties": {

"@@odata.etag": {

"type": "string"

},

"ItemInternalId": {

"type": "string"

},

"Country": {

"type": "string"

},

"Client Company Name": {

"type": "string"

},

"Client Contact Name": {

"type": "string"

},

"Opportunity Name": {

"type": "string"

},

"Opportunity ID (CRM)": {

"type": "string"

}

}

}

But this isn't working is not giving me access to each individual item in the JSON respose.

[tom_riha]

Hello @wsolano1989 ,

you don't need the 'Parse JSON' action, Power Automate should automatically convert all the columns from the Excel table into dynamic contents. Just select the right dynamic content to access the value. It'll add 'Apply to each' automatically but that's fine as it wants to process all the rows one by one in a loop.

[Shujaath_Khan]

Hi @wsolano1989 

like @tom_riha mentioned , you already have access to individual excel column names like you tried to use value. whereas value contains a list of all excel data.

in fact instead of value scroll a bit further and you shall be able to find Pre-Sales Engineer, Account Engineer  as well.

something like below

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[wsolano1989]

Here is what the dynamic content is showing me, so that is why I was trying with the parse because for some reason is not giving me the columns 

[Shujaath_Khan]

Hi @wsolano1989 

Hope you've formatted content as tables in Excel and selected the tables when doing list rows action

[wsolano1989]

Correct here are the screenshoots

[Shujaath_Khan]

Can you select table names from drop down instead of expression

[wsolano1989]

That will be an option if the file names are not dynamic. I don't know what the name of the file will be, I know the format it is the same, but the files will change every time so I am getting the file name from the SharePoint dynamic content 

[Shujaath_Khan]

Hi @wsolano1989 

Then what's you've done using parse JSON is correct and below parse Json use apply to each action so you can do iteration over all the items you get array

Thanks