Creating a reminder flow/ Scheduled Flow is a basic use of Power Automate. Reminder itself bind with Date & Time which you need to decide. In Flow, we have one trigger for reminder- Recurrence. In Recurrence, We need to understand following advance options- Frequency-Frequency is based on time period like seconds, Minutes, Hours etc. Interval- is number of times your flow...
Continue reading...Power Platform
How to transpose Excel table via flow?
Have you ever build Power Automate (Flow) for transposing Excel table?. I came across such problem and designed a flow. This flow transpose your excel table data. I have one excel sheet- Sales Data inside SalesTable. It has three columns- 1. CustomerID 2. Category 3. Sales I want to transpose above table into following format- Steps- I am using flow...
Continue reading...How to extract value from SharePoint Multiple Choice Values column in flow?
Recently, one of the Power Automate Community member bring my focus to SharePoint Multiple choice values. He wants to incorporate multiple choice values in an email from SharePoint list multiple choice column. Problem is that the output from multiple choice values is not straight forward. You need to collect value then format your output in neat and clean way. Here...
Continue reading...How to get attachments from SharePoint list and then send in email via Flow?
In Power Automate Community, I have seen lots of user face issue with getting attachments from SharePoint list via flow. Today i will explain how you can retrieve multiple attachments from SharePoint list and then send those attachments in email via flow. So i have one SharePoint list- Holiday List where user needs to upload travel documents for booking. Here...
Continue reading...Power Automate: Types of Flow [Chapter – 2.0]
In my previous post I have given very basic intro about Power Automate and today i will cover how many types of flow you can create. Before moving to the types of flow There are two ways to create flow- Start from template Inbuilt templates From visio templates Build your own from blank Automated cloud flow Instant cloud flow Scheduled...
Continue reading...How to store MS Forms multiple choice to SharePoint List?
In Microsoft Power Automate Community, i have seen lots of post regarding “How to save MS Forms multiple choices to SharePoint List?”. Problem with Multiple choices is that it gives you output in array format like [“Paris”,”Berlin”,”Milan”]. We can store this output in our SharePoint List but it is not a clean output for look and feel. Today i will...
Continue reading...How to Create Microsoft Form Choice type question option-Other in PowerApps?
In Microsoft form, when we have a question of type-choice there is option for end user to add input in option ‘Other’. Sometimes it is very difficult to include all choices in a SharePoint choice column. Though we have manual input option only when we allow multi-select in choice column setting. But we want end user select only one choice...
Continue reading...