Default user in a textbox

(0) Share

Report

Posted on by CFC1888

Hi all,

I've set a default value in a textbox as follows:

Office365Users.MyProfile().Mail

This works, however, what I want to do is ensure that once this value is set it can never change (for example, if someone logs an issue I want the "Ticket Logged By" value to always default to the original user.

I tried:

If(SharePointForm1.Mode = FormMode.New, Office365Users.MyProfile().Mail, Parent.Default)

This is giving the following error message in the default value of the textbox "Invalid argument type (Record). Expecting a text value instead".

Can someone please point me in the right direction?

I'm also seeing an "Expected record value" error on the datacard update property (which is currently set as txtLoggedBy.Text). What should the update property be set with please?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
A textbox has multiple display modes. In 'Edit' mode the text in the textbox can be edited. If you change the display mode to 'View' then the text is only viewable and can't be changed. So rather than trying to fix the value, adapt the display mode.

You can change the property DisplayMode so that once the form has been submitted then the display mode changes. If the field is part of a form you can use either of
NewForm(SharePointForm1); ViewForm(SharePointForm1);
to change the forms view mode and then link your text field's DisplayMode property to the form through
SharePointForm1.DisplayMode

The result is that your TextInput1.DisplayMode will always be the same as that of the SharePointForm1.

You could also make this dependent on whether the data field is blank or not and only have it editable if the underlying data field is blank.

Hope this helps 🙂
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Anonymous , that's useful information for future projects, but in this case it won't work as I don't plan on making the field editable at any time (I want the user name to auto-populate the textbox when the ticket is created, but once created this value should never change).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi CFC1888,

Then you can continue to use a text field and just make the DisplayMode to be 'View' and it will not be editable. Or you can use a label instead of a text field, here the DisplayMode won't matter cause a label is never editable. Both will work.
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, however, we're back at the original problem though. I can set the textbox DisplayMode to View, but the issue I'm having is trying to get it to display the original user who created the record.

Office365Users.MyProfile().Mail

works correctly, but if someone else opens that same record the textbox will be populated with that person's email address. If I try:

If(SharePointForm1.Mode = FormMode.New, Office365Users.MyProfile().Mail, Parent.Default)

I get "Invalid argument type [Record]. Expecting a text value instead" on the default property.

The Update property on the datacard is set as:

txtLoggedBy.Text

but that's giving me "Expected Record value".

Sorry, this is my first time using PowerApps so I'm very much a beginner!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Ah, so the issue is more around saving and loading the data. Right?

You will need to store the data into a collection and then point the text field to load the text from that collection. If the record is new you can populate the username using either of
User().Email Office365Users.MyProfile().Mail

If the record already exists then you will need to load the data from your data source into the collection, from where the the text field will then load the data (same as above). You can then allow/prevent the user editing some fields using the DisplayMode as above.

If you're new to powerapps the easiest way to start is to use one of the sample apps and then modify that to suit. Have a look at 'Service Desk' or 'Leave Request', they may be close to what you're trying to build.