Power Platform Community Forum Thread Details

Hi, more than a doubt this is a solution when trying to sort gallery items with data from Excel (I guess this works with SharePoint Lists too). If you have this issue, a possible solution is to give columns names without spaces, I mean, e.g. try "ColumnName" instead of "Column Name". I struggled with this for hours and the solution is really simple, hope it helps.

Categories:

Building Power Apps

There is someone on here that shared the 10 commandments of Power Apps and Sharepoint and they were spot on in my opinion. Here are the ones I can remember:

Thou shall not use comples column types in Sharepoint. Text, Number, and DateTime columns are the only types that should be used.

Thou shall not use spaces or reserved words as column names. First Name should be FirstName.

Thou shall not use lookup columns. Create your own lookup table using number or text values but avoid using lookup tables.

Thou shall not rename a column in SharePoint after it is created. This is due to the column name not actually changing but rather the 'front facing' name changing which is only a description essentially. This can cause confusion when making changes to the app.

I have a few more like I dont use forms but rather I build my own and write patch functions. This may seem ridiculous but once you are used to creating them it takes very little time and then you have control over it and know how it will work a little better. Hope these help!