Hello Everyone,
I'm currently facing a challenge with a section of my app and would appreciate your insights. Here's an overview of my project's structure:
- Project Portfolio: This is a dynamic list where new projects are continuously added. Each project entry includes several key details, such as the project's unique ID, name, start date, and an associated image.
- Variant: This list is interconnected with the 'Project Portfolio'. It retrieves and displays the project ID and name from the 'Project Portfolio'. Additionally, each entry in this list includes a specific description of the variant.
- Investments: This list also links back to the 'Project Portfolio' for reference. It includes detailed rows outlining various aspects of investments, such as the description, quantities, two types of VAT (VAT 1 and VAT 2), and two separate percentages (Percentage A and Percentage B).
Based on a dropdown menu the gallery filters out the projects and what variants are connected to that project:
Filter(Variant, 'Id (ID)' = LookUp('Project Portofolio', Projectname = Dropdown1.Selected.Value).'Id (ID)')
I'm progressing with my app and have reached a point where I need some assistance. I'm currently working on a button: a button labeled with a plus sign ("+"). That adds records based on the selected projectname & id, it needs to add a new record in the list variant.
Functionality: When a user clicks this button, it should create a new record. The creation of this record depends on the selected value from a dropdown menu, which lists project names.
Expected behavior: Upon selection of a project name from the dropdown, the new record should be added to a specific list. This record will automatically include the project's ID and name (sourced from the dropdown selection), but it will initially have empty fields for 'variant name' and 'description'.
Issue: Despite my efforts, I'm encountering difficulties in making this feature work as intended. The button doesn't seem to create the new record correctly, or at all.
I would greatly appreciate any insights or suggestions on how to resolve this issue. Thank you in advance for your help and time!

Report
All responses (
Answers (