Answered

PowerApp to populate Dataverse Table

(0) Share

Report

Posted on by LCP0716

I'm pretty new to PowerApps and am in the middle of building a new app that will collect Safety Alerts for my company and store all responses submitted in a Dataverse table titled 'Safety Observation Databases'. In general, a User is submitting either a Safety Notification or a Safety Recognition and they have to select their Name, Site, Service Group, Shift, Cost Center, and Work Center.

In the background I have added an Edit Form with the datasource set as the 'Safety Observation Databases' and am using the column field's Default property to record the entry with something like: Dropdown_Shift.Selected.Value or if it's a text input field (NotCorrectWhy) where the user is typing in an answer about why something isn't correct then the Default property to record the entry is: NotCorrectWhy.Text. Ultimately when someone completes filling out the app they hit the submit button whose On Select property is set to: SubmitForm('Safety Observation Database'), which effectively writes a new row into that Dataverse table.

The issue is when it comes to a Choices type column, it doesn't take the value selected into the form. I tried these two and neither works. Help!?!

A dropdown titled Dropdown_SvcGrp with the Items property set to ["","00FSG","00HPG","00VSG","0RMWG","00EP","00CRP"] and then the Edit Form data card for the Service Group field's Default value set to Dropdown_SvcGrp.Selected.Value.
A combobox titled ComboBox_SvcGrp with the Items property set to Choices('ServiceGroup (Safety Observation Databases)') and then the Edit Form data card for the Service Group field's Default value set to ComboBox_SvcGrp.Selected.Value.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LCP0716 - When you add a DataCard for a Choices field into your EditForm, everything is already set up for you.

What reason was there to modify the DataCard (and the ComboBox inside the DataCard) in the first place?

Was this reply helpful? Yes No
LCP0716 13 on at

Like (0)

Report
Copy link

Link copied!

Because the User is selecting their service group from the possible choices. I want whichever value they select to be what is written into that submissions row in the table. There is no data in the table right now at all. I am a novice so perhaps I just don't know how to do this.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LCP0716 - As I understand it, your data source is Dataverse. You have inserted an EditForm control into your app. You have added several fields into the EditForm. One of these fields is a Choices field called "Service Group".

You want to save all completed DataCards back to your Dataverse table, but the selected Choice from the "Service Group" DataCard is not saving.

Is that correct so far?

Was this reply helpful? Yes No
LCP0716 13 on at

Like (0)

Report
Copy link

Link copied!

Yes that is correct, although to be fair I haven't submitted a form at all yet b/c I was still trying to build out all the other input options that I want the User to interact with first. The other datacard values change as I test the app and show the input or selected value. Any field that is based off a Choice type column though I cannot get to work.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LCP0716 - If you simply remove the DataCard for that Choices field, and then insert it back into your EditForm control (without making any modifications), then populate your Form with selections, and then click the Submit Button, the data should save back to your data source.

If there is something else you're trying to do other than that, it is not clear to me yet.

Was this reply helpful? Yes No
Verified answer

LCP0716 13 on at

Like (0)

Report
Copy link

Link copied!

I understand what you are saying, but you are missing my intent. The Dataverse table is blank but has designated columns for each record that will be submitted through the Power App. However, I'm not providing the Edit Form and associated data cards as visible fields, I'm merely providing other text input boxes, dropdowns, and combo boxes for the user to input information. Then each of those inputs is linked to the EditForm controls and for each individual Data Card I am setting the Default property to capture the input, for example: Dropdown1.Selected.Value or InputText.Text. The choices column of the table was giving me trouble, but I figured out that you can use the formula {Value: "the value"} in the Default or DefaultSelectedItem property and it captures what the user selects.

So here's an example. First my user decides if the notification they are submitting is a Behavior or a Condition from the radio button labeled "Rad_NotificationType". I want that selected value to be recorded into the table under the Choices type column named "ObsType"

Within the EditForm control, for the Datacard of the "ObsType" I unlocked the card and set the DefaultSelectedItems property to {Value: Rad_NotificationType.Selected.Value}

So I solved this myself, hope it helps others!

Was this reply helpful? Yes No