Hi, I have an Excel based app. All fields are displaying correctly, apart from one. The field is "Supplier", which should be the name of a company. However, on the Fields pane to the right, the "Supplier" card is marked with "123", instead of "abc", as it should be. Therefore, on the app itself, "Supplier" returns a vlue of "0". There is some text saying "To edit this card, go to advanced options", but I can't see anything obvious as to how it can be changed. Thanks
What is the format in Excel of this column? Please check if there is any setting different from other columns.
Thanks Mona, yes the column is set up in Excel the same as the others. In Excel, it is displaying the colunn correctly as text. In PowerApps, the title of the column appears, but all fields read "0".