I 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
These are the main issues I’m facing:
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
You have not attached a chart showing your issues.
Also, it is probably better to paste in images rather than require media to be downloaded to be viewed.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
3,847
