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 / Power Apps newbie trou...
Power Apps
Unanswered

Power Apps newbie trouble with having numerical values connect

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

My team and I are trying (being the operative word) to create an app where we can estimate the effort of how long we take working on specific project depending on what elements of interactivity or level the project is in.
All the data is sourced in an Excel. We created a scene with a drop-down menu for the user to select a category with the tasks that they would be completing during the creation of the project and each task has a numerical value in minutes.
We do not know to connect the numerical value to the selection of each task.
We have tried inputting the data from excel and also from a SP list pulled from the excel sheets, but I'm guessing it is the way that the information is displayed,that the app doesn't know where to choose from, is the data to be entered manually in the app and a formula needed to make the connection?

We are very stuck and do not know how to continue. Attached is the excel sheets with the info. I apologize if the way I'm asking is confusing.

If there is anyway someone could help us out, that would be great!

Regards,

Melissa Casasola

Categories:
I have the same question (0)
  • 365-Assist Profile Picture
    2,327 Moderator on at

    Hi Melissa,

     

    Good question. You are correct it seems your data is not quite in the format that Power Apps likes. You need to break out each record into its own row then in Excel create a Table.

     

    I have uploaded your spreadsheet but this time added a new sheet ("New Table). I broke down a sample of the data as it should look. I also created it as a table in Excel called Table1.

     

    You could also do the same in a SP List if its easier.

     

    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • MelissaC Profile Picture
    Microsoft Employee on at

    Hello,

    Thank you very much for your advice, we had thought about splitting up the info but the other part we are facing is that we need  the user to  select interactivity and specific tasks that apply to their project, these tasks have specific numerical value in min, these values can be added to show a final sum result of all the things they selected.

    How can we go about doing this, is there a formula we need to use, how do we add all the values? How do we connect the numbers?

    Thank you for your continuous help,

    Melissa C

  • 365-Assist Profile Picture
    2,327 Moderator on at

    Your going to have trouble doing this in Excel. It would be easier to manage the data if your datasource is either a Microsoft 365 List or Dataverse.

     

    That way you can create 2 Lists\Tables .

    - Projects

    -Tasks (That have a relationship\Lookup to the Project).

     

    You could create 2 lists in Excel but would need to manage the relationship between the 2 Lists\Tables.


    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • MelissaC Profile Picture
    Microsoft Employee on at

    Thanks again for the suggestions Darren,

     

    Is there anywhere you recommend we can search to learn about making Microsoft 365 lists of about Dataverse?

    With it staying on Excel with just relating the tables in the Excel how do we translate the data to Power Apps how do we pull that info there? is there a specific formula in the Power Apps platform that we need to use to corelate the data? Or do you suggest for us to set up the info on the tables differently?

    Thanks again,
    Melissa...

  • 365-Assist Profile Picture
    2,327 Moderator on at

    There is a couple of great videos on what is Dataverse that may help.. 

    Introduction to Microsoft Dataverse in Power Apps | Build Tables & Relationships | Beginners Guide - YouTube

    Microsoft Dataverse Intro in 20 Minutes #Dataverse - YouTube

     

    If you want to relate Tables in the Canvas Power App you will have to create Collections and link them that way. 

    Here is a video that gives some explenation. Power Apps Collections Basics - YouTube

     

    In summary sounds like you need a bit more training to be able to take your App to the next level.

    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard