cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chudson002
Helper IV
Helper IV

NEED APP TO PERFORM LIKE INFOPATH

Hi Community,

 

Have a SharePoint list that needs an explanation for actions not meeting deadline.  Have a dropdown with a few pre-populated reasons and also a comment field for additional info.  Here's my problem...within the app, need the list to look like a table with records already listed, a drop-down next to each record and a text input box for the reason.  Upon submit, info will populate SharePoint.  Was able to do with Infopath.  Tried using a data table and gallery.  Doe anyone have a step by step "how to" for this to be achieved?

 

Thanks!  

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @chudson002 ,

Do you want to create a custom form for sharepoint with these controls:
a table with records already listed;

a drop-down next to each record;

a text input box for the reason?

If so, you could perform like this:

1)in sharepoint list, choose "customize forms"

10151_LI.jpg

 

2)create a new screen named Screen1

3)in screen1, insert a gallery

set the gallery's Items to your listname

insert a drop down and a textinput inside the gallery

10152.PNG

  Choose the pen icon firstly, then choose drop down to insert.

  Choose the pen icon firstly, then choose textinput to insert.

10153.PNG

 

4)Could you tell me where do the pre-populated reasons in the drop down come from?

I assume that it comes from reason field in the list, and it's text type.

Then you could set the drop down's Items like this:

Distinct(yourlistname,reasons)

5)To save the reasons that you select in the drop down and the additional info in the textinputs, you could set the arrow button's OnSelect like this:

Patch(yourlistname,ThisItem,{reasons:dropdownname.Selected.Result,comment:textinputname.Text})

10154.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yutliu-msft
Community Support
Community Support

Hi @chudson002 ,

Do you want to create a custom form for sharepoint with these controls:
a table with records already listed;

a drop-down next to each record;

a text input box for the reason?

If so, you could perform like this:

1)in sharepoint list, choose "customize forms"

10151_LI.jpg

 

2)create a new screen named Screen1

3)in screen1, insert a gallery

set the gallery's Items to your listname

insert a drop down and a textinput inside the gallery

10152.PNG

  Choose the pen icon firstly, then choose drop down to insert.

  Choose the pen icon firstly, then choose textinput to insert.

10153.PNG

 

4)Could you tell me where do the pre-populated reasons in the drop down come from?

I assume that it comes from reason field in the list, and it's text type.

Then you could set the drop down's Items like this:

Distinct(yourlistname,reasons)

5)To save the reasons that you select in the drop down and the additional info in the textinputs, you could set the arrow button's OnSelect like this:

Patch(yourlistname,ThisItem,{reasons:dropdownname.Selected.Result,comment:textinputname.Text})

10154.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,583)