A Creative Opinion
A Creative Opinion
  • 183
  • 613 622
Filter Array + Apply to Each: The Best Tip You Need to Know
How do you get the dynamic content from a Filter Array action? Are you writing an expression like this for each dynamic content you’d like to output?
In this tutorial-I’m going to show you a quicker way to get the dynamic content from your Filter Array action-and it doesn’t require writing an expression.
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline
---
MENTIONED IN THE VIDEO:
▶️ How to Use Multiple Conditions in a Filter Array Action: th-cam.com/video/HVAf1aTEQNg/w-d-xo.html
---
LEVEL UP YOUR POWER AUTOMATE SKILLS:
▶️ Are you using the Microsoft Power Automate Filter Array Action wrong?: th-cam.com/video/HVAf1aTEQNg/w-d-xo.html
▶️ 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow: th-cam.com/video/44Bk4JVMrD4/w-d-xo.html
▶️ 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: th-cam.com/video/QeBL32w2ClM/w-d-xo.html
▶️ How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks: th-cam.com/video/ODobGcpgGlk/w-d-xo.html
---
IN THIS VIDEO:
✓ How to loop through Filter Array results in Power Automate
✓ Using Apply to Each with filtered arrays
✓ The easiest way to access dynamic content from Filter Array
✓ Fixing nested Apply to Each actions
✓ When to use value vs. body dynamic content
✓ Simplifying Power Automate flows with Filter Array
✓ Troubleshooting Filter Array and Apply to Each issues
---
SKIP AHEAD:
00:00 | Intro
00:36 | FAQ: What is the Filter Array Action?
01:07 | Why Use the Filter Array Action
03:00 | How to Loop Through Filtered Items
03:18 | How to Get Dynamic Content with an Expression
04:04 | The Trick: Get Dynamic Content from a Filter Array Action without Writing an Expression
06:05 | A Reminder: Replace Value Dynamic Content with Body Dynamic Content
06:29 | How to Handle a Nested Apply to Each Action
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
acreativeopinion
www.tiktok.com/@acreativeopinion
acreativeop
มุมมอง: 819

วีดีโอ

