Answered

Need help getting the results of a Lookup to display

(0) Share

Report

Posted on by T_A_M

332

I have a form in my app (Form1) that switches between Edit mode and New mode depending on if the selected item is blank or not. There's a Rich Text Editor in the form, and I want its default to show previously entered data if the form is in Edit mode, or the results of a Lookup if the form is in New mode.

The code I'm using in the default property of the Rich Text Editor is:

If(
Form1.Mode=FormMode.New, LookUp(SharePointList, ID=ThisItem.ID).Title,
Parent.Default
)

Title is what I want to show up in my rich text editor control when the form is in New mode. The code isn't giving me any errors, but it doesn't show anything in the control when the form mode is New. It does show previously entered data when the form mode is Edit.

If I replace LookUp(SharePointList, ID=ThisItem.ID).Title with a hard-coded value, the formula works as intended. I just can't get it to display the results of the Lookup.

Any suggestions would be greatly appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@T_A_M

Try Coalesce(Parent.Default, LookUp(SharePointList, ID=ThisItem.ID).Title)

Since Parent.Default is blank in new forms.

Was this reply helpful? Yes No
T_A_M 332 on at

Like (0)

Report

Unfortunately, that behaved the same. I still get a result in the Rich Text editor control when the form is in Edit mode, and nothing when it is in New mode.

Was this reply helpful? Yes No
Verified answer

T_A_M 332 on at

Like (0)

Report

I came up with a solution. I set a variable Set(QuestionVar, Gallery1.Selected.Title) in the OnVisible property of the page, and on the OnSelect propert of Gallery1. (The data source for Gallery1 is SharePointList.)

Then I put this code in the Default property of my rich text editor control:

If(
Form1.Mode=FormMode.New, QuestionVar,
Parent.Default
)

Was this reply helpful? Yes No