SPList Data Viewing

%3CLINGO-SUB%20id%3D%22lingo-sub-1599870%22%20slang%3D%22en-US%22%3ESPList%20Data%20Viewing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599870%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20moving%20some%20of%20our%20forms%20into%20SPLists%2C%20however%2C%20some%20of%20them%20are%20lengthy%20and%20may%20only%20have%20a%20few%20fields%20entered.%20Our%20current%20system%20allows%20us%20to%20view%20the%20entry%20and%20only%20see%20the%20fields%20that%20were%20filled%20out%20so%20you%20dont%20see%20alot%20of%20blank%20information.%20It%20looks%20very%20clean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20any%20suggestions%20on%20how%20to%20better%20%22View%22%20or%20%22Present%22%20the%20line%20items%20without%20going%20to%20the%20SPList%20itself%3F%20PowerBI%20isnt%20an%20option%20right%20now%20due%20to%20licensing.%20I%20am%20looking%20into%20Tableau%20but%20might%20be%20overkill.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20also%20thinking%20about%20just%20going%20with%20MS%20Forms%2C%20especially%20with%20the%20branching%20logic%2C%20but%20I%20like%20the%20data%20fields%20SPList%20provides.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1599870%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603619%22%20slang%3D%22en-US%22%3ERe%3A%20SPList%20Data%20Viewing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765016%22%20target%3D%22_blank%22%3E%40CWRRT%3C%2FA%3E%26nbsp%3BHave%20You%20tried%20to%20customize%20the%20SharePoint%20Forms%20using%20Power%20Apps%3F%26nbsp%3B%26nbsp%3BIt%20gives%20you%20many%20opportunities%20to%20customize%20your%20forms.%3C%2FP%3E%0A%3CP%3EYou%20can%20read%20more%20about%20it%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fcustomize-list-form%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fcustomize-list-form%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%20Magnus%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604061%22%20slang%3D%22en-US%22%3ERe%3A%20SPList%20Data%20Viewing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765016%22%20target%3D%22_blank%22%3E%40CWRRT%3C%2FA%3E%26nbsp%3BI%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7661%22%20target%3D%22_blank%22%3E%40Magnus%20Goks%C3%B8yr%3C%2FA%3E%2C%20either%20a%20customised%20form%20with%20Power%20Apps%20or%20even%20a%20standalone%20Power%20Apps%20form%20using%20the%20list%20as%20your%20data%20source%20is%20the%20way%20to%20go.%20There%20are%20a%20lot%20of%20good%20videos%20about%20this%20on%20YouTube%20by%20Shane%20Young%20so%20have%20a%20look%20for%20those.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607166%22%20slang%3D%22en-US%22%3ERe%3A%20SPList%20Data%20Viewing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7661%22%20target%3D%22_blank%22%3E%40Magnus%20Goks%C3%B8yr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20this%20for%20data%20entry%2C%20what%20I%20am%20looking%20for%20is%20more%20in%20regards%20to%20data%20viewing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20found%20a%20solution%20with%20Forms%20Pro%20and%20using%20some%20automation%20to%20feed%20to%20a%20SP%20List.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am moving some of our forms into SPLists, however, some of them are lengthy and may only have a few fields entered. Our current system allows us to view the entry and only see the fields that were filled out so you dont see alot of blank information. It looks very clean.

 

Are there any suggestions on how to better "View" or "Present" the line items without going to the SPList itself? PowerBI isnt an option right now due to licensing. I am looking into Tableau but might be overkill. 

 

I was also thinking about just going with MS Forms, especially with the branching logic, but I like the data fields SPList provides.

3 Replies
Highlighted

@CWRRT Have You tried to customize the SharePoint Forms using Power Apps?  It gives you many opportunities to customize your forms.

You can read more about it here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

 

Regards, Magnus

Highlighted

@CWRRT I agree with @Magnus Goksøyr, either a customised form with Power Apps or even a standalone Power Apps form using the list as your data source is the way to go. There are a lot of good videos about this on YouTube by Shane Young so have a look for those.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Magnus Goksøyr 

 

I have done this for data entry, what I am looking for is more in regards to data viewing. 

 

I think I found a solution with Forms Pro and using some automation to feed to a SP List.