Power Apps

Projects and Project spare parts

(0) Share

Report

Posted on by craigfer

I am building (or trying to build) and app that will allow users to add a Project

First part is going ok. I have mapped this form to update my Sharepoint list with the projects

NewForm(Form1); UpdateContext({ newMode: true });
 
I have two Sharepoint lists MIR Project and MIR Materials there's a lookup column so I can manually add materials and link them to the MIR Project
 
If I select the Project from the Gallery and then click the "Materials" button I am only shown that project 
 
"Materials for PROJECT: " &RecordsGallery1.Selected.Title
 
What I need to do now if have the ability for the user to add multiple materials to the slected Project
 
The values are
SAP ID (number)
Description (letters)
Qty Required (number)
UoM (Unit of measure letters)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can create a collection that saves these materials and post them when you are saving the form.

I have used the following video as a reference: https://www.youtube.com/watch?v=76RJyaoW0BQ

Everything is same but instead of saving the gallery on its own, use that code when saving the form.

Was this reply helpful? Yes No
craigfer 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response. I will look at the video.

I only want the user to be able to load materials to a specific project. How can I do this?

Was this reply helpful? Yes No
Suggested answer

Rajvinder 5 on at

Like (0)

Report
Copy link

Link copied!

If I understood your question correctly, you want to filter the material gallery for selected project.

When adding new material set the DefaultSelectedItems property of lookup column to

{ Value: Lookup('MIR Project' , ID = gallery.Selected.ID).ID}

Apply filter on item property of the material gallery for lookup filed equals to selected project.

Was this reply helpful? Yes No