3 Ways to Add Checklists to Planner
มุมมอง 1K2 หลายเดือนก่อน
Tired of manually adding checklist items? Automate it in seconds with Power Automate! In this tutorial, I’ll show you 3 easy ways to automate adding checklist items to your Microsoft Planner tasks using Power Automate. From the Update Task Details action to dynamic SharePoint and Excel integrations, you’ll learn how to automate your checklist generation and boost productivity. I’ll also show yo...
How To Create a Planner Task from a Microsoft Form Submission
มุมมอง 2.3K3 หลายเดือนก่อน
Build a Power Automate flow that creates tasks in Planner each time a MS form is submitted. 👉 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: th-cam.com/video/QeBL32w2ClM/w-d-xo.html First, I’ll show you how to create a task using the Microsoft Form submission data. Then, I’ll show you how to place a task in a specific bucket based on a selection made in the form as well as ho...
♾️ ♾️ Fix Infinite Loops ♾️ ♾️ | 3 Ways to Avoid an Infinite Loop in Power Automate
มุมมอง 2.9K5 หลายเดือนก่อน
Trouble with infinite loops in Power Automate? Learn 3 ways to break them in this tutorial. 👉 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: th-cam.com/video/QeBL32w2ClM/w-d-xo.html In this Power Automate Tutorial I’m going to show you 3 ways to avoid an infinite loop. Keep in mind that there are more ways to avoid the infinite loop than what I’ll cover in this tutorial-choos...
7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️
มุมมอง 1.4K6 หลายเดือนก่อน
Do you find writing expressions hard? I'll break it down in this step-by-step tutorial. 👉 If you are you using an automated trigger in your flow-you NEED to use Trigger Conditions. Learn How: th-cam.com/video/Eh4TpyIIQjc/w-d-xo.html In this Power Automate tutorial I’m going to cover 7 functions you need to know when getting started with expressions. 1️⃣ empty() 2️⃣ coalesce() 3️⃣ equals() 4️⃣ i...
How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks
มุมมอง 5K7 หลายเดือนก่อน
Dates in Power Automate confusing? Learn how to handle future/past dates, birthdays, and more! 👉 Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate: th-cam.com/video/d99dwBeTFvo/w-d-xo.html In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how t...
How to Add Microsoft Form File Uploads to a SharePoint List Item
มุมมอง 7K8 หลายเดือนก่อน
Learn how to handle MS Form File Uploads and how to add them to a SharePoint List item. 👉 Would you prefer attaching your MS Form file uploads to an email instead 📧 ? th-cam.com/video/ijoqOaOkaZs/w-d-xo.html In this Microsoft Power Automate Tutorial, I’ll show you how to get the file name and content from the File Uploads from your Microsoft Form, then I’ll go over how to add those files to a S...
4 Ways You Can Use Trigger Conditions in Your Microsoft Power Automate Flow
มุมมอง 4.8K8 หลายเดือนก่อน
Using Automated Cloud flow triggers? You NEED to add trigger conditions to your flows! 👉 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: th-cam.com/video/QeBL32w2ClM/w-d-xo.html Do YOU 🫵 know what a trigger condition is? Trigger conditions can be set in most flow triggers. These conditions you set must be true for the trigger to fire. In this Power Automate tutorial, I’m going...
How to Get Microsoft Form File Uploads Attached to an Email 📧
มุมมอง 12K9 หลายเดือนก่อน
Do you struggle with attaching your Microsoft Form file uploads to Email? 👉 Does your flow have multiple nested Apply to Each loops? Learn how to avoid this: th-cam.com/video/44Bk4JVMrD4/w-d-xo.html Are you stumped when it comes to handling a response without any file uploads? In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’...
How to Email Attachments 🖇 to Your Planner Tasks
มุมมอง 7K9 หลายเดือนก่อน
This flow will take your email attachments and add them to a Planner task! 👉 Learn how to create a Planner Task from a Microsoft Form Submission: th-cam.com/video/-jzHd26Z584/w-d-xo.html When you add attachments to a Planner task from your computer, the files are automatically saved in the Documents document library of the SharePoint site associated with the M365 Group of your plan. Instead of ...
Microsoft Copilot Built a Flow that DELETES ALL PDF Files-it didn't work...
มุมมอง 74310 หลายเดือนก่อน
Can Microsoft Copilot build efficient flows? Find out why it may fall short in Power Automate! 👉 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: th-cam.com/video/QeBL32w2ClM/w-d-xo.html I asked Microsoft Copilot to build me a flow that deletes all PDF files from a document library. After a few additional prompts it gave me an okay flow-however it’s inefficient. In this Power A...
⚡️Automate Microsoft Planner Tasks: Create Tasks from SharePoint & Excel in Minutes
มุมมอง 12K10 หลายเดือนก่อน
Learn how to quickly create tasks in Microsoft Planner from a SharePoint list or an Excel table. 👉 Do you want to Email Attachments 🖇 to Your Planner Tasks? Learn how: th-cam.com/video/42U1r9hpCFM/w-d-xo.html In this Microsoft Power Automate tutorial I’ll show you how to build a flow that will: ⚡️ Create a task in Planner for each of your SharePoint list items ⚡️ Create a flow that will trigger...
How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate
มุมมอง 3.5K10 หลายเดือนก่อน
Do you want to know how to send an email to all users assigned to a SharePoint item? If so-this Power Automate tutorial is for YOU 🫵. In a previous TH-cam tutorial I covered how to build a Power Automate flow that sends a single email to each user with the tasks assigned to them. Watch it here: th-cam.com/video/mmvJWKK690Y/w-d-xo.html However, that tutorial only covered a scenario where each ta...
Quickly Create Monthly Folders & Files and OneNote Notebook Year Sections and Month Pages in Minutes
มุมมอง 1.4K11 หลายเดือนก่อน
In this Microsoft Power Automate tutorial, I’m going to show you how to create an Automated Cloud flow that runs on the first day of a new year. We’ll go over how to use the Convert Time Zone action as well as how to use an expression to return the months in a year. I’ll cover three different scenarios on how you can use these actions in various flows: 1️⃣ Create a new folder for the new year f...
5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
มุมมอง 4.9K11 หลายเดือนก่อน
Is your Microsoft Power Automate flow succeeding but you’re just not getting the results you expected? In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow-this tutorial is for you! IN THIS VIDEO: ✅ How to troubleshoot a ...
How to Get a Microsoft Form RSVP Response into a SharePoint List
มุมมอง 4.7Kปีที่แล้ว
How to Get a Microsoft Form RSVP Response into a SharePoint List
How to Send SharePoint List Attachments 📎 via Email with Power Automate
มุมมอง 12Kปีที่แล้ว
How to Send SharePoint List Attachments 📎 via Email with Power Automate
3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow
มุมมอง 5Kปีที่แล้ว
3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow
How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
มุมมอง 43Kปีที่แล้ว
How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
Save Email Attachments to SharePoint with Microsoft Power Automate
มุมมอง 27Kปีที่แล้ว
Save Email Attachments to SharePoint with Microsoft Power Automate
Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
มุมมอง 44Kปีที่แล้ว
Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
Power Automate Beginner Tips and Tricks | 5 Things You Need to Know - Part 1
มุมมอง 2.2Kปีที่แล้ว
Power Automate Beginner Tips and Tricks | 5 Things You Need to Know - Part 1
Are you using the Microsoft Power Automate Filter Array Action wrong?
มุมมอง 27Kปีที่แล้ว
Are you using the Microsoft Power Automate Filter Array Action wrong?
Create Folders and Hyperlinks in Bulk with this Microsoft Power Automate Flow
มุมมอง 8Kปีที่แล้ว
Create Folders and Hyperlinks in Bulk with this Microsoft Power Automate Flow
How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action
มุมมอง 25Kปีที่แล้ว
How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action
Grant ITEM LEVEL Permissions on a SharePoint List ITEM with Power Automate
มุมมอง 14Kปีที่แล้ว
Grant ITEM LEVEL Permissions on a SharePoint List ITEM with Power Automate
Create Excel Tables for Your ENTIRE Workbook ⚡️SUPER FAST⚡️ with THIS Automation!
มุมมอง 932ปีที่แล้ว
Create Excel Tables for Your ENTIRE Workbook ⚡️SUPER FAST⚡️ with THIS Automation!
✌️TWO WAYS to Get Data from Excel into a SharePoint List
มุมมอง 18Kปีที่แล้ว
✌️TWO WAYS to Get Data from Excel into a SharePoint List
SPEED UP YOUR POWER AUTOMATE FLOW: ✋ STOP doing these 3 things!
มุมมอง 3.3Kปีที่แล้ว
SPEED UP YOUR POWER AUTOMATE FLOW: ✋ STOP doing these 3 things!
How to Lookup EXCEL DATA with Microsoft Power Virtual Agents
มุมมอง 17Kปีที่แล้ว
How to Lookup EXCEL DATA with Microsoft Power Virtual Agents

