Answered

Delegations Error

(0) Share

Report

Posted on by hoaanhnguyen

Hello everyone,

Just for information I do not have any experience in coding or building apps and this my first time building one, I am learning as I go. I created a simple app connected to sharepoint list and have two

1. As default all users can only create new list items but cannot view or edit.

2. Admin window can see all the list and edit items.

I followed some youtube guides and succeeded

1. My first question is that I have this warning about the delegation's problem but have no idea how to resolve it

2. My second question is that how do I sort that gallery by newest items on top?

and this is the code I'm using for the gallery:

Switch(
varTabSelected,
1,
Filter(
'TOOL-7-COMPLAINT',
'Trạng thái' = "Open"
),
2,
Filter(
'TOOL-7-COMPLAINT',
'Trạng thái' = "Handling"
),
3,
Filter(
'TOOL-7-COMPLAINT',
'Trạng thái' = "Closed"
)
)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
1. My first question is that I have this warning about the delegation's problem but have no idea how to resolve it
'Trạng thái' is a single line of text or a multiple line of text? if not, which type?
If it is a multiple line of text I suggest you to change to a single line because this column is not delegable.

More info about delegation: https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

2. My second question is that how do I sort that gallery by newest items on top?
you can use the Sort function like this:
Sort(
<your code>,
Created, Descending)
hoaanhnguyen 57 on at

Like
a
(0)

Report
Copy link

Link copied!

1. 'Trạng thái' is a single line of text or a multiple line of text? if not, which type?
If it is a multiple line of text, I suggest you change to a single line because this column is not delegable.
'Trạng thái' It's a calculated column, it's a Status column when a user edits a date it will change the status automatically. And it is a single line text type of column
2. Sortin gallery: Yes that worked thank you, I thought I had to put sort after my code that's why it didn't work before 😅
Verified answer

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

calculated column is also a non delegable column so you cannot avoid that warning.

I hope it helps 🙂
Please accept it as solution if your question was answered
hoaanhnguyen 57 on at

Like
a
(0)

Report
Copy link

Link copied!

I see, thank you for clarifying that, I will note that down 😁