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.
