Power Automate

Get an email with the modification made on the SharePoint list (powerapps submitform)

(0) Share

Report

Posted on by Charlie Martharper

888 Season of Giving Solutions 2025

Hi guys!

I want to get an email with the information of what have changed in the item on a sharepoint list.

Is it possible TO GET THAT VALUE?

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Charlie Martharper,

With this flow i can determine the column has changed or not but not always the old value by itself.

If you need Comparing New and Previous Column Value in SharePoint on Item Modification via Power Automate follow this article.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Charlie Martharper 888 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi!!

What should I introduce in the bodys mail? Just get the new version number when using dynamic expression:

Was this reply helpful? Yes No
Charlie Martharper 888 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

From that blog it doesnt use the get changes for an item and it doesnt sends an email.

I am trying but still cant find solution. I just get the true true false values from the values changes in the item. @MS.Ragavendar

Was this reply helpful? Yes No
David_MA 14,614 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I understand what you're asking. you want to send an e-mail with the current value and prior value of a field(s) in a SharePoint list. I have only done this one time, and I cannot remember which workflow I have that does this. However, I did find a blog post that outlines the steps: (4) Get SharePoint List item version history using REST API and MS Flow | LinkedIn.

This may not contain everything you need, as first you may need to use the Get changes for an item to first see if the field(s) changed in the first place. It will also require that the list has versioning turned on. The step relies in the SharePoint API to make an HTTP request to the list to get the version history information.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Charlie Martharper,

Get changes for an item or a file (properties only) action just give information exactly what changed in a SharePoint item.

If you need the column information and want to show the previous item value you need to get current value and send http request old value and need to select only the changed ones.

Check Get Current & Previous Item in SharePoint List Using Power Automate this completely covered your requirement.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Charlie Martharper 888 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi guys! @David_MA @MS.Ragavendar

The thing is, those changes that are made are from submiting a form in a POWER APP. Maybe it's easier to get those values if you know that I am doing changes in power Apps. The screen looks like this (gallery and edit form + button (desa canvis) that submits form):

So when they change anything from there and click the button, it modifies the list.

Is it possible to be easier to create a flow knowing that it comes from APPs? Like to get the changes in an mail?

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Charlie Martharper,

You are like my business user changing requirement dynamic 😁.

Its really good idea, You can capture what changed” entirely inside Power Apps.

Challenge

Power Apps does NOT automatically know the “previous value” once data is saved

You must manually store the original values before editing

Hence i suggested with Power Automate + SharePoint “Get changes”.

How to In-corporate this Power Apps

Store original values when the item loads and Compare them with current form values on Submit.

Build a “Changed fields” text and Save it to SharePoint or email.

When the user selects an item (Gallery → Edit):
Set(varOriginalItem, ThisItem); // OnSelect function of Gallery item
EditForm(YourFormName);

On Submit Form

Set(

    varChanges,

    ""

);

If(

    varOriginalItem.ColumnName<> DataCardValue_ColumnName.Selected.Value,

    Set(

        varChanges,

        varChanges &

        "Priority: " & varOriginalItem.ColumnName& " → " & DataCardValue_ColumnName.Selected.Value & Char(10)

    )

);

If(

    varOriginalItem.ColumnName2<> DataCardValue_ColumnName2.Text,

    Set(

        varChanges,

        varChanges &

        "Observations: " & varOriginalItem.ColumnName2 & " → " & DataCardValue_ColumnName2.Text & Char(10)

    )

);

// finally submit

SubmitForm(FormName);

Note:

I mentioned only syntax such as ColumnName -> in your case you have to provide your correct name and correct type (Text / Value)

Similarly for the datacard you need to write it for all columns and all datacards.

For sending email from the Powerapps follow this article power-apps-send-email-using-outlook-the-complete-guide

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Charlie Martharper, Just checking in — did the proposed solution resolve the issue, or do you still need assistance?

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Charlie Martharper 888 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi! @MS.Ragavendar

So it is not possible when clicking the button to create the mail? I have to do an APP?

Because if its that the only way, it could be better just follow the idea we were trying at first and only get in the mail but in the select it asks me to enter a valid json:

In the select 2, the current value when adding the

body(‘Send_an_HTTP_request_to_SharePoint_2’)?[‘body’]?[json(item())]

So when adding that in the current value it doesnt work + the replace nothing works (could you try?). I had to change the replace: replace(replace(split(item(), ':')[0], '"', ''), '''', '')

This appears in the flow checker when trying to save:

Could you provide some help?@MS.Ragavendar Thank you so much, sorry I was sick and couldn't reply before.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Charlie Martharper,

So it is not possible when clicking the button to create the mail? I have to do an APP?

As mentioned, the below implementation will help you to Identify the difference in the Power Apps Itself and the changes can be mentioned in the E-Mail. I am bit confused with your query.

Regarding the flow error Your Select action Map is invalid JSON, which is why Power Automate shows: “Enter a valid json” Also, your Send HTTP request is failing because it depends on the broken Select output. Can you please share the full flow screenshot

In Select action, configure like this: split(variables('YourString'), ';')

Title : replace(replace(split(item(), ':')[0], '"',''),'''','')
Previous value : replace(replace(split(item(), ':')[1], '"',''),'''','')
Current value : body('Send_an_HTTP_request_to_SharePoint_2')?['body']?[json(item())]

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No