Lookup Result

(0) Share

Report

Posted on by NurNida

213

Hi All,

My lookup works fine but the problem is it refresh every time we open the form. My lookup value is picking up value from other view.

I wanted to make it one time lookup (when submit ) and the value should remain unless there is changes on the category before the document workflow is complete.

Now it show blank if the status is not match means it not save the lookup value when submit.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NurNida ,
What I think you are asking is that this value is for new records or when the field is blank, otherwise, show the present value?
If so, try
If( IsBlank(DataCardValue12.Text) || DataCardValuel2.Text="Submitted", LookUp( 'RFQ Request Category', Titles, DataCardVaLue4.Selected.Value, CategoryPIC ), Parent.Default )
Bear in mind I cannot see your data or control type/values so if this is not what you are asking, please describe your process in more detail.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NurNida ,

Do you want the LookUp formula to be executed once time when you submit your form data?

Based on the needs that you mentioned, I think it is not necessary to display the LookUp result within the Category PIC Text Box, instead, you could configure Category PIC field as hidden field within your Edit form.

I agree with @WarrenBelz 's thought almost, you just need to bind the Update property of the Category PIC field data card to the LookUp result that you mentioned.

Set the Update property of Category PIC field data card in your Edit form to following:

If( SharePointForm1.Mode = FormMode.New, If( IsBlank(DataCardValue12.Text) || DataCardValue12.Text = "Submitted", LookUp('RFQ Request Category', Title = DataCardValue4.Selected.Value, CategoryPIC), DataCardValue33.Text ), Parent.Default )

Best regards,
NurNida 213 on at

Like
a
(0)

Report
Copy link

Link copied!

Got it.. Thank You. 🙂