Answered

Exporting Approval Data

(0) Share

Report

Posted on by spike8136

Hi All,

I'm wanting to export the data from an Approval flow. I'd like to see the names, choices (Accept/Decline) and any comments. Without being able to get the data, the whole process seems senseless.

I'd appreciate any help.

Thanks, Martyn

All responses (5)

Answers (1)

arimah 2 on at

Like (0)

Report

Re: Exporting Approval Data

Hi RobElliot, Thanks for this work back in 2019. I'm currently working on creating this SharePoint list with approvals and rejections. It appears a few items have been updated in Power Automate, any chance you could show a another screenshot in the new Power Automate with this same flow?

Also, this flow only demonstrates the approvals and rejections instigated by ONE person, correct? Would I need to create multiple flows for each person's approvals and can they all migrate to the same SharePoint list?
spike8136 13 on at

Like (0)

Report

Re: Exporting Approval Data

Hi Rob,

Would you be so kind as to clarify part of the 'Update Item' stage?

I can't work out where in the stage it knows where to push the output values to. Should it go to an Excel file or a new list? If Excel, I'm assuming I have to create it first with matching columns?

Regards
Martyn
spike8136 13 on at

Like (0)

Report

Re: Exporting Approval Data

Hi Rob,

Many thanks for taking the time to send me your suggested solution - it is very much appreciated.

Best wishes,
Martyn
Verified answer

v-alzhan-msft on at

Like (1)

Report

Re: Exporting Approval Data

Hi @spike8136 ,

Have your problem be solved according to @RobElliott 's solution? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
If no, please share more details about your problem and we would try to provide a proper workaround for you.

Best Regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RobElliott 10,118 Super User 2025 Season 1 on at

Like (0)

Report

Re: Exporting Approval Data

Hi @spike8136 you can either save the approval decision, date, approver name and any comments to columns for the relevant item in the SharePoint list which you could then export to Excel for further analysis. Or you could add this data to a row in an Excel spreadsheet.

For saving it to a relevant columns in a SharePoint lisyt, have a look at the images below.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Start and wait for an approvalCondition (as we'll send an email if rejected)Update SharePoint listSharePoint list with decision, approval date and comments