Share
Report
55I am starting with a very simple thing; an Excel workbook with a table and the following fields
| Full Name | Cust Type | City | Location Type | Product | Price | Cost | Qty | Discount | Order Date |
The first five are text columns. Price, Cost, and Discount are currency. Qty is an integer. Order Date is a date.
When I point to this workbook in Power Apps, it creates me an app with no problem but it consistently chooses the City, Product and Cust Type (3rd, 5th, and 2nd columns) on the Gallery screen.
Then when I go to the Details or Edit screens, the fields are in this order: 3, 5, 7, 2, 9, 1, 4, 10. That's right; it skips 6 and 8.
It seems a little random. I know I can rearrange or change the columns, but the fact that it always does it the same way makes me think there is a reason that perhaps I can control, BUT when I (in desperation!) rearranged them in the Table to follow that crazy order, (e.g., so Full Name was the third column because I wanted it to be first, etc.), the app still put them in the very same order! City, Product and Cust Type on the Gallery and the columns in the same order on the Detail and Edit screens and the same two columns missing (although they were in a different order).
QUESTION: What do I do to make it pick specific columns in a specific order? What's the rule I can follow on this?
Thank you.
All responses (
Answers (
