Summary
In this video, I demonstrate creating a custom field using a formula in DataVerse/Project Power Apps. The formula uses a DateAdd function to add 30 days to the Start Date of the project and place it in the field I just created named Project Charter Due.
Creating the Custom Field Step by Step
- Login to Power Apps via https://make.powerapps.com
2. Scoll down to the Your Apps section, and click on the edit button for the app you wish to edit. In my case I created a solution and app to consolidate my changes named IDEMO1.
3. With the App opened for editing, click on the Data icon in the left-hand navigation.
4. Navigate by clicking on the elipses next to the Project Table, then select Edit Table.
In my app I already added the Project table to the In Your App section in order to consolidate my changes in the app I created.
5. in the Edit Table dialog, click on the plus sign all the way to the right of the screen to add a new column
6. Enter the following into the New Column dialog:
Display Name: Name of your choosing
Data Type: Formula
Formula: DateAdd('Start Date', 30, TimeUnit.Days)
Format: Date Only
Click the Save button when finished.
7. Now Navigate to the Pages section by clicking on the Page icon in the left hand navigation. Then click on the Edit button next to the Projects Form.
8. Locate the field you just created in the Table Columns section, click+hold and drag the column to under the Estimated Start Date field. In my case the field was named Project Charter Due. Click the Save & Publish button when finished, then close out of the App by clicking the Back button.
9. Locate the Project app and click on it's Play button.
10. In the Plans view, click on the New Plan button in the top navigation.
11. Enter a Name for your project (and any other required fields). Click the Save button. Note the Project Charter Due specifies a date 30 days after today's date (the Start Date is automatically populated to today's date if one is not entered).
Helpful Links
