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!
Solved! Go to Solution.
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"
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
Choose the pen icon firstly, then choose drop down to insert.
Choose the pen icon firstly, then choose textinput to insert.
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})
Best regards,
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"
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
Choose the pen icon firstly, then choose drop down to insert.
Choose the pen icon firstly, then choose textinput to insert.
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})
Best regards,
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |