Blog Archives - Page 51 of 171 - - Page 51

Category Archives: Blog

Post an MS Form response to MS Teams Channel using Cloud Flows

In this blog, we will learn how to quickly design a simple Cloud Flow to post a message in MS Teams Channel when a user submits a response using MS Form. Step 1: Create an MS Form to get the responses from the targeted user. Go to https://forms.office.com/ and click on New Form to create an MS Form. Now, We will create MS Form that will take the Name, Age, Gender, Service ratting and comment which is optional as feedback. Step 2: Create a Team and Channel to post the responses Here, I am creating an Admin Team (Type — Private Team) that will be used by Management Team for organization. Now, we will add the “Feedback Responses” channel to post responses in Admin Team. Step 3: Create an Org Level Team that will be used by all team member to submit the responses (Optional — You can share the form via email or posted it on the website) Now, we will add the MS Form tab in the newly created “Feedback Form” channel so that team members can submit responses directly from MS Teams. After the channel is created, click on the + button on the top ribbon button to add a new channel tab. Look for MS Form and click to select the type of channel tab. Select Add existing form and choose your created Feedback form. After clicking on the Save button, a new Form Tab will be added to the feedback from channel of your Org Level Teams Check if Team, Channel and Form tab is visible from other users Log in with another and open the Team. Here, I have another user who has access to the Project Name team and Org Team but doesn’t have access to Admin Team as it Private Team for Management. Below is a screenshot for the same: Step 4: Create a Cloud Flow to post the response to the Private Teams channel Login to the Power Automate portal and create an Automated Cloud Flow Look for MS Form Trigger “When a new response is submitted” and click on Create to create Cloud Flow Select the Form in Cloud Flow trigger Add new step Get Response Data from MS Form Connect and select Response Id from triggering body Now, add a new step from Teams Connector Post a message (v3) to post the response in Teams Channel Configure the Team, Channel and Message (According to your requirement) Testing I have submitted the response from the MS Teams using another user: After submitting the response we get the message in the Admin Teams: Hope this helps!!!

Share Story :

Using Security Filters in Business Central

Introduction Business Central allows various levels of security that can be used to restrict User access to different features or objects. We can use Permission Sets to prevent User access to specific objects like reports or pages. For more refined, row-level authorization we can use Security Filters to restrict access to individual record based on some filters. References Using Security Filters in Business Central – Business Central | Microsoft Docs Pre-requisites Business Central OnCloud or OnPremise Configuration Suppose, you want the User to only be able to access a specific set of Customers. You can either create your own Permission Set from scratch, in which you will describe all the objects that the User will have access to or you can copy one of the existing ones by clicking on “Copy Permission Set” and then entering a new name for the permission set. Do note that you require proper permissions to make changes to Permission Sets as well. Open the Permission Set, by clicking on the “Permissions” action and Scroll to the Right. Click on the three dots next to the Security Filter field. Select the field(s) which you want to filter by clicking on the three dots next to the Field Number and then click on OK. Set a value for the filter in the “Field Filter” field. You can add as many filters as required and any Business Central filter is valid in this field (Except for wildcard characters). Once you are done, click on Close. Click on OK and add (in case there are no other permission sets and you have created your own) or replace (in case you have copied the permission set) the new permission set onto the User in the “User Permission Sets” tab of the User card. Login to the User Account and verify that only the records that match the mentioned filters are visible to the Users. Conclusion Thus we saw how to create and configure security filters in Business Central for maintaining record level security. As a side note, I would like to highlight that in Business Central, in case a User has multiple Permission Sets containing different levels of permissions for the same object then Business Central combines these Permission Sets and uses the least restrictive group of Permissions. As such if you apply a Permission Set with a Security Filter and another Permission Set without the filter on the same object, Business Central will use the one without the Security Filter as it is least restrictive.

Share Story :

ScanPayGo by LS Retail

The current Retail process supported by LS Central is simply for the customers to collect the items and bring them to the POS for completing the transaction. LS Retail aims to change this process with the introduction of their new product ScanPayGo. Using this app customers will be able to select the items to be purchased directly from within the app or by scanning the barcode on the item, manage or share multiple shopping lists , pay directly from within the app or pay at the POS by simply scanning one QR code instead of all the items as was done previously. It also allows paying using loyalty points if sufficient points are available. As a security feature the app has random checks in which after a transaction the customer has to confirm with a Staff member to verify the purchased items. It maintains a purchase history so that repeated transactions need not be scanned repeatedly. It help customers find the closest Store by providing a list of all the available Store ordered by the closest Store. It also displays the current available offers in the Store. All of which adds on to the seamless retail experience with minimal interaction. Retailers can customize the color scheme and logo of the app however they wish. Retailers can also offer personalized ads to Users using ScanPayGo! This application is going to be available for both Android and iOS.

Share Story :

How to personalize Password field based on strict Regular Expression (RegEx) formulas in Canvas PowerApps

Hello,In this blog, I’ll show you how to personalize Input Password field with various requirements using strict regular expression in Canvas PowerApp. Now, validation part comes in using RegEx. Let’s say you have a requirement where,1. Password length should be equal or greater than 8.2. Password should contain at least 1 number.3. Password should contain at least 1 lowercase alphabet.4. Password should contain at least 1 uppercase alphabet.5. Password should contain at least 1 special character. After everything all requirements is satisfied, show that password is valid. Let’s say you have 5 labels containing Text of these requirements and will be visible if its respective condition is not satisfied. Hope this helps you.

Share Story :

SQL Trigger not populating with Table in Logic App

Wondered How to solve SQL triggered Azure Logic Apps issue of not being able to select your table in dropdown? This blog will help you fix this issue.

Share Story :

Inventory Adjustments in Business central using Inventory Documents

Introduction: To adjust your inventory there is another ability provided by Business central using Inventory Documents. We can do positive and negative adjustments using Inventory Receipts and Inventory shipments respectively. Steps to achieve the goal: First, we need to set up the number series for Inventory Receipts and Inventory Shipments and Posted Inventory Receipts and Posted Inventory Shipments on Inventory setup. 2. Go to Purchase Receipts and assign the Item in line, fill all the required details. You can reopen and release documents, but it is not required. Once you have filled in the necessary information you can post the Inventory Receipts. The item will be adjusted and you can see it in Item ledger entries. Same we can do it by Inventory Shipments when the item is damaged or needs to be return Fill in the necessary details in Inventory Shipments and post them. You can also print the Inventory Receipts, Inventory Shipments, and Posted Inventory Receipts and Posted Inventory Shipments. But the base application doesn’t include any layouts. So you can create your own report and assign it in Report Selections-Inventory according to usage. Posted Inventory Receipts and Posted Inventory Shipments are nonsearchable in order to print the posted documents you need to visit Item Ledger entries -> Document type=Inventory Receipts -> Find entries-> Item Receipt Header and then you can print the Posted Inventory Receipts. 10. Same for the Posted Inventory Shipments go to Item Ledger entries-> Document Type= Inventory Shipments-> Find entries-> Inventory Shipment Header and then you can print the Posted Inventory Shipments. Conclusion:    Thus we saw how we adjust the Inventory using Inventory documents.    Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

Disable field on change of tab in D365 CE

Use case – Our requirement is to enable field description field on invoice line form on clicking of tab General. Let’s see how we can achieve this Solution – Step 1 – Create web resource with below function- var invoiceLineCustomization = {     unlockField : function(executionContext)     {         var formContext = executionContext.getFormContext();             formContext.getControl(“description”).setDisabled(false);     }, } Step 2: Add this web resource on tab property event TabStateChange and try. (path to go to event tab – Click on tab -> change properties -> event) Output – Hope this helps !

Share Story :

Configuring Barcodes on POS Receipts

Introduction: Refunding a transaction is an everyday occurrence in Retail. LS Central provides us with the functionality to initiate the refund of a transaction by simply scanning one barcode! In this blog, we will be looking at how to configure this feature. References: https://help.lsnav100.lsretail.com/Content/LS%20Retail/POS/Hardware/Printing%20Receipt%20Barcodes.htm Pre-requisites: Microsoft Dynamics 365 Business Central LS Central Configuration: From Business Central, open the POS Terminal for the current Store. In the “Printing” tab, Set the “Receipt Barcode” ID to 101. Set the “Print Receipt BC Type” to “CODE39” or “CODE128_A”. You can optionally adjust the Barcode Height and Width but depending upon the POS Printer it may or may not be scannable as the resolution of the barcode suffers. The default parameters which are applied if you leave the fields to 0 are width – 8 and height 40. Set the “Receipt Barcode” to true. Once this is done, simply run the POS and generate a Receipt. When the Barcode at the bottom of the Receipt is scanned it should directly take the User to the refund screen of the POS. For instance, this is how it looks on the Virtual Printer: While, this is how it looks when using a real printer. Conclusion: Thus, in this blog we saw how to configure Barcodes on POS Receipt. Thanks for reading!

Share Story :

Using Web Content on POS

Introduction LS Central allows us to use HTML content on the POS which includes both Text and Images. Users can add extra information related to the Items here which can assist in the POS Users to make the sales much more efficiently. In this blog, I’ll be demonstrating how to configure the same. References https://help.lscentral.lsretail.com/Content/Fields/T_10001411.htm Pre-requisites Microsoft Dynamics 365 Business Central LS Central Configuration Open Business Central and search for POS Terminals. Open the POS Terminal for the current Store and set the “Item HTML” and “Item Image” property to true. Search for Retail Items and open the Item you want to add description and image for. Open the Item Card and Go to Navigate -> Master Data -> Item HTML. Here you can specify the description for the Item that you want to be displayed on the POS and click on Save. For instance: After that go to Navigate -> Master Data -> Images and click on New. Click on Import and select the Image of that Item and then Click on OK. Go to POS and search for the Item. Double Click on the description of that Item to see the Image and the HTML Content. You can even embed Videos if required! Conclusion: Thus, in this blog we saw how we can utilize HTML content on POS. As an additional side note I’d like to mention even using Javascript is possible, to a certain extent, so for those who are curious you can even create basic games for it. Thanks for reading!

Share Story :

Get Time in Hours and Minutes from a Date Field in CRM using JavaScript.

D365 gives a functionality to create a Date and Time field where in you can provide the user to select the date or both date and time. But what if you just need the time in Hour and Minutes format from the selected date in the Date field, This can be achieved using a JavaScript. In this blog lets see how we can get the time entered in the date and time field and format it in hours and minutes format. I have created a field in CRM with field type Date and time. Here is how it looks Using the JavaScript “Date” functions you can get the Time entered in the date and time field as shown below. This code gets the date and time (hours and minutes) selected in the date field and will format the hour and minutes in the format “HH:MM“. Hour – (getHour()) Minutes – (getMinutes()) Output – Note : You can also add the AM / PM to the time string I have not added it in my time string “strTime” but have stored the value of it in “ampm“. Hope this helps !

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange