Dynamics Community Forum Thread Details

Canvas Power Apps - Populating Dataverse Table with a Form in a Power App

Hello,

I'm not sure if this is the right forum to post this, but it is linked to Dataverse integration, so I am posting it here.

I am having issues with a Canvas app that I have created in my business environment. The app's purpose is to provide a user-friendly UI of a timesheet system we use in the business, and also provide a form where the staff can input their time sheets.

The data types for the form controls vary, and this is where I am having my issues. The text inputs work and create the records in my Dataverse table: 'Timesheet Entries'. However, I am using a combo box form control to list choices for a choice column that I want to update in my Dataverse table - for context the choice column is named 'Job Type' and this lists a group of job types that the staff can choose to put time against.

I am also having issues with updating a 'Lookup' column that I want to update. I want the staff to be able to select an 'Account' name and put time against that also. I am not entirely sure how lookup columns work in this scenario.

I am using a button to submit the form once completed. Once the form is submitted, I go to my Dataverse table and see that all the columns linked to the 'text input' controls in my form have been successfully populated - but no choice columns and the account lookup columns have been. Here is an image below of my form for reference.

Any help on this would be greatly appreciated, I have been attempting to grow my knowledge using Copilot which isn't totally accurate, so any advice on what training on D365 and PowerApps would be great as well.