Greetings,
I am seeking the option to pull data into an app based on one or multiple search criteria. The SP list, where the data is housed, has 33k + items. My goal is to provide the user a Search screen and not pull any data into the app until they query it. If a user selects multiple criteria, i.e. State, Project Year, and Project Category, I would like to display the data in a gallery. If a user selects a unique item, based on project number, then I would like to display the details for that project in a DisplayForm or Labels.
The question is - how can i query the data in SP. I understand delegation and was trying to test by displaying a project utilizing the Lookup function. However, that does not work.
Tagging all who I follow or have been most responsive. Thank you!
I have tried all ways described with no luck. I do notice, however, that when I initially put the formula in I do not get the redline error. It is when I initiate the filter that I receive the following - 'An error occurred on the server'. This leads me to wonder - do i need to add the App ID for the PowerApps somewhere in the SharePoint security settings - allowing the app to process on the query on SP? (Similar to the process for embedding an app?)
User | Count |
---|---|
255 | |
106 | |
85 | |
51 | |
43 |