Hi,
Using Power Apps, I have created a submission form (canvas app) from scratch. The purpose of this form is to allow customers to raise requests for tool maintenance, repair, or scrap.
The form follows this process:
- On the "Request Page," the user selects the "request subject" from available options.
- After selecting the request subject, the user is redirected to the "Table Page" to fill in the required details.
- The details entered on the "Table Page" are stored in an online Excel table named "Scrap_Request_for_INVENTORY1." This data is simultaneously displayed in the Power Apps data table controller named "DataTable1."
- The columns in the "Scrap_Request_for_INVENTORY1" Excel table are as follows:
- Work Order
- Serial Number
- Scrap code
- Approved by Supervisor (if above $1K)
- Location/Owner
- Has the RCE been approved?
- Once the user has completed entering the details on the "Table Page," they are returned to the "Request Page."
- On the "Request Page," the user can enter additional information in the "request description" field, which is a rich text editor named "DataCardValue5."
The specific requirement I am trying to achieve is to insert or embed the tabular data (the filled table from step 4) into the "request description" field ("DataCardValue5") on the "Request Page."
Finally, earlier entries will be sent to a SharePoint list, and then using Power Automate, emails will be sent out.
@RezaDorrani - it would be great to have your opinion.