"ID" Fild Sharepoint do not loaded in Gallery Power Apps (Filter(Dispensation_Letter;StartsWith(ID;PesquisaID.Text)

(0) Share

Report

Posted on by CU27081512-2

Hello everybody,

Pleas if possible help me with an error in Power Apps below.

Filter(Dispensation_Letter;StartsWith(ID;PesquisaID.Text) The field "ID" not reconosized in a sentence but his existing in a Gallery created. I need create search filter with ID field but I have a problema. The field ID come from Sharepoint List

Thank you for advise.

Renaut

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Renaut77 ,

StartsWith() on works on Text files - you can do this

Filter( AddColumns( Dispensation_Letter; "IDTxt", Text(ID) ); StartsWith( IDTxt; PesquisaID.Text ) )

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

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Renaut77 - the StartsWith function is delegable only with Text data types. Could you send a screenshot of the error message?

I would not expect you to see a error, but rather a delegation warning in blue.

Was this reply helpful? Yes No
CU27081512-2 93 on at

Like (0)

Report
Copy link

Link copied!

Hello WarrenBelz!
The problem was solved! Thank you for advise.

Renaut

Was this reply helpful? Yes No
CU27081512-2 93 on at

Like (0)

Report
Copy link

Link copied!

Hello!
But now I have a problem in a Edit Form (GalSearch.Selected). When I filter in a gallery "GalSearch" and selected the ID I need edit the register but the form not reconosize the gallery.

Was this reply helpful? Yes No