Share
ReportI am new to Power Apps I need to recreate a form/app we use for budget change orders. I have attached a screenshot. The two main sections are 1) the general info for the new change order and 2) the editable cost codes chart that looks up budget data and performs calculations.
- The form first needs to look up the Project name, and then in cascading order based off project, Cost Code Description & Cost Code, then columns A and B.
- The rest of the fields are input or calculated fields, such as date and bool fields (Budget Transfer or Scope change) and totals.
- All of the data must be saved to the same table record
- I can’t find a way to create a chart like the attached, where lookup, input, and calculated values based off lookups are all allowed on and to be saved to the same chart. I tried experimenting with a vertical gallery but could not get these field types all in one gallery. I tried using formula fields rather than calculated fields.
- Find a way to connect the visual calculated table/chart lookups to the Project lookup field in the info section (not sure if using the same source is required)
- Save all inputted and selected data to the same record in a table, both from the general information section and chart
Categories:
All responses (
Answers (
3,914
