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:

Connecting to Data

All responses (3)

Answers (0)

Suggested answer

Rajvinder 5 on at

Like (0)

Report

Projects and Project spare parts

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.
craigfer 8 on at

Like (0)

Report

Projects and Project spare parts

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?
narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report

Projects and Project spare parts

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.