Calculated field and hidden column in view mode

%3CLINGO-SUB%20id%3D%22lingo-sub-2380513%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20field%20and%20hidden%20column%20in%20view%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061406%22%20target%3D%22_blank%22%3E%40Teste1645%3C%2FA%3E%26nbsp%3Byou%20can%20show%20different%20columns%20in%20different%20views%2C%20but%20any%20user%20who%20know%20how%20lists%20work%20will%20still%20be%20able%20to%20change%20the%20view%20to%20show%20all%20the%20columns.%20You%20might%20want%20to%20consider%20using%20a%20Power%20Apps%20customised%20form%20for%20your%20list%20(from%20Integrate%20-%26gt%3B%20Power%20Apps%20-%26gt%3B%20Customised%20form%20at%20the%20top%20of%20your%20list)%20which%20you%20can%20embed%20as%20a%20web%20part%20on%20a%20SharePoint%20page.%20This%20will%20allow%20the%20user%20to%20enter%20the%20details%20they%20need%20to%20enter%20but%20make%20it%20harder%20for%20them%20to%20see%20all%20the%20columns.%20In%20my%20example%20video%20attached%20I%20have%20put%20both%20views%20of%20my%20timesheet%20list%20on%20the%20page%20as%20list%20web%20parts%20and%20also%20added%20the%20Power%20Apps%20web%20part%20for%20the%20form%20%3CEM%3E(you%20of%20course%20might%20not%20want%20to%20display%20any%20views%20on%20the%20page%20but%20just%20have%20the%20form)%3C%2FEM%3E.%20The%20user%20enters%2Fselects%20their%20time%20information%20and%20the%20form%20does%20the%20calculations%20before%20saving%20the%20details%20to%20the%20list.%3CBR%20%2F%3E%3CBR%20%2F%3ECome%20back%20with%20any%20questions%20about%20this.%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%3EIntranet%2C%20SharePoint%2C%20Website%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2381835%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20field%20and%20hidden%20column%20in%20view%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381835%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20answer.%20I%20will%20try%20it%20out.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2383540%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20field%20and%20hidden%20column%20in%20view%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2383540%22%20slang%3D%22en-US%22%3EMay%20I%20ask%20how%20did%20you%20make%20the%20input%20form%20part%20of%20the%20sharepoint%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2383739%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20field%20and%20hidden%20column%20in%20view%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2383739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061406%22%20target%3D%22_blank%22%3E%40Teste1645%3C%2FA%3E%26nbsp%3BWhile%20you%20are%20customizing%20the%20form%20in%20Power%20Apps%2C%20click%20on%20File%20then%20the%20See%20all%20versions%20button.%20In%20the%20list%20of%20versions%20that%20appears%20click%20on%20the%20details%20tab%20and%20copy%20the%20app%20ID.%20In%20your%20SharePoint%20page%2C%20add%20a%20Microsoft%20Power%20Apps%20web%20part%20and%20paste%20in%20the%20app%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22appID2.png%22%20style%3D%22width%3A%20731px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283515i274398516699FB8C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22appID2.png%22%20alt%3D%22appID2.png%22%20%2F%3E%3C%2FSPAN%3E%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%3EIntranet%2C%20SharePoint%2C%20Website%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379951%22%20slang%3D%22en-US%22%3ECalculated%20field%20and%20hidden%20column%20in%20view%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379951%22%20slang%3D%22en-US%22%3EHi%20all%2C%20I%20consider%20building%20a%20sharepoint%20list%20that%20should%20let%20the%20user%20to%20type%20amount%20of%20hours%20in%20modify%20mode%20but%20when%20the%20user%20is%20done%20only%20calculated%20value%20is%20showed%20on%20the%20list%20i.e.%20hours%20x%20hourly%20rate%20%2C%20could%20you%20advise%20if%20this%20is%20possible%20in%20sharepoint%20and%20how%20to%20grasp%20such%20a%20problem%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2379951%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Hi all, I consider building a sharepoint list that should let the user to type amount of hours in modify mode but when the user is done only calculated value is showed on the list i.e. hours x hourly rate , could you advise if this is possible in sharepoint and how to grasp such a problem?
4 Replies

@Teste1645 you can show different columns in different views, but any user who know how lists work will still be able to change the view to show all the columns. You might want to consider using a Power Apps customised form for your list (from Integrate -> Power Apps -> Customised form at the top of your list) which you can embed as a web part on a SharePoint page. This will allow the user to enter the details they need to enter but make it harder for them to see all the columns. In my example video attached I have put both views of my timesheet list on the page as list web parts and also added the Power Apps web part for the form (you of course might not want to display any views on the page but just have the form). The user enters/selects their time information and the form does the calculations before saving the details to the list.

Come back with any questions about this.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thank you for your answer. I will try it out.
May I ask how did you make the input form part of the sharepoint?

@Teste1645 While you are customizing the form in Power Apps, click on File then the See all versions button. In the list of versions that appears click on the details tab and copy the app ID. In your SharePoint page, add a Microsoft Power Apps web part and paste in the app ID.

 appID2.png

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)