Dropdown Value Formatting

[sgrrdy]

Hi All,

I am trying to create a Price Card and my Data source is an Excel file.

I have created a dependent drop down list and the value inside it should return in Currency format, instead its showing in Date, Time format.

 Format in Excel file

Returned Format in Power Apps

Would appreciate the help.

Kind Regards

Sagar

[Drrickryp · Accepted solution]

@sgrrdy 

PowerApps does not capture Currency type columns from Excel correctly nor any calculated columns.  It basically accepts only simple text, numbers and date/time formatted data.  The currency formatting is done from within PowerApps after numeric data is found.  I suggest copying your table in Excel to a new table but without the last column that is added by PowerApps.  Reformat your data as text, number and data/time types.  Make sure that the first line below the column headers contains data in all columns and none of the column headers contain spaces or unusual characters. Then reimport the new table and take 10 minutes to watch Shane Young's video here: https://www.youtube.com/watch?v=RtmZM3tm2Zs 

[sgrrdy]

Hi @Drrickryp,

Thank you for the info. Will try it out.

Regards

[sgrrdy]

Hi @Drrickryp Didn't have to copy the data into a new table. Just reformatted the currency into text in the same table and it was updated in the PowerApps. Now it shows as plain number.

Thank you very much  with the help.

Have a wonderful day ahead.

Regards 

Sagar