Answered

Power Automate Flow which is not returning the correct data

(2) Share

Report

Posted on by AW-18070850-0

Hi Team

I've built a Flow, which was very close to perfect, however it's not returning the correct data (and now not even working).

I need a flow that, when a form submission is made, data that is generated in the excel document capturing the form data is then generating an email to send that generated data back to the person who submitted form details.

I had a version that was working but it was returning the row prior to the row that was just submitted. to be clear I want the email that is sent back to contain the generated data from the Excel file only for the most recently submitted item.
the Generated fields I am trying to send back are:

Project Code
Project Name (not generated - just passing back)
Folder name.

I did set it up with the help of ChatGPT but I've been going in circles and I'm not getting anywhere. Now I've gone backwards and I can't even get it to send the email.

Here are my steps

When a new response is submitted (Forms)
Get Response Details (Forms) ResponseID is ResponseID
5 Second Delay (Delay)
List Rows Present in a Table (Excel)
Compose (Action) - last(outputs('List_rows_present_in_a_table')?['body/value'])
Send an email (V2)

Originally I had the email step inside an 'Apply to Each' and it worked, now it doesn't.

I would love some support with this - I'm losing my mind as it has to be super simple.

the attached shows you the Excel collection data sheet (the project Code and folder name are generated inside this document). the issue I was having was when I submitted the project 'AW Test 18.12' I was getting the details back for 'Aw Test 16.24'

At one point i was also getting an email for every single submission made today. So I was getting around 25 emails when I submitted one project.

Any help will be appreciated!

Amanda

Categories:

General topics

Screenshot 2025-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (6)

Answers (1)

Tomac 3,951 Moderator on at

Like (0)

Report

@AW-18070850-0

I'd like to clarify something about your flow

Does the Excel file contain more data than just the form response? If not, why can't you simply email the data from the Get Response Details action? Then you don't have to worry about Excel actions or which row is selected.

Was this reply helpful? Yes No
Verified answer

Tomac 3,951 Moderator on at

Like (1)

Report

If you don't need Excel for data combines or transformations, you can use this flow logic for a simple form result emailer:

If you need to add combined data from excel, you'll need to select a specific row from a table using a unique ID:

Note that the delay action is there to give the spreadsheet time to sync with the newly submitted response. There may at times be a delay by as much as ten minutes on Power Platform and SharePoint file interactions, so if you don't need the email immediately it's recommended to use a delay of ten minutes.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@AW-18070850-0 Hi,

One of your screenshot is not available.

You said the excel captures the form data, but your process/steps doesn't mention that.

@Tomac's comment is close to the answer if you can provide that how the excel interact with the form.

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @AW-18070850-0,

Can you check the screenshot is attached without any issue? I believe you attached the flow screenshot, but we are not able to access that, could you upload it again, also it's better to put expanded flow and also point where you are getting the issue

(If this answers your question you can mark as Answered and give it a Like)

Regards,

Srini

Was this reply helpful? Yes No
AW-18070850-0 15 on at

Like (0)

Report
The missing Screenshot is attached showing the flow

Effectively this is the user process

Fill in MS Form

The Spreadsheet collecting the form details, then generates a Project Code and a Folder name

The email goes back to the user with the chosen details from the spreadsheet.

so the Excel form is taking each new response and it gets added with a Unique ID [ID]

These fields are al default fields which are generated via the Form being linked to the Sheet

Start Time

Completion Time

Email

Name

These fields are from the form itself

Date

Project Name

Location

And the Fields that are generating via a formula are

Project Code

Folder Name

I want the email to go back to the user to say

To:
(Person who submitted the form) [Email]

Subject:
Your Project Code is ready!

Body:

Hi ['Name'],

Thank you for submitting your project.

Project Name: ['Project Name']
Project Code: ['Project Code']
Folder Name: ['Folder name']

Kind regards,
The Projects Team

Screenshot 2025-0...

Was this reply helpful? Yes No
AW-18070850-0 15 on at

Like (1)

Report

I've updated the flow as per @Tomac's response and set the delay to 2 minutes. It appears to be working! This will be my first point of call next time, instead of ChatGPT.

Thank you everyone!

Was this reply helpful? Yes No