Answered

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

(0) Share

Report

Posted on by k_to

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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
k_to 31 on at

Like
a
(0)

Report
Copy link

Link copied!

そのような式になります。でもなぜかこれがうまく機能していないです。
出来ない理由として考えられる要因はありますでしょうか？
どこかがおかしいという事になると思いますが、それがどこかわからないです。
もし何かあればアドバイスを頂けましたら幸いです。
宜しくお願いいたします。

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @k_to

Could you please show your error message?

Best Regards,

Levi

Was this reply helpful? Yes No
k_to 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No