Conditional Formatting for LookUp Labels

[tagustin2020]

Hello, I am working on a new request form (screenshot attached). I have it set up so that when the user selects a Project Number from the dropdown control, the Project Name and Program Mgr/Product Engr labels are automatically populated via LookUp formulas. I kept the underlying text input controls in the data cards so the selections could be written back to my SharePoint list.

The current Text formula for the Project Name label is:

LookUp('Project List','Project Number' = ddProjectNumber.Selected.'Project Number','Project Name')

The current Text formula for the Program Mgr/Product Engineer label is:

LookUp('Project List','Project Number' = ddProjectNumber.Selected.'Project Number','Project Owner'.DisplayName)

When the user first launches the form, I would like the Project Name and Program Mgr/Product Engr labels to be disabled and read “Auto-populates based on Project Number selection”. Once the user has selected something from the Project Number dropdown control, that message should be replaced with the results of the LookUp and the label should be read-only as they don't want them to allow them to edit the results. I tried a If(IsBlank type formula, but didn’t get very far since I am still new at this. Can you please help me develop the correct syntax? Let me know if you need any additional information.

The other thing I should mention is that the new request form is on a dedicated screen of its own. When the user selects an item from the gallery to view or edit, they are taken to a separate screen with multiple tabs. Do I still need to include some type of If(frmNewRequest.Mode = FormMode.New, FORMULA, Parent.Default) type syntax in all of my new request form fields? If so, can you help me incorporate that piece into the LookUp labels as well? Thanks in advance for your kind assistance. Teresa

[faustocapellanj]

Hi Teresa, For the labels you are trying to use, have you changed the Update property of the data card to have that label as the source of the desired value?

[tagustin2020]

Hello Fausto,

The Project Name Update formula is txtValueProjectName.Text

The Program Manager/Product Engineer Update formula is dcPMPEValue.Selected

For some reason, these values only write back to the SharePoint list if I keep the original text input for Project Name. It's all working, even if it is not efficient as it could be so I hate to keep taking your time with it. I've set the Project Name and Program Manager fields to View so that only the Titles appear. As soon as they select something from the project number drop down. The fields auto-populate and the gallery is updated so I think we have achieved my primary goals.

I'm going to go ahead and mark your initial suggestion as the solution as I'm sure it is solid. Thanks so much for all the time you have spent helping me. I'm very grateful for the gift of your time. Have a nice evening and stay safe.

Teresa

[faustocapellanj]

Hi Teresa,

I'm happy to know I was able to assist in some way. Please, do not hesitate to reach out if you have questions or need help tackling a different issue.

Regards,

[tagustin2020]

Thank you Fausto. You are very kind.