Unanswered

Canvas Apps - Application to Submit Timesheet Entries

(2) Share

Report

Posted on by JamesJenkins

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.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (5)

Answers (0)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (1)

Report

Normally when using Lookup columns in a standard form using Submit everything works.

Show any errors that you are having, the definition of the choice/lookup fields and the problematic code.

Was this reply helpful? Yes No
MichaelFP 1,847 Super User 2025 Season 2 on at

Like (1)

Report

Hi

the card that are you handling the Lookup for the account in the form, is a custom card or OOB that was added when you selected the field to be displayed on the form.

If you created by yourself you need to use the Select option from combobox and the using a Patch to set this value.

Was this reply helpful? Yes No
JamesJenkins 21 on at

Like (1)

Report

Thank you for your responses,

The main error I was getting is 'Expected OptionSetValue value' when trying to submit the form.

I did some research, and I changed my columns in Dataverse to simple text, and not choice columns as you can create the choices within PowerApps (no need to complicate things further).

I thought this would fix the issue, however it still says 'Expected OptionSetValue' although the target column is now a simple text type????

To answer your questions, the lookup column was a custom card, so i will most likely need to use the patch function as you suggested. However it gave me error in patch function of 'Expected OptionSetValue', there is no escape!

Is it just bugged, should I restart making the app? It may be that I changed the column type during the making of the app and it's now confused? And by the way I did refresh the data source after each change I made in Dataverse.

Ideally, I want combo boxes for each field, that can connect their items to a collection made in the OnStart property with necessary columns added. And then filtered in the 'Items' property based on the previous text inputs. The available items will be selected from the dropdown in the combo box (with SelectMultiple false) and submitted back to the dataverse.

Can an input from my combo controls be outputted to simple text?? I assume by using the Text() function.

The main issue I was encountering was the data type values not matching, rather than any setting up of the form.

I am new to this so any suggestions will be great, thanks for your help already.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

What the columns in timesheet entries?

Is there a job type column which is defined as a lookup to a job type table or is this a choice field where you entered the values in Dataverse?

How is the account name defined? Is there a table of account name and timesheet entries links to it as a lookup?

Why are you using collections? Are you trying to hard code the combo box options?

If you did it in this manner where you are updating a text field with an option from a combo box then you have to set the update property of the card to something like DataCardValue.Selected.Value and the Datafield property to the name of the text field.

Submit would then update the form.

Ideally, I want combo boxes for each field, that can connect their items to a collection made in the OnStart property with necessary columns added. And then filtered in the 'Items' property based on the previous text inputs. The available items will be selected from the dropdown in the combo box (with SelectMultiple false) and submitted back to the dataverse. - Not quite understandiing the filtering requirements.

Personally, I would go back to using Choice and LookUp columns as it would require less customization to your forms.

Was this reply helpful? Yes No
JamesJenkins 21 on at

Like (0)

Report

Thanks for your help everyone, I have now fixed my application.

I used the patch function to directly enter the records as I was dealing with Lookup Columns.

Was this reply helpful? Yes No