Power Platform Community Forum Thread Details

I have used the below formule to fetch automatically data from a sharepoint list when user seraches a text.

With({wordMatch:If(!IsBlank(Self.Text),LookUp(LargeListAPMI,StartsWith(Title,Self.Text)).Title)},UpdateContext({varThematch:If(!IsBlank(wordMatch),wordMatch,Self.Text),varThematchname:LookUp(LargeListAPMI,Title=wordMatch).field_2}));

Below code in Text default property:

If(!IsBlank(varThematch),varThematch,Parent.Default)

Above code works fine. However when i edit properties for an item in document library and save. Item gets saved sucessfully with new values However when i try to edit properties of another item, The tet box shows the previous id value in the text box. How to remove the cached value.

If(
!IsBlank(DataCardValue3.Text),
With(
{
wordResult:
Concat(
Distinct(
Filter(
LargeListAPMI,
StartsWith(
Title,
DataCardValue3.Text
)
),
Title
),
Value & "; "
)
},
Left(
wordResult,
Len(wordResult) - 2
)
)
)

Categories:

Building Power Apps

Hi @santoshPrasanna ,

You can probably save a bit of code here

UpdateContext(
 {
 varThematch:
 Coalesce(
 LookUp(
 LargeListAPMI,
 StartsWith(
 Title,
 Self.Text
 )
 ).Title,
 Self.Text
 ),
 varThematchname:
 LookUp(
 LargeListAPMI,
 Title = wordMatch
 ).field_2
 }
)

then

Coalesce(
 varThematch,
 Parent.Default
)

and

If(
 !IsBlank(DataCardValue3.Text),
 Concat(
 Distinct(
 Filter(
 LargeListAPMI,
 StartsWith(
 Title,
 DataCardValue3.Text
 )
 ),
 Title
 ),
 Value, 
 "; "
 )
)

but your code issue is the second code above - you need to clear the Variable

UpdateContext({varThematch: Blank()})

if you do not want to see it in another record.

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.

MVP (Business Applications) Visit my blog Practical Power Apps