cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
k_to
Helper I
Helper I

SortByColumns(Search(テーブル,テキスト入力.Text,"カラム"),"カラム",If(SortDescending1,Descending,Ascending))

SharePointでリスト作成をしています。そのリストから検索で出力したいのですが、どうしたらよろしいでしょうか? SharePointの方で何かしないといけないとかありますか? 逆にSharePoint側でやっていたらいけない設定などとかありますか?

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Community Support
Community Support

Hi @k_to 

 

Note that column name need to be enclosed in double quotes.
According to your screenshot, there is one less comma between the column name and the If.

Sort and SortByColumns functions in Power Apps - Power Platform | Microsoft Learn

 

Best Regards,

Levi

View solution in original post

6 REPLIES 6
StalinPonnusamy
Super User
Super User

Hi @k_to 

 

We cannot read the formula since it shows a different language. Can you post it in English, please?


Thanks, Stalin (Microsoft MVP)
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

v-liwei-msft
Community Support
Community Support

Hi @k_to 

 

Could you please tell me:

Is your formula 

SortByColumns(Search(Table,TextInput.Text,"Column"),"Column",If(SortDescending1,Descending,Ascending))


Your formula is correct and you don't need to set up SharePoint.

 

Best Regards,

Levi

k_to
Helper I
Helper I

そのような式になります。でもなぜかこれがうまく機能していないです。

出来ない理由として考えられる要因はありますでしょうか?

どこかがおかしいという事になると思いますが、それがどこかわからないです。

もし何かあればアドバイスを頂けましたら幸いです。

宜しくお願いいたします。

v-liwei-msft
Community Support
Community Support

Hi @k_to 

 

Could you please show your error message?

 

Best Regards,

Levi

k_to
Helper I
Helper I

添付写真のようなエラーが出てきますが、こちらは問題ないでしょうか?

宜しくお願いします。

v-liwei-msft
Community Support
Community Support

Hi @k_to 

 

Note that column name need to be enclosed in double quotes.
According to your screenshot, there is one less comma between the column name and the If.

Sort and SortByColumns functions in Power Apps - Power Platform | Microsoft Learn

 

Best Regards,

Levi

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,280)