Basic Functions Assistance

Like (0) Share

Report

Posted on 3 Sep 2020 19:47:00 by Pascal_tcl

I'm a beginner with Powerapps and I am in need of guidance on how to proceed with these.

Sort('Phones 2', "Last Name_Coulmn1",SortOrder.Ascending)
Filter ('Phones 2',Frequency_Column1 = 1A)
First('Phones 2')

I get a warning message about "large datasets". I've tried with an imported SharePoint list of 6 items and another with 1900 items.

The second warning/error message reads "... operation not supported by this connector".

Any feedback would be appreciated.

Categories:

General Questions

Connectors

Connecting to Data

All responses (6)

Answers (1)

Pascal_tcl 12 on 09 Sep 2020 at 17:17:59

Like (0)

Report

Re: Basic Functions Assistance

Aside from not using double quotes on my textbox values, I also used the wrong gallery item. I'm not sure how common some of these mistakes are, but I was quickly able to get things working once I realized the mistake.
Pascal_tcl 12 on 09 Sep 2020 at 17:13:08

Like (0)

Report

Re: Basic Functions Assistance

Thanks for the feedback.
I was able to get things working.

Based on all the feedback, I was able to successfully test a new command on my sample Active Directory list.
SortByColumns(Search(ADContacts, TextSearchBox1.Text, "Title"), "Title", If(SortDescending1, Descending, Ascending))

I can now move forward with My other lists

Verified answer

v-yutliu-msft on 08 Sep 2020 at 03:21:45

Like (0)

Report

Re: Basic Functions Assistance

Hi @Pascal_tcl ,

Could you tell me:

1)the data type of these fields Last Name_Coulmn1,Frequency_Column1?

2)whether your sharepoint list has 1900 items?

Do you have two problems:

1)delegation warning?

2)operation not supported by this connector?

Q1:

If your sharepoint list only has 1900 items, then you just need to change the delegation limit to 2000.

Even if you have delegation warning, your app's performance will not be affected.

For now, based on your provided formulas, the key point is First() function is not delegate, which leads delegation warning appearing.

Please refer this table about delegate functions for sharepoint :

Item	Number	Text	Boolean	DateTime	Complex [1]
Filter	Yes	Yes	Yes	No [4]	Yes
Sort	Yes	Yes	Yes	Yes	No
SortByColumns	Yes	Yes	Yes	Yes	No
Lookup	Yes	Yes	Yes	No	Yes
=	Yes	Yes	Yes	No [4]	Yes
<, <=,<>, >, >=	Yes [2]	No	No	No	Yes
StartsWith	-	Yes	-	-	Yes
IsBlank	-	No [3]	-	-	No

Q2:
Do you have this problem in this formula:
Filter ('Phones 2',Frequency_Column1 = 1A)?

The key point is this Frequency_Column1 field data type and what does 1A represent?
If "1A" is a text and Frequency_Column1 is text type, you should try this formula:

Filter ('Phones 2',Frequency_Column1 = "1A")

Best regards,

WarrenBelz 149,147 Most Valuable Professional on 06 Sep 2020 at 00:27:21

Like (1)

Report

Re: Basic Functions Assistance

@Pascal_tcl ,

The Delegation issue is First(). (which is not Delegable). This blog of mine may be useful for you to understand the principle.
CU-18081211-6 9,266 Moderator on 03 Sep 2020 at 20:01:26

Like (0)

Report

Re: Basic Functions Assistance

Can you explain more about your context and what do you intend to obtain.

1. Sort('Phones 2', "Last Name_Coulmn1",SortOrder.Ascending)
- bring from Sharepoint all the records sorted ascending from Phones 2 list (sorted ascending on server side) .
you can read more about delegation warning here.
2. Filter ('Phones 2',Frequency_Column1 = 1A)
- should give an error because the string value must be quoted in PowerApps.
3. First('Phones 2')
- refer to first record from 'Phones 2'
mike528 236 on 03 Sep 2020 at 19:55:21

Like (0)

Report

Re: Basic Functions Assistance

@Pascal_tcl

Where does this code reside?
Are you trying to get the first item sorted by last name where Frequency_Column1 = 1A?

Sort('Phones 2', "Last Name_Coulmn1",SortOrder.Ascending)
Filter ('Phones 2',Frequency_Column1 = 1A)
First('Phones 2')
Try this;

UpdateContext({myrecord: First(Sort(Filter ('Phones 2',Frequency_Column1 = "1A"), "Last Name_Coulmn1",SortOrder.Ascending))})

Assuming Frequency_Column1 is a string, you need quotes around your A1.

Hope this helps.