I am getting very close to the finishing touches on an app. It is currently driven primarily by a Sharepoint list that has 27 columns. About half of those are single line of text, then a mix of yes/no date, and only one caclulated. There are no lookups.
It is working fairly well, but I would like to make the response of my powerapp a bit more snappy. I have the date shown in a Powerapp Gallery, with various search methods. I was wondering if:
For Single Line of Text columns... does shortening the max character from 255 to a much smaller number make a difference? Many of these fields, I only need a few characters. I presume (please correct me if I'm wrong) but the typical width if 8's is what is important. Thus, if I only need 6 characters, its no more expensive to put in 8. Perhaps that only matter with stuff at a much lower level, but its the mode of thinking I would like verified.
Also, do number fields as opposed to text fields matter with respect to performance? I can convert some of them one way or another if that matters.
How many items do you have in this list? Can you share the formula that you used on the Gallery's Items property? If it's a large list, the slow performance might be related to the delegation in PowerApps.
Community Support Team _ Mona Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.