Dataverse Table Help

Question

Hello Team,

I hope you are all well, and you can provide me with some idea of what I need to do to get around this issue I’m experiencing. First of all this weekend is the first time I’ve sat down and tried to write a decent(ish) Power App. I’ve used web searches for most of my issues, but this one has perplexed me, and I’m not sure how to word my search so any pointers would really be appreciated. 

I’m building a Canvas Power App using Dataverse tables. The app I’m building is a club database, which allows you to add students, create classes, then assign students to the class. The issue I’ve ran into, which has been scratching my head is thus;

I have a table which is used to store classes which get created in the app.

I then have a form on a page so I can add attendees to the class generated in the table above.. When I go and select the class created in the table in the app I can only select the Class ID (which is hidden in the screen shot above). I think it is because the other two columns “Class Type” and “Class Instructor” are populated from other tables. If I add a test column into the table and add in random data I can then use that to select from a drop down list in the form I have created.

How would I get around this problem. Initially I thought about another column which contains a mixture of data from the Class Date and Class Type column. I tried to add a function, but I couldn’t get it working.

Any thoughts or pointers would be appreciated.

Answer 1

Hi, David

No worries. Pleas feel free to post questions in our community if you have any Office 365 issues.

Have a nice day,

Sincerely,

Alex | Microsoft Community Moderator.

Answer 2

Hello Alex,

My apologies. I'll post this question there. Thank you.

David.

Answer 3

Hi, David

Good day!

Thank you for posting to Microsoft Community. We are happy to assist you.

According to your detailed description, the issue of your concern that relates to the Power App.

Since we're Office 365 Outlook tech support team, we're afraid that we could not give you an appropriate answer.

Therefore, we would like to refer you to the right place - Microsoft Power Apps Community who are the professional team that dedicating into Power Apps with rich experience and more resources.

We believe they will give you a quick respond and assist you as soon as possible.

Thanks for your precious time and your understanding and cooperation would be highly appreciated.

Sincerely,

Alex | Microsoft Community Moderator.