web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using record excel in ...
Power Apps
Answered

Using record excel in order to fill circle

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have an excel file with RGBA code and I don't know how to fill circle with record for any values red,green,blue the 3 value are in different collum. I do that in excel because my app keep the value that user can change in the app for customise color.

 

ScreenExcel.PNG
Categories:
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

    Could you please share a bit more about your scenario?

    Do you want to fill a Circle Icon control with RGBA code values (Red, Green, and Blue) from your Excel table?

    Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

    The data structure of my Excel file as below (whose data has been formatted as a Table😞8.JPG

    Note: The Excel file stored within my OneDrive folder. On your side, you could consider save your Excel file into your OneDrive folder (or OneDrive for Business, Dropdox, etc), then create a connection to the Excel file in your OneDrive folder from your app.

    The App's configuration as below:9.JPG

     

    10.JPG

    Firstly, create a connection to the Excel file in your OneDrive folder from your app.

    Add a Gallery control within your app, set the Items property to following:

    ColorTable /* <-- On your side, you should type your RGBA code Excel table */

    Within the Gallery, add a Circle control, set the Fill property of the Circle control to following:

    RGBA(ThisItem.Rouge, ThisItem.Vert, ThisItem.Bleu, 1) /* <-- Rouge, Vert and Bleu are all columns in your RGBA code Excel table*/

    Best regards,

    Kris

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you very much for the help you gave me and you have identified my problem, thanks to you I filled the circles with the colors of my spreadsheet and allow a customization of the bottom of my screens.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard