MS Power Assist

In this post let us how to embed an image in an email using Power Automate In order to embed an image in an email - it would be easy if the image is stored in OneDrive or SharePoint folder and retrieve them. Let us see how to accomplish this... Create a folder in OneDrive for Business Upload an image to embed in email Now, let us create flow. Add a trigger Add a variable (this helps us to form the image tag to embed in email) Add OneDrive for Business connector and chose "List files in folder" Add "Get file content" and File field add - "Id" from the above action Now add "Get File Content" action from OneDrive for Business connector Under File field - select "Id" from the dynamic content Apply to each automatically applies when you add "Id" into File field. Now add "Set Variable" and update it's Value as <img src="data:image/png;base64, @{body('Get_file_content')?['$content']} " alt=&

In this post, let us see how to implement " Nested Flows " in Power Automate.  Some use cases: To create a common logic and make use of "Run a Child Flow" action To perform actions on the database without providing access to the end users. Let us create records in SharePoint (using Student Name and Email fields in this post)  without providing access to the end users using nested flow concept. To proceed, we need to have two flows created.  Parent Flow (which triggers the child flow) Child Flow (nested Flow) Go to flow.microsoft.com, log in and select respective environment from the drop-down. Click on "+ Create" Choose "Instant flow" Provide a name and choose " When an HTTP request is received " and "Create" Now, we need to provide inputs to the flow (inputs from the Parent Flow) We need to generate Schema for " When an HTTP request is received" trigger Click on "Use sample payload to generate schema" and

Validate an email input in a Canvas Application | PowerApps In this post let us see, how to Validate an email input in a Canvas Application UI Validations helps us to ensure, valid data is received from the End User to complete an operation helps end user to provide right information the validation action depends on the type of the input control for Text Input Control - mostly we go with "OnChange" for check box control - "OnCheck and On uncheck" for Drop Down and Combo Box Controls - "OnChange" or "OnSelect" etc., Now, let us see how can we validate an email input, a phone number input and a name input. How to validate an email input value is valid? We can leverage "Regex" (Regular Expressions) to valid user inputs. Let us consider the Email Input Control Name as -  txtEmail.Text. OnChange of this Control let us i

in this post, let us see how to create a Pop-Up in Canvas App required controls: rectangular icon label buttons - 2 take a "rectangular icon" and make it screen size update it's "Fill" - with RGBA(175, 191, 224, 0.5) . Take another "rectangular icon" and adjust it to center Take "label" - and add required text (Eg: "do you want to proceed?") Take two buttons. Update text of Button1 to "OK" and other to "Cancel" On Click of the respective control (to open the pop-up), add this expression : UpdateContext({locOpenPopup:true}) select "cancel" and "ok" button and add UpdateContext({locOpenPopup:false}) on "OnSelect" property. add appropriate actions on "cancel&quo

In this post let us how to validate a specific field value is updated in a SharePoint List using MS Flow in order to achieve this we need to enable "versioning" to the SharePoint List.  How to enable this: Now let us get started: Create a MS Flow with trigger: "When an item is created or modified" Let us below actions to validate the changes to a specific field Send an HTTP request to SharePoint (to get the field values - version based) Select (to select only required fields) Condition (to evaluate the values as per the requirement) Values in the condition:  first (body( 'Select' ))?[ 'Title' ] and last(body( 'Select' ))?[ 'Title' ]

In this post let us see, how to show a successfully submitted record's data back on to the form, as a confirmation. Take two screens  Home Screen Success Screen On Home Screen: Take a Form Control on the Home Screen and map it to respective entity. In this post we are mapping it to Registrations entity. Take a Button Control and input the below expression, to create records into Registrations Entity. SubmitForm( frmRegistration ) Now, let us implement how to redirect the user to Success Message screen to successful record submission. In order to achieve this, we are going to make use of one of the Form Control's properties - OnSuccess. So, OnSuccess we are going to implement Success Screen navigation as below Navigate(' Success Screen ')   Success Screen Take a label to show - success message, as below "Registration was successful. Registration Id: " & frmRegistration .LastSubmit.'Registration Number' LastSubmit  property of a From Control helps u

Here is a way to redirect to a specific screen in Power Apps (Canvas App) The final URL looks like below https : //apps.powerapps.com/play/xxxxxxxx-2c29-4c7e-b18e-a900e34c0e12 ? title =issueWithPhone Get the App URL: Go to make.powerapps.com Select your canvas app. Click on three ellipses(...) and go to details copy the app URL Add the changes in Canvas App to redirect to a specific screen or record: On App Start, take a variable as below- Set(varTitle,Param("title")) . Use Navigate Screen to redirect to a specific screen the screen as below- If(!IsBlank(varTitle),Navigate(ViewMyRequest)) . We can make use of that variable to filter data and map it to form/gallery as per the requirement

converting an array value to a string using Power Automate out of the box function. " how to convert an array to string " in MS Flows. Basically, we can use "split" function to convert an array into string but we may end up having extra comma to the last value. To remove that we have to use another expression which checks for the string length and removes the last character [ substring(variables('varListOfRequestIDs'),0,sub(length(variables('varListOfRequestIDs')),1)) ]. To avoid this round about process rocess, we can leverage Power Automate's simple and out of the box function -  join Here is an to show how can we convert an array to string. for instance let's consider, we have an array [796759,933436,926050,1388108,762632,764554]. But as per the requirement, we need to convert it to string and send that value as 796759,933436,926050,1388108,762632,764554.  varListOfRequestIDs = [796759,933436,926050,1388108,762632,764554] varStringListOfRe