Unanswered

Add multiple records from a drop down

(0) Share

Report

Posted on by AshleyTaylor

Hi All,

I am in the process of moving from MS Access to Power Apps. I have moved all my tables to Dataverse and correctly established the relationships between all tables.

I am now trying to replicate the form I used in Access to assign Tools to an Assembly (Please see attached example Access form and my ER Diagram)

As per the attached example form, the top section was used to view/edit tblAssemblies - I have replicated this in Power Apps without issue.

I am however facing difficulties with the lower half of the example form. This shows the Tools assigned to the selected assembly, I have replicated this in Power Apps by creating a gallery and Filtering based on the relationship between tblToolsForAssemblies and tblAssemblies.

This works as expected but I now need to establish the best way to Add/Edit/Remove Tools assigned to an Assembly.

In MS Access, I achieved this by have a multi column drop-down which was linked to tblTools. By doing this when the user is assigning Tools they only had to click the next blank row and choose from the drop-down and then set Tool quantity.

Can this be achieved in Power Apps with out having to use an edit form and submitting new records individually?

Thanks for any help

ER diagram.pdf

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @AshleyTaylor ,

As excel styled "Can this be achieved in Power Apps with out having to use an edit form and submitting new records individually?"
Answer is No, But you can get something similar experience like the one explained in this YouTube Video.

Do check it out and feel free to ask further questions

Hope this helps!

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R

Thanks for the reply!

Indeed the video you posted does seem like a good solution. I am however struggling with the dropdown that shows the user the available tools by TCN Number.

I have created a gallery and set the data source as tblToolsForAssemblies and then as per the video and added a drop down with the datasource set as tblTools. For some reasons I can only see around 30 records (I have over 700 in my table)

Thanks

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @AshleyTaylor ,

1. Click on the dropdown control.
2. Navigate to the right panel of properties. There you will see fields to show in dropdown.
3. Select that and add your ColumnName that you want to display in dropdown.

This will fix your item text of dropdown.

Coming on count of dropdown, you cannot guarantee those many numbers coming always since its too large.
You can use classic combobox control with filters and search enabled.

Hope this helps

Was this reply helpful? Yes No