cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Medalow
Level: Powered On

How to check if a field has been modified in Edit Form?

Hi guys!

Second question in a day is a personal record...but this is a tough one. Smiley Happy 

 

In one of the apps I am currently developing I have the requirement to have a "History" field into which I have to write back some of the important steps of the business process. - eg. Who and When did What...
Currently, when new item is created the default value, written in this field is made up of the following formula:

If(NewForm1.Mode=FormMode.New,"Created By: " & User().FullName & " on " & Text(Now(),"[$-en-US]dd/mm/yyyy"), Parent.Default)

And this is the result:

Capture.PNG

 

Now I need to figure out a way that lets me check if another field has been modified during the next steps of the process and "If Yes", add Who and When did What on a new line in the "History" field.

Any help will be highly appreciated!
Thank you in advance!

Cheers

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to check if a field has been modified in Edit Form?

Hi @Medalow,

 

According to your description, it seems that you would like to display “Created By” or “Modified By” info on the app.

Please take the following function for a reference to see if it will work for you.

I am using this function to check if the item Modified time equals Created time, if True, it means that the item has been modified, display the modified user and modified time. If False, it means that the item is newly created, display the created user and created time.

If(ThisItem.Created<>ThisItem.Modified,"Modified by:" & ThisItem.'Modified By'.DisplayName & "on" & ThisItem.Modified,"Created by:" & User().Email & "on" & Text(Now(),"[$-en-US]dd/mm/yyyy"))

Please take a try with it and feel free post back if you need more help.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Medalow
Level: Powered On

Re: How to check if a field has been modified in Edit Form?

@v-yamao-msft, not exactly.
I don't want to display the "modified by" info in the app.

Yes, the first line in the "History" field is who created the record, but the second line for example, should be who changed the priotity, when he/she has changed it and the value of the priority field. And the process continues for the "Status" field - when it was changed, who changed it and what is the newly defined value for it?

 

This is how the details form look like to gain better perspective:

Capture.PNG

 

In other words, I am searching for a way to check if only specific field/values in the form has been changed, not the record as a whole, and if "yes", pick the newly defined value from the changed field and write it in the "History" field.

Thanks for posting and for any help because I'm stuck on this requirement and cannot find a way to achieve such a functionallity.

 

Cheers!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 27 members 3,841 guests
Recent signins:
Please welcome our newest community members: