Announcements
Hello,
Text on my dropdown is different from the sharepoint list.
It should be just the year as it is shown on Sharepoint, however it has a dot and lots of zeros.
Someone can help on that?
@gerpro
If 'Ano' is a SharePoint calculated column, that's a possible explaination for this behaviour.
http://powerappsguide.com/blog/post/sharepoint-beware-of-calculated-columns
The following formula should hopefully return just 2022.
Round( Distinct('Previsao de Faturamento';Ano); 0 )
@timl thanks for your reply. Indeed, 'Ano' is a calculated field. It is the year I calculated from date. Tried your sugestion and only the dot fade away. Zeros are still there. I'm going to dig a bit more on the link you pasted. Thanks
Included text with the format "####" on calculated SHP column and it worked.
Hi @gerpro,
Glad that you have resolved your problem.
Please mark your reply as an answer so that more users who may have the similar issue could find this solution.
Thanks for your cooperation.
Thanks for the tip @v-qiaqi-msft . I'm new on this community. Have a nice week.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
