![\"How](\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/meeting-of-developers-2021-08-28-20-02-45-utc-scaled-1.jpg\")
<\/a><\/figure>\n\n\t\t\n\t\tAn export (CSV files) of the SharePoint site was taken and imported into a Google Sheet. This was the starting point for the Appsheet app. The first views were created to allow for (basic) data entry.<\/p>\n\n\n\n
After a data analysis phase<\/strong>, it was decided to restructure some tables and convert data as needed (fi. date-time formatting, username to email mapping, \u2026). The existing file store was migrated to a Google Shared Drive and the links to files\/folders were recreated in the tables using a one-time script. Next up was linking the different tables as needed.<\/p>\n\n\n\n Now all data could be entered<\/strong> and linked as desired, the document generation functionality was created. We first needed to convert the templates (Excel files) into Google format.<\/p>\n\n\n\n An Apps Script solution was created with reverse engineering of the Power Automate functionality to execute the merging of the data with the templates to generate the desired documents. Adding some extra parameters during the generation request also replaced the existing Excel macros in the old templates.<\/p>\n\n\n\n Finally the Views<\/strong> for the data entry, management and consulting were built. This was a highly intensive user-driven process, as this also introduced a new (easier) way of working and exposed some new possibilities which then got added to the solution. <\/p>\n\n\n\n In this showcase, the creation\/development of the SharePoint solution took over 2 years, while the MVP in Appsheet was created in 2 weeks. A second dashboard was created with (clickable) charts for easy reporting, overview and analysis of the data.<\/p>\n\n\n\n For the creation of the document(s), a new table was created to allow a selection of the needed document(s) and the desired language(s). It triggers the creation and stores the result. The document templates are a Google spreadsheet, containing the placeholders for the data, and get exported to PDF documents upon creation.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":" Going Google also means remediating all processes in your organisation that have been in place for several years. Often SharePoint Sites have a complex and\/or custom setup making it difficult. In this showcase, you learn how to turn a SharePoint site into an AppSheet-powered solution.<\/p>\n","protected":false},"featured_media":287814,"template":"","categories":[897],"tags":[3098,2407,2296],"industry":[],"class_list":["post-495357","success-story","type-success-story","status-publish","has-post-thumbnail","hentry","category-google-cloud-cz","tag-appsheet-cz","tag-g-cloud-cz","tag-google-workspace-cz"],"acf":[],"cards":"\n\t![\"\"\/](\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/z9pJzf_Ol-rvkOEkGNDshzO1IdOG1XLfPr9CcACVqwVoctL0-vWPtUa_5uuh9Vtkkxik0Ik6xHgSxEJgju-U1kXPc3n72DoXaE3cWpI8ZnuP5WxUwB5Gv-wbkWuN1FSuFNliCYMeIJS8qT18ryrZ3nU.png\")
<\/figure>\n\n\n\nThe result<\/h2>\n\n\n\n
In the end, the biggest \u201cchallenge\u201d was to create\/organise the data views in the most logical way to streamline the workflow and show\/edit data with the least possible clicks for an optimal processing flow: we created a dashboard view to group the different data fields in logical categories.<\/p>\n\n\n\n\n\n\t\t<\/a><\/figure>\n\n\t\t\n\t\t