web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps calculations based on ...

Power Apps

Answered

calculations based on gallery inputs

(0) Share

Report

Report

Posted on by ShaikSayyad

111

Hi

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.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Join the conversation