cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Guidance - Unbound Power Apps control fields and display labels dynamically from Dataverse tables

Hi All,

 

I have a requirement that I am working for a client that I am trying to achieve within Power Apps Canvas App and need some advice from Power Apps Experts out here.

 

BUSINESS REQUIREMENTS.

 

Below is part of the Purchase order form that the client is using Excel manually without any form digitization which has 2 cores to be implemented and want to convert using Power Apps Canvas app.

  1.        Vendor Details in Excel 

    01 Vendor Excel.jpg

All 3 vendors must be filled in. If a user fills in only 1 vendor or 2 vendors, then the form should be not filled in.
All 3 rows have to be filled in by the user to proceed.  

  1.        Cost Breakdown for Term Contracts

02 Cost Breakdown for Term Contracts  Vendor Excel.jpg

Another part of the form is the user must fill at least the current year (2021) for the awarded vendor and if he/she knows about future years such as FY2022FY2023, etc, they could add in this part of the form.

The form must have at least 5 years including dynamically from the Dataverse Fiscal Year table and should be NOT hardcoded in the form.

CURRENT DESIGN USING DATAVERSE AND POWER APPS CANVAS APP.

As the form has multiple lookups, I have chosen Dataverse for the data layer and Power Apps Canvas App for the User interface. To meet the business requirements i.e. Vendor Table and Contract Cost Breakdown for Term Contracts, I have created 3 tables (I have more tables to support clients requirements ) as shown below

a) Vendor Table:

03 Vendor Table.jpg

 

b) Contract Cost Break Table:   

 

04 Contract Cost Break Table.jpg


c) Fiscal Year Table:
  

 

05 Fiscal Year Table.jpg

 

06 Fiscal Year Table.jpg

 

 

 Business Requirement 1: Power Apps for Vendor Screen

In this screen, I have simply to use 9 textbox controls and 3 labels which I will put in a collection when I user fill this screen.

 

07 Vendor Screen.jpg


 I could not use Gallery control, or data table controls as I needed to display 3 records/textboxes at the onset to display users on this screen and the user did not fill all the vendor names (all 3 Vendor names) the user should not be able to submit.

QUESTION 1: Is this correct approach to achieve this business requirement 1 i.e. not using Gallery Control / Data Table controls and used unbound text fields?   

To check if all 9 textbox controls are filled or, I will be using IsBlank() and Coalesce() functions and when used fills the all 9 controls, perform the Patch() function at later stage.


Business Requirement 2: Cost Breakdown for Term Contracts

In this screen, I intend to use the collection from the Dataverse Fiscal Year table and place 10 text box controls similar to the vendor screen previously and if the user did not submit the current year (1 st row) then he can't submit as per business requirement  

 

08 Cost Breakdown.jpg

 

QUESTION 2: Is this the correct approach to achieve this business requirement 2?

How could I dynamically display 5-year labels as shown in the Period column on the left?

Please advise on the right approach.

 

Thank you.

@RandyHayes @WarrenBelz @Pstork1 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@RandyHayes ...your video is so useful...digesting it and check which part I use it for my project. 

View solution in original post

5 REPLIES 5
Super User II
Super User II

Hi @aaroh_bits 

It sounds like you want to build your own custom forms.  Start here with @Meneghino 's blog post of how to use unbound controls on a blank screen to make a form when the OOB solution doesn't fit your needs. 

https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/  .  I learned a ton about how PowerApps works by following his example here. 

Thank you @Drrickryp so much for your amazing pointer...lemme check the blog and try to implement in my environment..

Super User III
Super User III

@aaroh_bits 

Also, if you are looking to create your own forms, I would still highly recommend using the built in Forms of PowerApps as they bring an incredible amount of features to your app that building you own forms leaves off the table.  I did a full video on EditForms - everything you ever wanted to know about Forms and some things you might not have known possible.  Perhaps it will be helpful for you as well and save you a lot of time and frustration.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

@RandyHayes ...your video is so useful...digesting it and check which part I use it for my project. 

View solution in original post

Hi @RandyHayes and @Drrickryp , 

 

Thank you so much for your inputs, 

 

I was able meet the cleint's requirements with using Gallery Control and using FirstN to gallery to show only 3 entries and use some  logic and formulas 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (106,872)