Unanswered

Field displaying incorrectly

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Screen Shot 2017-08-30 at 14.43.29.png

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

What is the format in Excel of this column? Please check if there is any setting different from other columns.

Regards,

Mona
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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".
Jason_Hough 119 on at

Like
a
(0)

Report
Copy link

Link copied!

Find the padlock icon and unlock the cell in powerapps and you should be able to change the type.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Jason_Hough, I've unlocked it but what do I need to alter? Please see below.
Jason_Hough 119 on at

Like
a
(0)

Report
Copy link

Link copied!

have a look in data - your deffo on the right track.