Unanswered

Create intake request form based off of combobox selections

(0) Share

Report

Posted on by glower power

161

Hello, I have a Canvas PowerApp with a few dozen pages that ultimately allows a user to pick a specific action they would like to request from Oracle driven combo boxes, check boxes, and free text fields. My concern is that I have to start over and approach this as some kind of intake form template but the hope is I can use what I already have. Rough diagram:

Initial Main menu page with "New Request" button -> Navigate to Request page where you Pick your request type from combo box and click Next -> based on type selected, navigate to one of several pages, fill out several combo boxes, free text fields, check boxes and click "Submit" button.

Question 1: How can I use all the values that are selected by the user (request type and all the specific data points) in the combo boxes from multiple pages in my App to build a Sharepoint list or form or card or really just something to clearly articulate all the selected data to someone reading an intake request form?

Question 2: Is there a way for a user to track their requests in the Powerapp interface after they are submitted, modify, delete? Do I have to build the app from start in a different fashion? The main goal is to not give a user a massive form with all available selections, hence why I wanted to build a multipage app...

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

EddieE 4,641 Moderator on at

Like (1)

Report
@glowerpower

You can reference the ComboBox controls in a Patch statement on your Submit button to build a SharePoint List item, eg

Patch( yourListName, Defaults(yourListName), { colName1: First(ComboBox1.SelectedItems).Value, colName2: First(ComboBox2.SelectedItems).Value, colName3: First(ComboBox3.SelectedItems).Value //, add more columns here that are needed } ) // NOTE: .Value maybe incorrect, use the app Intellisense to guide your selection here // Also, I've assumed that all ComboBoxes are Single selected and NOT Multi select

Once you have the data in a SP List you can then

- display it back in your app on a different screen

OR

- use the SharePoint standard form to view / edit it

The choice is yours really

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
Hi @glowerpower

For question 1, as your user goes through the app or form and fills out data, upon submission you can patch that data to a SharePoint list. You could then either have another app for those working with that information, or allow them to simply use the SharePoint list to manage the rest of the process.

A formula for that would look something like this:
Patch('SharePoint List',{Column1: TextInput1.Text, Column2: Dropdown1.Selected.Text...})

For question 2, yes you can do that by setting a variable in the app OnStart property that captures the user's email. An example formula for the OnStart would be
Set(varUserEmail, User().Email)

Then, for the gallery where you want to show the user's submitted items, you can filter by that email:
Filter('Sharepoint List','Created By'.Email = varUserEmail)

In that gallery you can add icons to edit the submission, patching the changes to your same data source.

Was this reply helpful? Yes No