cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Partisan
Post Partisan

Filtering SharePoint list

I want to know how to filter a list to just show ongoing contracts. So I'm using two list in my app. The main one is the timesheet_list and the second one is the companycontract list. In the timesheet list there is a column called contract and originally on sharepoint this is a lookup column taking contract numbers from the other sharepoint list (CompanyContracts) from the column called column1. Now I created another column in that companycontract list called Active, where I wanted it to display contract numbers that are still ongoing.  the 3 main columns in companycontract are column1 (contract numbers), Completed ( 0 meaning it's ongoing, 1 meaning it's completed) and then active (displays ongoing contract [COMPLETED = 0]). Now on the power apps that contract column displays an error cause of the threshold issue of 5000 items and I'm not sure what to do. On power apps is there a way to filter the companyconytracts list to just show ongoing contracts. The contract field in power apps is a combo box.

1 ACCEPTED SOLUTION

Accepted Solutions

@SandraAkujobi ,

You will not solve this with a calculated column, which have other issues when used with Power Apps.

You need to turn this into a populated column, or use AddColumns in PowerApps with the same calculation.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

5 REPLIES 5
Super User III
Super User III

Hi @SandraAkujobi ,

You need to index the field in SharePoint and that should solve the issue as numeric field queries are Delegable.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

@WarrenBelz So I've tried t do that, but the column I want to index which is the Active column, does not appear as an choice in the dropdown. I'm thinking maybe it's because it's a calculated column and calculated columns can't be indexed. I've already indexed the contract column as well another column called completed (two choices - 0 = ongoing, 1 = completed) this column is how you get to know which contract numbers are ongoing. Then on the main timesheet list I created a lookup column to the contract numbers but I was still hit with the threshold issue and that same issue is still causing an error on power apps as well. 

@SandraAkujobi ,

You will not solve this with a calculated column, which have other issues when used with Power Apps.

You need to turn this into a populated column, or use AddColumns in PowerApps with the same calculation.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

@WarrenBelz I'm not quite sure what you mean, I'm quite new to this so I don't know where to start from.

Hi @SandraAkujobi ,

You need to make the same calculation inside Power Apps and either populate a new column in SharePoint, or (as I mentioned), add the calculated column using AddColumns in the same manner.

If you are new to Power Apps, I would suggest the first option and put your calculation as the Default of this field.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (38,081)