cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Axex336
Regular Visitor

Forms -field adding by users

Hi everyone,

 

I am quite new with the power platform and am trying to develop a model driven app for simple project management. For the time being, the app should basically consist of 1 main long form (approx.  100 columns-fields). I have managed to create the form, elements, flows and business rules as I needed, however, I am facing some difficulties.

 

One of the elements that I want to incorporate into the form is for the users to evaluate the case at hand on an annual/quarterly/monthly basis and document whether the costs of that specific project have changed. I want to see the documented changes in that case. Furthermore, I want specific fields to auto calculate the value movements, when the new figure is entered into the same case by the user.

 

I have tried 2 approaches on creating such a function:

 

1 - To add columns - fields into the main form for each year/quarter/month going forward. Whenever the user will update the form, they will just fill be next row in the form for that year. It is easy to set the calculations, in order to get the movement values. The issue with this, however, is that I cannot add infinite fields into the form, for all the months/quarters/years going forward.

 

2 - To create a separate table, with separate form, where the values can be documented. I have set the relationship between in the main tables to the second table as many-to-one and brought in this form into the main form as a subgrid.  This way, the user can click e.g. "add value" button on the subgrid in the main form. New form pops up, and the user can fill that form with the year/quarter/month they are updating and include the value. This is then displayed in the main form in tne subgrid. This approach seems great as the users themselves can add new values as they wish, without the need of having so many fields in the main form, However, the issue with this approach is that I dont know how to pull the latest-current value from the subgrid in to the main form. When I am exporting the data into the excel, I can only export the columns in the main form and not the columns in the subgrid. Also, I dont know hot to create business rules between the two forms which are in two separate tables (if that is even possible).

 

If possible, the best option for me would be to have one form, where the users themself can click a button - "add value" and a new field would pop up in the main form where they can enter the data, as they wish. The data is stored in the main form. 

 

Could anyone be able to help me with this? I have tried Google, YouTube, Microsoft, etc, however with no success in finding anything on this. I would appreciate any guidance on this - even if just providing me with the name of the thing that I am looking for :)) 

 

Thank you and regards,

AX

 

 

5 REPLIES 5
cchannon
Multi Super User
Multi Super User

You don't want a dynamic field addition capability on one form. It is possible but it would take a lot of custom code and would be difficult to maintain.

 

Your second option there is much more scalable and maintainable, you just need some more tools that are already in the platform. 

 

There are a few ways you might do this, but I think the easiest one is just to bring a Power Automate Flow into the story. Have a Power Automate Flow run whenever a new "costs" line item is added (I assume these are always added chronologically). Then that flow runs, finds the "Project" the cost is associated to and sets a new relationship--let's call it "current cost"--to the cost line that was just created. Now from "Project" you have a lookup to the specific "Cost" that is the current, or latest one. From here you can use a Calculated Column to display the cost from the "Current cost" on the Project form, or you could use a Form Component Control or a Quick View Form to display the data from that one record quickly and easily.

Great, thanks a lot for the reply and feedback. That makes perfect sense. 

 

Is it possible to create an automated flow in model driven apps without creating a business flow first. I dont think it would make sense to incorporate a business flow, given that this will be a repetitive process where the user will be updating one case in the main  form, through adding updates in the "subgrid" though a second form. Could I also use power automate to pull the automatically generated ID from form the main form into the newly created update in the sub form (this way I would know to which case the updates relate if anything goes wrong)?

 

What do you mean by maintainable?   Maybe it would be the easiest for me to just create a main form with multiple columns (e.g. for 10 years going forward) and then the user would just fill in the column for that relevant period. Once the space runs out, I could add additional columns to the main form. 

 

Thanks again and best,

AX

Yes, Power Automate Flows and Business Process Flows are two entirely different things, and they do not rely on each other. Power Automate Flows are an automation tool that let you inject arbitrary logic anywhere into the running operation of your business. You can read more about them here.

 

If you are only doing one per year, then yes, it is possible to just add 10 fields or whatever and that would be maintainable (I was assuming you needed more frequent data entry than that). But, it would be a mediocre user experience to have years 1-10 listed out in fields on the form and just ask the user to pick the right field (spoiler alert: they often won't). You could make this a bit better by using Business Rules to hide/show fields based on what is populated, and to lock fields once they've been filled out so people can't overwrite past entries. That would help, but you should also validate that with the business... they might have complex conditional rules that govern when you can and cannot update a previously entered value.

I should also add that, as a professional developer, my preference in situations like this is still always to use the related entity, even if I know that "10 columns will cover me for 10 years" or something like that.

 

There are three reasons for this:

  1. By pushing the entry off onto a related table, you enable each entry to store its own metadata, such as the exact date and time it was entered, who entered it, or even custom values like what is the "type" of entry.
  2. It makes it readily possible to capture events that you might want to know about in the future, such as when a new value is entered, or when a prior year gets updated
  3. And it provides you with some convenient manipulation options, such as the ability to deactivate entries more than 2 years old, or to quickly calculate a total for all entries on this record less than 4 years old and created by Jane Doe.

In your specific case, it sounds like just sticking 10 columns in the form is a perfectly adequate option (as long as you control the UX with Business Rules), I am just trying to give you ideas for the next time. Happy coding!

Axex336
Regular Visitor

Great. Thanks alot for your recommendations Cchannon. I agree with your comment. The power automate solution does sound much better and user friendly. I have tried implementing this, however, I dont have any ideas on how to bring power automate into a model driven app. I was also unable to find anything good online. Based on the research that I did, it seems that the only way to implement power automate into the model driven app. 

 

Do you maybe have any materials/open treads on this that you can share? 

 

Best

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (1,144)