data format is "Select", what happens to the code for searching using StartsWith?

(0) Share

Report

Posted on by Bingqiling

321

Dataverse "TB_ITAM_APPLICATION" 테이블에 있는 필드 "APPLICATION_TYPE"의 데이터 형식이 "Select"인 경우 StartsWith를 사용하여 검색하는 코드는 어떻게 됩니까?

If the data format of the field "APPLICATION_TYPE" in the dataverse "TB_ITAM_APPLICATION" table is "Select", what happens to the code for searching using StartsWith?
Filter(
TB_ITAM_APPLICATION,

StartsWith(APPLICATION_TYPE, SearchKeyword_input. Text)

|| StartsWith(cr861_applicationtype ,SearchKeyword_input. Text)

)
위와 같은 방식으로 작동하지 않습니다 ...

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Bingqiling ,

May I ask what data source you have used?
Dataverse or SharePoint?

Let us assume the data source is SharePoint.
Items of Gallery:
Filter('0804-1',StartsWith(Test_Choice.Value,SearchKeyword_input. Text))

Hope this will help you.
Best Regards,
Tina

Was this reply helpful? Yes No
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

data sourse is Dataverse.
error...
problem1
Invalid name. 'Value' is not
recognized.
This error usually appears when a formula refers to
something that doesn't exist (for example, a control you've
deleted).
denture

problem2
Function 'StartsWith' has some invalid arguments.

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Bingqiling ,

Thanks for your infomation.

We made a sample for you.
Items of Gallery:
Filter(AddColumns('0804-1S',"ChoiceValue",Text('DataChoice')),StartsWith(ChoiceValue,TextInput1.Text))

Hope this will help you.
Best Regards,
Tina

Was this reply helpful? Yes No
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow! Thank you so much.👍💖❤️
Thanks to you, I solved it.
Your ability is very high. It's incredible.😁

Was this reply helpful? Yes No