Unanswered

Unable to fetch data from report to excel sheet

(0) Share

Report

Posted on by Vanita123

I have created a power automate flow. Step 1: created a flow to send out mail to employees based on trigger date mentioned in the data source file to complete the assigned training. Step 2: created a flow to pull a training completion report from LMS site by using API link. Training report will have status of the training. Step 3- Flow is created to send out reminder mail to employees where the training status is blank. I am getting stuck at the flow 2 where data is getting pulled only in one column. Kindly refer the screenshot of the flow for reference.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Srini007 3,451 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @Vanita123

From the above screenshot what I understood is that you are calling a api and parsing the json and adding the row to excel. But not clear that what type of response you are getting and how you are adding that info to excel sheet

Because without knowing the response and required output it's very difficult to understand your issue

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
Vanita123 2 on at

Like (0)

Report
Copy link

Link copied!

Hello,

report has total 6 columns but when i am adding a row into a table data is getting fetched only in first column.

i am using below schema for parse Json
{
"type": "array",
"items": {
"type": "object",
"properties": {
"First": {
"type": "string"
},
"Last": {
"type": "string"
},
"Email": {
"type": "string"
},
"Course": {
"type": "string"
},
"Attempt": {
"type": "string"
},
"Status": {
"type": "string"
},
"Date": {
"type": "string"
}
},
"required": [
"First",
"Last",
"Email",
"Course",
"Attempt",
"Status",
"Date"
]
}
}

so ideally data should reflect under all column headers but i am getting data only under "First" header

Was this reply helpful? Yes No