ความคิดเห็น

  • @DALEENmedia
    @DALEENmedia วันที่ผ่านมา

    Is there any way to do this in subsections in OneNote?

  • @Argentinian
    @Argentinian 2 วันที่ผ่านมา

    Hi, thank you so much for the help you provide! I have a question: how can I configure a flow to trigger only when the value of a date-type column changes? The column is called StartDate. My goal is to detect when a user changes the date in this specific field, but I want to prevent the trigger from firing for any other modification to the item. Do you have any suggestions? Thank you in advance for your help!

  • @lorijordan3554
    @lorijordan3554 3 วันที่ผ่านมา

    Where does the Task ID come from?

  • @Omayer-c7q
    @Omayer-c7q 4 วันที่ผ่านมา

    Hi, This sends an email to all users who have an entry within the SharePoint, I have followed the tutorial but would like to see for user's who do not have an entry within the SharePoint list. I would want them to receive an email.

  • @saffas1866
    @saffas1866 9 วันที่ผ่านมา

    Hi there, I have follow along the step share and it work's well so far. However, I am required to update the information from one SharePoint list to SharePoint list using PA, so far i'm unable to get the multi-person column updated, would appreciate if can show how to do it. Thanks

  • @Antonio.70772
    @Antonio.70772 11 วันที่ผ่านมา

    Great video, very helpful! Any idea why the attachments on the email are unreadable? The attachments from the form are photos and they open normally in Sharepoint folder, however, on email they are corrupted.

    • @Antonio.70772
      @Antonio.70772 10 วันที่ผ่านมา

      Found the issue! I forgot to remove quotes 21:07

  • @akpokemon
    @akpokemon 12 วันที่ผ่านมา

    EDIT: You can just create your own HTML page from scratch and use inline CSS styling. Make sure to select Code view (< >) when inserting HTML. Then for adding the title, you need to switch to classic Power Automate mode so you can add the <html><head><title>My Title</title></head></html> tags. Is there really no way to cleanly copy over the tables formatting from the HTML of the original? And checkboxes? Everything I'm duplicating is table-heavy. So the duplicated result is ugly. I'm guessing there's some additional hidden CSS somewhere that Power Automate doesn't capture? Hopefully the Graph API functions for OneNote to copy pages/sections, preserves all the formatting...

  • @jasheenas4578
    @jasheenas4578 12 วันที่ผ่านมา

    You are so amazing omg. Ive been struggling FOREVER until i saw your video. Thank youuuuuuuuu🥺💙😭

  • @vcp619
    @vcp619 13 วันที่ผ่านมา

    Thank you for this tip! It’s second nature for me to type item()?[‘’] but now I can add this to my routine!

  • @Sese29yt
    @Sese29yt 13 วันที่ผ่านมา

    Great video! I think this is exactly what I was looking for - will your method that you cover in Compose action also work with deleting duplicates based on delete row? I'm guided by this video ( th-cam.com/video/SGXAqAzYUSM/w-d-xo.html&lc=UgxrXCjSNndqF3nZI8t4AaABAg.ABGMkkSicntABHGHzcHBWa&ab_channel=DamoBird365) but I'm stuck with deleting rows with duplicates and you seem to have just shown a way to do it....

    • @Sese29yt
      @Sese29yt 13 วันที่ผ่านมา

      Yup, checked - it works! :D

  • @yaminkerkoub7829
    @yaminkerkoub7829 14 วันที่ผ่านมา

    Hi, thank you for this tutorial. Does it work if there are two or more owners of the task in the same row ?

  • @EmmaChild-u1w
    @EmmaChild-u1w 16 วันที่ผ่านมา

    Hello, thank you so much for the video. How would I go about including tasks that have Due Dates in the past? Many thanks

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! You'll need to adjust your filter query. To learn more about working with dates in Power Automate-check out this tutorial: th-cam.com/video/ODobGcpgGlk/w-d-xo.html

  • @YB5333
    @YB5333 19 วันที่ผ่านมา

    This is amazing. Thank you!

  • @benjaminkorntheuer1494
    @benjaminkorntheuer1494 19 วันที่ผ่านมา

    Hello, fundamentally this approach works. However, for "secret content," it is absolutely not suitable. In the time delta between the creation of an item and the execution of the flow, there will be, for example, a 3-minute window where anyone who opens the list during this time can see and read the item. From a data protection perspective, this is unacceptable. Even reducing the flow interval to 1 minute still leaves a 1-minute gap, which is too much. I already created a ticket for M365 and had a session with Microsoft, where they confirmed that there is currently no solution for this scenario. Do you perhaps have an alternative solution to address this issue?

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching. There are definitely other approaches you can look into that would better suit your requirements. A couple suggestions are: - For the easiest approach: Create the item first with just the title, then remove permissions and update the item as well as adjust the permissions - For a more advanced approach: Use the Send an HTTP Request to create your item with the appropriate permissions. Hope this helps!

  • @AdamHaas
    @AdamHaas 20 วันที่ผ่านมา

    I can't get it to do basic CSS changes to Power Automate. Only the specific things mentioned in this video.

  • @umairismail9555
    @umairismail9555 22 วันที่ผ่านมา

    Hi any way to filter using array / list ["Value A", "Value B"]

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching. I'm unclear on the ask. I would recommend posting your question in the Power Automate community and including screenshots: community.powerplatform.com/?redirectedFrom=community.powerplatform.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  • @jakchalachlekkla2899
    @jakchalachlekkla2899 23 วันที่ผ่านมา

    ⌨🐵

  • @chenchen-y1s
    @chenchen-y1s 23 วันที่ผ่านมา

    thanks your video, i came into one issue, one column name is lookup type, the internal name Field=Lab_x0020_Name_x003a_Country, i try the Lab_x0020_Name_x003a_Country/Ttile eq 'xx' , bad request: Column 'Lab_x0020_Name_x003a_Country' does not exist. how can i fix this ?

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! Look up columns require an ID match. It's hard to troubleshoot a flow in the YT comment section. I would recommend posting on the Power Automate Community: community.powerplatform.com/?redirectedFrom=community.powerplatform.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity Ensure you include screenshots and provide as much detail as possible.

    • @chenchen-y1s
      @chenchen-y1s 14 วันที่ผ่านมา

      @@acreativeopinion i guess so, check the code from website, MS PAM make is hard... LOL

  • @sonechak
    @sonechak 24 วันที่ผ่านมา

    Thank you for the video. Do you have a similar video where if someone deletes mass files from their SharePoint document library it sends an email notification to the Administrator?

  • @DMG-s1p-d3t
    @DMG-s1p-d3t 26 วันที่ผ่านมา

    If you get an error on the "get File content using path" step - make sure this step is inside the apply to each not below it.

  • @jasonates1051
    @jasonates1051 26 วันที่ผ่านมา

    You are a life saver! With recent PA changes, looks like dynamic content isn't showing in Apply to Each loops from 'List Rows in a Table'. This solves that issue too. 🙏

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! Dynamic content not displaying can happen for a few reasons. One common scenario is when you're using an expression-this can sometimes prevent the dynamic content from appearing in the list. In those cases, you'll need to manually write the expression to access the dynamic content. You can also store the dynamic content in a Compose action and insert the Compose action into your flow. Hope this helps!

  • @andresloza9792
    @andresloza9792 28 วันที่ผ่านมา

    What if I only want to send the reminder on business days? How would that affect the 3-day reminder calculation?

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Check out this section of my How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks Tutorial: th-cam.com/video/ODobGcpgGlk/w-d-xo.html In this section I cover how to check if a date falls on a weekend. Hope this helps!

  • @jasonspratt5424
    @jasonspratt5424 29 วันที่ผ่านมา

    your work is amazing, i am working over a shared spreadsheet which i want to be able to create a flow to send an employer an email when their employer liability insurance expires and then have a recurring every 3 days until i update the spreadsheet with their new insurance details do you think this is possible with power automation

  • @minostar
    @minostar หลายเดือนก่อน

    Hi there. Nice video. When I go for the peek code I see "table":" " so there is no name in the quotes. Thank you for your help.

  • @erikeverts2472
    @erikeverts2472 หลายเดือนก่อน

    Thanks for explaning this useful example. I have only 1 problem i get the error "Action Set_Variable failed: The variable 'varBijlage' of type 'Array' cannot be initialized or updated with value of type 'Object'. The variable 'varBijlage' only supports values ​​of types 'Array'." I get this messege when i am at 22:36 of your video

  • @DewivanBeek
    @DewivanBeek หลายเดือนก่อน

    Is there a way to either get the Task or the Task ID automated in this flow? We get multiple new tasks a day and it would be too much trouble to get the id manually every time. Other than that I learned so much building along with this video, thank you for sharing!

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! I'm unclear on how you want to trigger this flow-Power Automate is pretty limited when it comes to Planner Triggers. You can trigger your flow when: - A New Task is Created - When a Task is Completed - When a Task is Assigned to Me

  • @RobertaTessier
    @RobertaTessier หลายเดือนก่อน

  • @daveh4208
    @daveh4208 หลายเดือนก่อน

    Why do you have to cuss, so unprofessional. You lost me right there.

  • @fakhruddinsupardan5376
    @fakhruddinsupardan5376 หลายเดือนก่อน

    must with example.

  • @DrZhang-zb8wi
    @DrZhang-zb8wi หลายเดือนก่อน

    too many unnecessary steps, this guide was exhaustive but doesn't cater to the general structure if you want to create something like this. i was able to create a similar flow using way less steps to execute the same result

  • @Krzypham_17
    @Krzypham_17 หลายเดือนก่อน

    Hi, how about to hide the COMPLETED item lists in SP only visible to 2 users? Hope for your answer pls!

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! It's hard to provide specific recommendations without knowing more about your flow. I would recommend posting a screenshot of your flow as well as providing more insights on the Power Automate Community: community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287

  • @Argentinian
    @Argentinian หลายเดือนก่อน

    You're amazing! I remember when you helped me when I was just starting with Power Platform in the Microsoft forum by suggesting Power Automate ideas! I haven't forgotten your voice or your kind gesture. However, if I may, could you slow down the pace of your videos a bit? It can be challenging for non-native English speakers like me to keep up, and we often have to reduce the playback speed. I have a question for you. Inside an 'Apply to each' loop, I have a condition that evaluates an expression "is equal to" TRUE. The loop iterates over 2,500 to 3,000 records. On the NO side, nothing happens, but on the YES side, it triggers an update in SharePoint. The expression being evaluated is as follows: if(greaterOrEquals(if(greaterOrEquals(items('Apply_to_each')?['Current Start Date'], items('Apply_to_each')?['Created Date']), items('Apply_to_each')?['Current Start Date'], items('Apply_to_each')?['Created Date']), formatDateTime(addDays(utcNow(), -20), 'yyyy-MM-ddTHH:mm:ss.fffffff')), true, false) Do you think that using this expression in a Filter Array would be faster? Thanks

  • @celesterichardson8623
    @celesterichardson8623 หลายเดือนก่อน

    Do you not have to go back in and remove the ODATA filter query from ID 7?

    • @acreativeopinion
      @acreativeopinion หลายเดือนก่อน

      You do. Sorry I missed pointing that out in the tutorial.

    • @celesterichardson8623
      @celesterichardson8623 หลายเดือนก่อน

      @acreativeopinion That’s ok. Thank you for clarifying. Also, what should I do if I want to send the email to multiple colleagues? In my SharePoint list it has multiple employee emails/profiles instead of just one person. Is there a way to make that work?

  • @AyamIt-b9z
    @AyamIt-b9z หลายเดือนก่อน

    🕕🕜🕝🕒🕞

  • @RSchneider-t8e
    @RSchneider-t8e หลายเดือนก่อน

    Now I got it, but some passages I had to watch about ten times.

  • @Zootimus-lf2mb
    @Zootimus-lf2mb หลายเดือนก่อน

    Hello, very very helpful, but im having an issue wit the renaming of the folder that's being copied, I have tried everything I can think of to fix it. I'm only copying a Single folder that has the folder structure nested inside it, I just cant get the Adaptive Card Name I enter to work for the life of me.

  • @JeegarPandya
    @JeegarPandya หลายเดือนก่อน

    You are changing the screens very fast. While the steps are very detailed, it is difficult to follow them

  • @SashaUlloa-g2y
    @SashaUlloa-g2y หลายเดือนก่อน

  • @denied501
    @denied501 หลายเดือนก่อน

    Nice tutorial. Just a problem that I'm facing now, how to achieve this with SharePoint list with people column that allows multiple values? Thanks a lot.

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! Refer to this YT Tutorial: th-cam.com/video/0D2YcmdOuL8/w-d-xo.html Hope this helps!

  • @celolourenco
    @celolourenco หลายเดือนก่อน

    GODLIKE

  • @katherinebaurichter5277
    @katherinebaurichter5277 หลายเดือนก่อน

    This was so helpful! Is there anyway to add two dynamic content outputs in the JSON? I am trying to duplicate this flow but have two different checklist options based on a category selection in my form

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks for watching! It's really hard to provide specific recommendations without seeing a screenshot of your flow and without additional insights. If you are still having troubles with your flow, I'd recommend posting in the Power Automate Community: community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287 Ensure you post screenshots and include as much detail as possible.

  • @LeMarbre514
    @LeMarbre514 หลายเดือนก่อน

    th-cam.com/video/44Bk4JVMrD4/w-d-xo.html the recommendation for the "set var" action is literally the opposite, could you explain please?

  • @iddycol
    @iddycol หลายเดือนก่อน

    I've watched a lot of Power Automate videos - this is one of the best I've seen. Great explanations of some advanced techniques. Thank You.

  • @ramandeepsr
    @ramandeepsr หลายเดือนก่อน

    This is not working.

  • @SimonGjtrupKrebs
    @SimonGjtrupKrebs หลายเดือนก่อน

    hi, i have spreadsheet with 3000 linies in now. i would to use this function. Will Power Automate able to handle that amount data. Btw excel sheet is growing each day

  • @VANDIK01
    @VANDIK01 หลายเดือนก่อน

    Thanks for the video, really helpful 👋

    • @acreativeopinion
      @acreativeopinion 14 วันที่ผ่านมา

      Thanks so much for watching!

  • @BEEKEEPER-02
    @BEEKEEPER-02 หลายเดือนก่อน

    Thanks for this great tutorial. But on my path when I get the "Get file using path" the flow fails and shows this error messages indicating that 404 and file can not be found in the body. Please help me rectify this issue since its a matter of urgency to my small business processes.

    • @DMG-s1p-d3t
      @DMG-s1p-d3t 27 วันที่ผ่านมา

      I'm getting the same issue

  • @meganmcdermott5563
    @meganmcdermott5563 หลายเดือนก่อน

    I'm working on a flow that needs to be triggered once a user has internet access and comes online again. The user has stored PowerApps forms on their local device while submitting the forms offline. Those stored forms also need to be assigned incrementing page Id's (based on already existing forms in the database) before they are added to the database. For example, if the last form saved to the database has a page Id of 123, then the stored forms should be added to the database starting with 124 and incremented by 1 from there. Obviously, only the first part of my scenario relates to this video, but any help would be appreciated!

  • @pawaniimeshi5496
    @pawaniimeshi5496 หลายเดือนก่อน

    This is what I was exactly looking for. Thank you so much for uploading. It's really helpful. 👍

  • @FelixSchmitt1910
    @FelixSchmitt1910 หลายเดือนก่อน

    Thank you for this video!