cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Want to enter multiple line using user().email.

Hello Everyone,

 

As I am developing app where in comments whenever any user does changes to fields must mention in comments like I want logs who has done changes etc . I am attaching attachments want solution like that using single User().Email and previous comments must be there , it gets wiped out with entering new comments.

 

Regards,

Sagar Shah

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Want to enter multiple line using user().email.

Hi @sagar_shah:

Do you want to record user changes to the form in comments?

I've mad a test for your reference:

my data source:

Column (click to edit) Type

TitleSingle line of text
statusActiveSingle line of text
ColumnLinktoCheckboxSingle line of text
commentsMultiple lines of text

1.JPG

1\set the DataCardValue10's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed Title"}) /*var is my custom variable*/

 

2\set the DataCardValue11's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed statusActive"})

 

3\set the DataCardValue12's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed ColumnLinktoCheckbox"}) 

 

4\set the DataCardValue21's Default property to:

 

Parent.Default &var

 

5\add a button and set it's OnSelect property to:

 

SubmitForm(Form4);UpdateContext({var:Blank()}) /*Form4 is my form*/

 

35.gif

Best Regards,

Bof

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Want to enter multiple line using user().email.

Hi @sagar_shah:

Do you want to record user changes to the form in comments?

I've mad a test for your reference:

my data source:

Column (click to edit) Type

TitleSingle line of text
statusActiveSingle line of text
ColumnLinktoCheckboxSingle line of text
commentsMultiple lines of text

1.JPG

1\set the DataCardValue10's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed Title"}) /*var is my custom variable*/

 

2\set the DataCardValue11's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed statusActive"})

 

3\set the DataCardValue12's OnChange property to :

 

UpdateContext({var:var&Char(13)&User().FullName&" "&Text(Now(),"[$-en]yyyy/mm/d hh:mm:ss")&Char(13)&"changed ColumnLinktoCheckbox"}) 

 

4\set the DataCardValue21's Default property to:

 

Parent.Default &var

 

5\add a button and set it's OnSelect property to:

 

SubmitForm(Form4);UpdateContext({var:Blank()}) /*Form4 is my form*/

 

35.gif

Best Regards,

Bof

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Want to enter multiple line using user().email.

Hello user,

Thanks for solution you have provided but its not working and if I have date picker,drop down value then how can I update my logs.

 

 

Regards,

Sagar Shah

Highlighted
Helper I
Helper I

Re: Want to enter multiple line using user().email.

Hello user,

 

Thanks for solution it worked now I am having another requirements like I wanna fetch changes made to data how can we fetch it..And also last value to new value should be mentioned.

And please ignore previous post of not getting solution.

 

Regards,

 

Sagar Shah

Highlighted
Community Support
Community Support

Re: Want to enter multiple line using user().email.

Hi @sagar_shah :

Do you want to revert user changes to this record?

My idea is to create another list and save the record to this list every time I submit a modification. If the user needs to roll back the data, they can use the history records saved in this list to update.

For example:

 

Patch(AnOtherList,Defaults(AnOtherList),{Column1:XX,Column2:XX});/*Save the original record to the data source AnOtherList*/
SubmitForm(YourForm)/*Submit the revised record*/

 

If you need to compare the modification of the record, just go to AnOtherList to find the corresponding record.

Best Regards,

Bof

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,809)