I need to display percentage based on gallery label text value, please refer below screen for your better understand...
I need to 23% in Phase 1 text box it should consider % Completed text value in Gallery when Phase Name = Planning.
Go to Solution.
Hi @ShaikSayyad ,
Would you like to populate the Phase 1 TextInput box with the average value in the the Gallery?
If so, you could apply below formula in Default of the Phase 1 TextInput box, modify with your data source in the gallery and column names:
Concatenate(Text(Round(Average(Filter(GalleryItems,'Phase Name' = Planning),'% Completed'),0)),"%")
Hope this helps.
Community Support Team _ Jeffer NiIf this post helps, then please consider Accept it as the solution to help the other members find it.
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.