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...Flow
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 delete person in SharePoint Power Apps form?
I have customized SharePoint form in Power Apps. It is working perfectly except it is not patching person data when I removed person from people picker field. Then I came to point that one more thing is missed from Microsoft.
Continue reading...Power Automate: Flow Introduction [Chapter-1.0]
Initially we have SharePoint Designer to create workflow in SharePoint. But SharePoint designer limitation was that it was integrated with one product i.e., SharePoint. With Power Automate Microsoft integrated other products like-SQL, Twitter, FB etc. So Power Automate (previously know as MS Flow) is a kind of service that helps you to- Automate repetitive business processes. Send reminders on past...
Continue reading...Power Automate | Flow : Standard Date & Time
When you check date format in flow, you will see this kind of date format : yyyy-MM-ddThh:mm:ssZ. Actually microsoft flow gives you each date in this format. But some time we need better date format for visibility or understanding. In flow, We use following expression for date format- formatDateTime(utcnow(),’Date String’) Replace Date String with one of the following letter and...
Continue reading...
