This post is part of the SAP Build Community Challenge (April 2023) This week’s challenge involves formulas – a key feature of SAP Build Apps. Formulas are used in bindings of components, and enable you manipulate data before it is displayed in a component or before it is sent to a data source. Formulas are created in the formula editor, which provides some tools for making writing formulas easier: It has a list of functions, which can be added to the formula with a click. It has documentation on each function, plus examples. It has a live testing of functions so you can be certain how they work. It checks the syntax of the formula. It shows an expected sample result of the function. It checks the resulting data type against the data type expected by the component or flow function using the formula. Here are some learning materials about formulas: Formulas (documentation) Formula Functions (reference) No-code App Programming 101 (video by Akseli Virtanen)   Setup We will give you an app that looks like this (I like cats). To set up the challenge, do the following: Download the skeleton project called Challenge - Formulas.zip.gpg. Create a new SAP Build Apps project. Import the downloaded project by selecting History > Replace in the top-right corner, and then selecting the downloaded project.  Inside the app, we have already created a page variable called StartValue that contains the starting data that we want you to transform.    The Challenge When you are ready, on the UI Canvas, select the Transform button, open the logic canvas, then select the Set page variable flow function, and finally go to set the formula for Assigned Value on the right (which currently returns an empty list). This is what you need to do: Write a formula that replaces the empty list for the assigned value and that does the following: Aggregates the data from StartValue so that in EndValue each name appears only once with an average calculated from the amount fields. Names should be sorted alphabetically, from A to Z Averages should be rounded to the nearest integer. Launch your app. Click the Transform button (which will display 4 names and an average for each), and then type your name in the input field. Take a screenshot and post it to THIS discussion. BONUS: Add to your entry the movie from where the 4 names in the results are taken. Your screenshot should look something like this (with your name): Good luck ... and have fun!!   ... View more

Hi, Builders I'm developing a web application using SAP Build Apps, I'm also using BTP authentication and BTP destination. My question is: how can I return/read the user logged (email, ID... anything) using this authentication method? I'm trying to save this information using the output 1 of the logic "Authenticates with SAP BTP", but it's empity.  There is another way to do that? Thank you, Jessica ... View more

Hi! I'm a business Citizen Developer taking the Learning Journey, Low-Code/No-Code Applications and Automations for Citizen Developers.  Question:   How to you go through this training on your way to certification?  For me I do the following: Read and review   all the text, videos and diagrams multiple times  Build the apps   (e.g., SAP Build Process Automation, SAP Build Apps (formerly AppGyver) and make sure I understand how they work Go through the quizes - make sure I understand them and any related information  Found this Prepare for Certification landing page What are your techniques which enable mastery and prepare you for the certification? I find you have to be very thorough to be ready? In going through the learning journey, questions can come from areas that seem less important such as... From a dropdown list   that may not catch your eye, but should be reviewed... Every component   of the building of the apps should be understood and reviewed... And also, words used in the quiz/test maybe different   (e.g, For Work Zone they may talk about " access " and then ask a quiz question around " roles &  authorization handling " so you have to be ready for slight changes in wording on the questions). Thanks for your comments!   What are your experiences with LCNC Learning Journey or SAP Certification preparation in general. What works? What doesn't?  Appreciate your insights and opening up a discussion which will help us business Citizen Developers!:-) ... View more

You might remember from Juergen's TechEd keynote the 12-year-old developer DAK who created the learning app for kids. We recently published a new Builders Spotlight with DAK, where he introduces a new mascot named Sappy that he hopes will inspire other kids to try building apps: https://blogs.sap.com/2023/03/15/builders-spotlight-dak-age-12-introduces-sappy-the-mascot-to-get-more-kids-building-apps/ Spoiler alert: the blog also features an awesome 3D printed version of Sappy! Though the target of SAP Build is business users, citizen and professional developers, there is certainly value in having these tools be accessible for kids and empowering them to be Builders too. What do you think of DAK's message that kids should try out no-code? What else could be done to encourage more young creators to try app development? ... View more

Are you taking (or considering) the SAP Build Low-code/No-code Learning Journey for SAP Build Process Automation, SAP Build Apps (formerly AppGyver), and SAP Build Work Zone?. Check out my latest SAP Community blog post, which reflects on how "Business Teams Can Create Their Own Apps (with Occasional Help!)" Happy for your comments! What are your experiences with any of the SAP Build products? What have you built? Are you working on any interesting use cases? Please leave any comments below! ... View more

The mobile device preview app is now available for SAP Build Apps. Watch @dan_wroblewski two minute video to see how to use it. ... View more

Dear Builders, Do you know your SAP Build project could be an inspiration to other builders, and possibly a solution to the problems of others? The ‘SAP Builders Spotlight’ series is featuring builders like you. This series highlights success stories from our builders community, showcasing your build projects and the challenges you face while building. Have you completed a project with SAP Build Apps, Process Automation or Work Zone? Please reach out to us, we will be happy to promote your project! Here is a previous edition from the SAP Builders Spotlight Series. https://blogs.sap.com/?p=1648605 ... View more

Dive into the Create Sales Order Workflow with SAP Build tutorial and learn how to use SAP Build Process Automation and SAP Build Apps together! ... View more

I have created an app for displaying information about the most recent earthquakes, plus details about any specific earthquake, and a way to let the USGS know if you felt the earthquake and your experiences. You can also search for information on recent earthquakes near you. https://blogs.sap.com/2023/02/15/app-shows-earthquake-data-in-your-region-donations/  The blog even contains instructions on how to import it into your tenant (as well as ways to donate to the disaster relief).   I'm interested in ideas from you on how we could improve the app, what features to add (big and small), and how perhaps to make it more useful for people in the field. What would you do? ... View more

Try out SAP Build Apps in minutes ... View more