[LOOKUP FIELD] SharePoint and Custom Forms PowerApps

(0) Share

Report

Posted on by Moises

Hi,

I have one list in SharePoint Online with 9000 rows or more.

The native form dont working with the quantity of the rows. So, i created three index in the List and a custom form using PowerApps.

In the powerapps in the Field Lookup I added the following logic:

SortByColumns( If( IsBlank( DataCardValue2.SearchText ); LISTNAME; Filter( LISTNAME; StartsWith( EMPRESA; DataCardValue2.SearchText ) ) ); "Title"; Ascending )

With that I can search any row for all list, But when i saved the form the field EMPRESA dont appears (attached image)

What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

h-nagao 392 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Could you give an expression for Update property of the DataCard?
In general, if you modify items property of combobox inside DataCard, you have to change Update property as well.

Thank you,
Hiro

Was this reply helpful? Yes No
Moises 41 on at

Like (0)

Report
Copy link

Link copied!

Hi @h-nagao,

Thanks for help me.

In DataCard in "Default" is seted "ThisItem.EMPRESA" and in "Update" is seted "DataCardValue2.SelectedItems"

Was this reply helpful? Yes No
Verified answer

h-nagao 392 on at

Like (2)

Report
Copy link

Link copied!
Hi Moises,

Thanks for sharing your formula.
I've tested on my side, blow code works fine

//For Update property
{ '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Value(DataCardValue2.Selected.ID), Value: DataCardValue2.Selected.Title }
and

//For Default property
If(!IsBlank(ThisItem.EMPRESA),LookUp(LISTNAME,ID=ThisItem.EMPRESA.Id))
* depending on your region, comma should be replaced by semi-colon.

I hope these expressions work fine for you.

Was this reply helpful? Yes No
Moises 41 on at

Like (0)

Report
Copy link

Link copied!

Yeeeeeaah @h-nagao,

Thanks so much!!!

You are a sacred monster of the PowerApps... Thanks again.

Was this reply helpful? Yes No
h-nagao 392 on at

Like (0)

Report
Copy link

Link copied!

You are welcome!
Enjoy making PowerApps!

Regards,
Hiro

Was this reply helpful? Yes No
Bmarsoner 15 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much @h-nagao . Your solution saved my day!

Was this reply helpful? Yes No