- 179
- 1 239 749
Andrew Hess
United States
เข้าร่วมเมื่อ 2 ส.ค. 2020
I am a Governmental Power Platform Developer and have worked in multiple different levels of the Government located in the USA. Currently I am sharing my knowledge with the Power Platform, with PowerApps and Power Automate and much more. As we dive into other topics I love to create videos because it helps me retain knowledge and I get to share it with all of you! I love when others ask questions, that's how my channel started. So please feel free, ask a question and get a video!
My name is Andrew Hess I am a Microsoft Certified Professional and I can't wait to meet you!
My name is Andrew Hess I am a Microsoft Certified Professional and I can't wait to meet you!
Converting Excel to One to Many with a SharePoint Power App (Part 2)
Hi everyone! 👋 Let’s wrap up 2024 with a tutorial on many to one relationships and don't forget to get your questions ready so we can end 2024 as professionals! Let's take our excel sheets to the next level with relationships in SharePoint with a Power App.
This is the 2nd video of our Radios App that started out as an Excel sheet. We have convert that Excel sheet into a SharePoint list. Now let's create a clean one-to-many relationship in SharePoint.
✅ We will draw out the one to many diagram first.
✅ Then add the correct RadioID column to our Accessories List.
✅ Create a Gallery to visualize our connected accessories.
✅ Create a Form to Add New Accessories
✅ And Finally Answer More Questions!
Link to Video 1: th-cam.com/video/hFdeAiM7s34/w-d-xo.html
Chapters
0:00 Introduction
1:15 Documenting 1 to Many
7:00 Setting Up SharePoint
9:50 Designing Power Apps
12:56 Filter Based on Relationship
19:15 Designing the Form for Accessories
20:49 Default RadioID
27:00 Answering Questions - Embed Power Apps
29:11 Answering Questions - Color Columns
30:01 Answering Questions - Pro Code Instead
31:22 Answering Questions - Modern People Picker
32:03 Answering Questions - How Return All if Blank
This is the 2nd video of our Radios App that started out as an Excel sheet. We have convert that Excel sheet into a SharePoint list. Now let's create a clean one-to-many relationship in SharePoint.
✅ We will draw out the one to many diagram first.
✅ Then add the correct RadioID column to our Accessories List.
✅ Create a Gallery to visualize our connected accessories.
✅ Create a Form to Add New Accessories
✅ And Finally Answer More Questions!
Link to Video 1: th-cam.com/video/hFdeAiM7s34/w-d-xo.html
Chapters
0:00 Introduction
1:15 Documenting 1 to Many
7:00 Setting Up SharePoint
9:50 Designing Power Apps
12:56 Filter Based on Relationship
19:15 Designing the Form for Accessories
20:49 Default RadioID
27:00 Answering Questions - Embed Power Apps
29:11 Answering Questions - Color Columns
30:01 Answering Questions - Pro Code Instead
31:22 Answering Questions - Modern People Picker
32:03 Answering Questions - How Return All if Blank
มุมมอง: 456
วีดีโอ
Let's Convert an Excel to Power Apps with SharePoint!
มุมมอง 6K21 ชั่วโมงที่ผ่านมา
Hi everyone! 👋 Let’s wrap up 2024 with a practical tutorial to answer your questions and get you ready for 2025! Let's convert an Excel to a SharePoint list powered by Power Apps! We take a practical Power Apps Example to gather requirements. In this video, we’ll show you how to take an Excel document-like a fire department radio inventory-and turn it into a fully functional SharePoint list. 📝➡...
5 Variable Types in Power Apps - With(), Context, Global, Environment, & Collections
มุมมอง 83514 วันที่ผ่านมา
Discover the power of variables in Power Apps! In this video, we'll explore the five types of variables-global, context, collections, With(), and environment variables-and their unique use cases. Learn how to optimize app performance and to choose which variable type is best for your application. Whether you're a beginner or looking to refine your skills, this guide will simplify complex concep...
Send files with Power Apps V2 Trigger to Power Automate and Beyond!
มุมมอง 977หลายเดือนก่อน
There were 2 previous videos before this one about the V2 Trigger: th-cam.com/video/GQOLW7G16OI/w-d-xo.html th-cam.com/video/MLVJx8ejbBQ/w-d-xo.html In this tutorial, we'll show you how to use Power Automate to move files from a Power Apps attachment control directly into SharePoint or add them as attachments in Outlook. This step-by-step guide will cover setting up the flow, configuring trigge...
Power Apps V2 Trigger (When Power Apps calls a flow V2)
มุมมอง 1.6Kหลายเดือนก่อน
Let's take an even deeper dive into the Power Apps V2 Trigger! Here is last weeks video: th-cam.com/video/MLVJx8ejbBQ/w-d-xo.html The "When Power Apps calls a flow (V2)" trigger in Power Automate is a powerful feature that enhances the flexibility of app-building within Microsoft’s Power Platform. This trigger allows you to seamlessly initiate a Power Automate flow directly from a Power Apps ap...
Power Apps V2 Trigger More than 20 Fields
มุมมอง 1.3Kหลายเดือนก่อน
Hey everyone! 👋 Today, we’re tackling a PowerApps limitation that many of us have faced: the 20-field limit in the V2 trigger! If you've tried passing more than 20 fields to Power Automate, you know it can be a real roadblock! But there’s a simple workaround: we’re going to pass our data as JSON! By converting your collection into JSON, we can bypass that limit and send as much data as we need....
Customizing the JSON of the SharePoint Gantt Chart (Project Management)
มุมมอง 1.4Kหลายเดือนก่อน
It's time for part three! First we added the Gantt Chart to a SharePoint list. Then we overlaid Power Apps on top of the Gantt. Now it is time to customize the Gantt's JSON. Let's get into it! In this video, we dive into customizing the JSON of a SharePoint Gantt chart to create a visually compelling and functional project view. Learn how to use JSON to style task the bars, adjust color schemes...
Power Apps Integrated with a SharePoint Gantt Chart
มุมมอง 2.3Kหลายเดือนก่อน
Today we have a continuation of the custom JSON Gantt Chart in SharePoint. We will create a Power App that defaults Project Start and Project End. There are couple more adjustments like hiding TaskStart on a Milestone and changing progress into a progress bar. All of these customizations are just a start, I'm sure you could come up with more! Link to Part1: th-cam.com/video/qrH3bGq0YQ4/w-d-xo.h...
Turning a SharePoint List into a Gantt Chart
มุมมอง 3.2K2 หลายเดือนก่อน
Hey everyone! 👋 In today’s video, we'll be walking through how to implement a JSON provided by Geert de Kooter into a SharePoint list. Along the way, we’ll cover some key tips and changes to watch out for. This is part 1 of a 2-part series, so make sure to stay tuned for video #2, where we’ll be integrating Power Apps! I'm super excited about this one! Don't forget to subscribe and hit the noti...
Using Ungroup for Flattening your Data Source in Power Apps (Data Manipulation)
มุมมอง 6212 หลายเดือนก่อน
Last week we made a video based on Flattening your dataset and we used ForAll, and after a realization maybe it's better to use Ungroup. Here is last weeks video: th-cam.com/video/244WMVLuZck/w-d-xo.html Ungroup may be a better alternative, but in my opinion learning both is the most important! Discover a simple method to ungroup a multi-select field in SharePoint! In this tutorial, we break do...
Flattening a Data source in Power Apps (Data Manipulation)
มุมมอง 1.3K2 หลายเดือนก่อน
From a user request we are going to flatten out a data source in Power Apps. Formulas are in the description below! Learn how to flatten a table in Power Apps by transforming multi-choice fields into separate rows for each selection. This quick tutorial will show you how to restructure your data to create a more simplified and accessible format, perfect for reporting and analysis. Whether you'r...
Creating a Responsive Gallery in the Thumb Friendly Zone
มุมมอง 5763 หลายเดือนก่อน
When designing responsive Power Apps, it's important to consider the thumb-friendly zone-the area on a mobile screen that's easiest for users to reach with their thumb. Now you do want to think about right-handed, left-handed, or if both hands will be used for your application. Sadly right now I normally create apps for right handed people, but maybe this is something you want to do different t...
Create Brand New Excel File Based on Gallery Selection in Power Apps
มุมมอง 2.6K3 หลายเดือนก่อน
Ever need a brand new Excel file or .csv from a selection in Power Apps. In this tutorial, we will show you how to create an Excel file directly from a Gallery selection in Power Apps! Learn how to capture data from your app's gallery and export it into a neatly formatted Excel file with just a few clicks. This step-by-step guide is perfect for anyone looking to improve their app's functionalit...
How to create a Collection from your Selection in Power Apps
มุมมอง 3.1K3 หลายเดือนก่อน
How to create a Collection from your Selection in Power Apps
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
มุมมอง 4.6K3 หลายเดือนก่อน
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
Create a Power App with 3 Screen Templates (Beginner Tutorial)
มุมมอง 1.3K3 หลายเดือนก่อน
Create a Power App with 3 Screen Templates (Beginner Tutorial)
How to Easily Create a Left Side Navigation in Power Apps
มุมมอง 1.3K4 หลายเดือนก่อน
How to Easily Create a Left Side Navigation in Power Apps
Create News Posts with Power Automate and SharePoint Automagically
มุมมอง 2.2K4 หลายเดือนก่อน
Create News Posts with Power Automate and SharePoint Automagically
Emailing Gallery Selections in Power Apps with an Email Template
มุมมอง 1.7K4 หลายเดือนก่อน
Emailing Gallery Selections in Power Apps with an Email Template
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
มุมมอง 1.1K4 หลายเดือนก่อน
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Write your Other Choice in a Combo box with Power Apps
มุมมอง 2.6K5 หลายเดือนก่อน
Write your Other Choice in a Combo box with Power Apps
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
มุมมอง 3.3K5 หลายเดือนก่อน
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
มุมมอง 4785 หลายเดือนก่อน
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Simple Leave Request App for Teams | Power Apps or List Form
มุมมอง 9K5 หลายเดือนก่อน
Simple Leave Request App for Teams | Power Apps or List Form
ChatGPT Whisper with Power Automate (Voice to Text)
มุมมอง 1.3K6 หลายเดือนก่อน
ChatGPT Whisper with Power Automate (Voice to Text)
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
มุมมอง 7856 หลายเดือนก่อน
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Use ChatGPT-4o Vision on Images with Power Automate
มุมมอง 1.6K6 หลายเดือนก่อน
Use ChatGPT-4o Vision on Images with Power Automate
Custom Connector Power Automate & Chat-GPT Images using Dall-E
มุมมอง 7876 หลายเดือนก่อน
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Connect Power Automate & ChatGPT-4o with Custom Connector
มุมมอง 6K6 หลายเดือนก่อน
Connect Power Automate & ChatGPT-4o with Custom Connector
Wait! Solve Delegation Easily! In Power Apps Search
มุมมอง 10K7 หลายเดือนก่อน
Wait! Solve Delegation Easily! In Power Apps Search
Nice video! Is it possible to add a repeating table in word template?
Yes with the Power Automate or App premium connector
❤amazing tutorial ❤️
Thank you Munawar !
This works perfectly! one thing i wish i could do would add a image from the new item on the list with each news post. Any idea how this could happen? ive searched all over and keep running into a wall trying to combine a few different methods thanks!
Hey Brian! I am currently running into the same exact thing.. and trying to figure it out. It's like there's some kind of security feature thats blocking me with the images.
@@andrewhess123 Yes! Let me know if you find a work around. I try looking into pulling it from the API Get files route and it still keeps giving me a error!
Is this a Canvas power app or a Model Driven? Or a Canvas app that interfaces with a Model Driven app? Very spiffy user interface!
This is custom JSON for the view in SharePoint. No power apps needed :)
Great job! You just saved me from creating one template by number of rows possible 🙏🙏
Woo Woo! Nice Charles !
Apologies Mr Andrew, Taking this opportunity with regard to this video, I’m using multiple screens. I would like to add a pop up or a reminder to the end user to SAVE or you might lose the current data when you move to next screen when in editing mode not in new mode. I’ve tried on so many different ways but still can’t get it right. Would you happen to know a better solution please
Good one, love the idea!
@ thank you
Hello Mr Andrew, Thank you so much for covering and mentioning my question. It was awesome to see how you made it look so easy but for me this is a stepping stone to getting to where I want to be. Brilliant work and thanks again for sharing your thoughts and knowledge with us. Respectfully yours Moe.
Once you put the power app on the sharepoint page you can drag the corner of the power app web part to increase the size on the webpart on the page.
Ahhhh! Thank you!
Hi Andrew, thank you for this video! If you are in the UK, do you know how you would change the date format so that it shows DD/MMM/YY (sorry the Brits are always being awkward...) Thanks!
can someone help, I've copied the exact formula but the Submit button still appearing even if fields are blank
What's your formula? I'm guessing your fields dont match up to "DataCardValue9" are you on a different DataCardValue? Use the color coding too that Power Apps gives you to double check.
Thank you Andrew, cannot wait for the next video. I always learn something new from your videos, today was the sharepoint import from excel function and the field_n names. I always wondered where the names came from in my code.
Nice thomas! Yeah that drove me crazy forever 😋 Thanks for watching hope this next video is just as good!
OMG My mind is spinning! Thanks for this!
Woooo! Nice! Thanks for watching Dustin!
Can we embed a power-app form in a sharepoint page, so that user does remain within sharepoint environment and update data in sharepoint list?
Yes, you can also embed a power app into a list and replace the form.
And how do I make it trigger with a date-type column? For example: if the user modifies the value and changes the date to any other?
Does this work without having to add project start and project due?
Those fields are required.
Thanks - if you read this. I followed another example of how to do this same thing except using gallery and then putting checkbox control inside it. Everything seems to work fine, with the exception of when my users create a new entry into the SP list, using the custom form, if they hit submit, and the form remains, waiting for another entry to the list to be made, there are ghost entries in the gallery checkboxes. I am using collections to store the values of what is selected but having no luck clearing that when the user would just continue to add another list item. I have labels present also that displays the selections / or contents of the collection when selections are made. They are incidentally clear when the new form appears, even though there is a ghost check in the boxes. Have you seen this behavior before/ any thoughts recommendations? Sorry, this was long, seems like there is a lot to explain and it's a complicated setup (to me).
I have a couple guesses but if when the user submits and it makes a ghost entry, and you are using collections. You will need to recollect to populate your gallery, if your gallery is attached to the collection. When you say ghost in the check boxes, does that mean you have to click it more than once for it to recheck? Try modern and classic checkboxes too, is there a difference?
@@andrewhess123 so the first time through the form, works fine. It is when the user begins a new form, after a submit action. The selections from the previous form submission are still checked, which is undesired. Interesting also is the label I have to troubleshoot and display what is in the collection indicates that the collection is empty at that time. User has to select another checkbox or uncheck and recheck to activate. So my issue is what remains after the first submission. Hope that helps clarify my issue. I used a gallery to set it up which is different from your method. I am going to try and set it up the way you did in video. Seems much less complicated.
@@andrewhess123 thanks for the reply BTW! 🥹
@@kenpennuto2590 So I have seen something similar I can't remember exactly what I did... but on the OnCheck and UnCheck Property set it to UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox}).... and on the Checked Property set to ThisItem.varCheckbox
@@kenpennuto2590 I remember when I did this video there was this "Ghost Checkbox" as you were calling it. th-cam.com/video/hIDRup4LcHE/w-d-xo.html I think this video is very valuable and one of my better videos 😋this one were commenting on is old and outdated.
Incredible tip for transferring an Excel table to a SHAREPOINT list 😍😍😍😍 - Thanks a lot
Hey Thank you Cédric! Hope it helps!
Checked option does not exit in my power apps checkbox property? Only I do have OnCheck, OnUncheck, OnSelect.. etc Why is that?
Could be the difference between the modern check boxes and the old classic ones?
Hi Andrew. I made already lots of apps. I use TH-cam and Chat GPD a lot and I learnt everything there. I love the way you explain it and to see the entire process from the start. Especially useful and I want to compliment you for that!! Greetz from Joure the Netherlands!!
Thank you Steven I appreciate that! Hope to visit the beautiful Netherlands some day.
Got a new sub! Valueble information and looking forward to next weeks followup
Heyy! Thank you Dytlief! 🥳🎉
Your part one isn’t available anymore..?
Hi Nancy! Yeah... things changed from Microsoft and I had many comments about how it wasn't helpful anymore, so had to remove it. There were a good bit of negative comments. But this still works.
Absolutely helpful!
Heyy! Thank ya Carlos! 🎅
Hi Andrew, nice tutorial, but what if the file attachment should be optional? I have built an app where I have plenty of inputs and attachment control. File upload should be optional, I can't run the flow if the attach. control is blank, it is expecting some data,. If I mark file input optional in Power Automate , Power Apps doesn't pass file data and I can't use it in my Flow to Add A file to the SharePoint List. :(
Hey County Simcoe! One easy option would be just put an If statement in your submit button and if your attachment control is empty run the Power Automate Fx without the Power Automate function.
Nice job!!! Amazing video !!! One question. The content of the table is locked, is possible modify in the word document ? Best regards!!
Thank you nice video. i want to put some of the file relating some event or milestone , copy to document library assigned each PJ
Thank you hiro! I always love the name Hiro.
Great subject and great video. Happy holidays
Thank you Moe! Happy Holidays to you as well!
Hello, i'm having a problem the box choices in a Modern Forms linked to a sharepoint List. I need to be able to search into my entire organization for names, but when i use the modern choices in a forms, it only shows a limited list of persons from my organisation and i can't search for a person who is not on that list. Any solution to this?
Next videos, I'm going to try to knock out many of the questions from comments in all of my TH-cam videos. Feel free to ask more below!
@@andrewhess123 Hi Andrew, Definitely can’t wait for the next video where hopefully you will cover one-to-many relationships for Sharepoint. I’m struggling with this subject and could never get it right.
@@moechaba5322 I think thats the plan, to go into the 1:n or 1 to many relationship using SharePoint. Thanks Moe!
I've been using power apps for awhile now and recently my boss wants for me to learn power bi. I wish you had shown the steps up to the point where you created the power bi screen leading up to the power apps section. Power BI look so very different than power apps, it's kind of sharepoint ugly. but the graphs are pretty.
Hey Thomas! Yeah understandable, I can probably get a new video in the future with a very simple Power BI and then embed or integrate it in a Power App.
I have to start finding reasons to use With() within apps
Hey Scott! Yeah me too, I feel like I could remake a few apps using the With() more often.
Hi Andrew! May I ask how to make my gallery look just like yours? I mean how to set the color of each column?
This is fantastic buuuut you can create multiple page PDFs
Yep I want to make a new video about this. Before you couldn't when it first released
Great content, thanks a lot!
Thanks Patrick!
Have you encountered a situation, where you have created a complex app, liked the visuals, logic behind it etc... but decided it would be easier to maintain, "upgrade" etc.. if it was written using traditional code? Or actually done that? To build app using powerapls app you've created as a template?
Yes 100%, sometimes you need more Power than a Power Apps and some applications should be custom developed and a Power App can be that temporary fix until you can get a full app in development by your Dev Team. I totally think this is a viable path and one that I have followed.
Collection please
Alright, I'll write down to make a new video on collections. Thanks Mikey!
Hi Andrew, Thank you for the insightful video on creating news posts with Power Automate and SharePoint-it was incredibly helpful! I'm currently working on aggregating Microsoft Teams channel posts into a SharePoint list so I can publish them as a "news reader" on my SharePoint site. Your video provided excellent guidance on transforming list items into news posts; however, I'm struggling with the initial step of fetching posts from selected Teams channels into SharePoint. Do you have any tutorials or resources that cover this process? Thanks again for your excellent content!
Hey nib! So I believe I would use "For Selected message in Teams" trigger and run the Power Automate that way. You can select a item or post from Teams and then just create the News Post that way. You can see a screenshot of it here: learn.microsoft.com/en-us/power-automate/trigger-flow-teams-message#trigger-the-flow
Saved me I was searching from hours, Thank you
Excellent! Thanks for watching
Your video is very helpful for new Power Apps users like me. In the video, I understand that colItemOrder is Gallery1, but which one is colMyGallery? Please guide me
Hi, could you please go into how to restrict public access to the service but only enable it through the powerautomate of the tenant or a specific user?
I often use With() as part of invoking a Flow - create variables the flow will need, invoke the flow, dispose the variables on exit.
Heyy yogi! Thanks for sharing, this is an awesome idea! I will have to use this more often!
Hi Andrew, very informative, and thank you for the high-level information regarding, "managed and unmanaged" solutions, thanks for sharing your knowledge 👍👍
Hey imran! Thanks for watching again, I kinda just brushed on that topic I feel like it's a whole video in itself. 😆Maybe that one will come up soon too 😀
@@andrewhess123 you are welcome, no, it was clear and made sense to me, looking forward to the new content 😊😊
@@imran002ali Excellent! Just trying to keep it simple 😀
Hello Andrew, I made 2 lists one parent for Questions only editable by the creator and a second list with answers also only editable by the creator. Can you add and link that child list to your parent list (items sold)? Would that work?
so they each have different owners/creators? If they each have different owners you probably would need power automate. If you have permissions to both you can do a sharepoint lookup or directly connect them in Power Apps. But if you have questions and answers, maybe the best solution is to use a MS Form and have it connected to a SharePoint list. So whomever can answer the questions on MS Form, and then you can have different permissions on the SharePoint list it writes to. Maybe this is a video 😅
@@andrewhess123 In each list I made 'creator only can edit' and view 'can everyone'. But how can I connect the answers to the parent (question/topic)? Sharepointintegration.selected.ID with lookup field or ...? Can I post here a picture?
@@videobewerker111 So you need a second ID field that relates to the first in the 2nd list so the first list can understand. Then you can do a LookUp() in Power Apps. Sadly you can't post pictures here. Does this link help? community.powerplatform.com/forums/thread/details/?threadid=36e5804f-0bee-4e6a-96a4-5e08fe537173 See the "Relevant QuoteID" in the image? Here is another example doing a different way: sharepoint.stackexchange.com/questions/309883/powerapps-sp-form-referencing-list-item-value-in-another-list
Ridiculous Microsoft doesn't handle this out of the box..
Yeah, dunno my opinion about other is usually its always a bad option, data integrity, data validation, all ruined with other fields
Thank you so much for this video. but i have a problem in Action 'Add_a_row_into_a_table' failed: A value must be provided for item. clientRequestId: 59dd6b49-1291-49f6-b80b-16fe74b351e0 , i can't fix this :((((
So I believe you have a null value somewhere and it not allowing you to write a null. Try on a smaller subset of data with 0 null values, then move on from there.
I've used the power platform for the last 2 years doing complex apps, and I have some feedback: Dataverse is NOT a relational database system due to querying limitations, such as the inability to do more than a few joints down. - Do create primary keys. I've seen large and complex projects with more than 30 custom tables without any keys created. The default GUID is not enough to guarantee data integrity. - Sometimes your data are too far away, and you cannot access it through the lookups chain (lookup1(table1).Lookup2(table2).lookup3(table3).MyValue) you may find yourself denormalizing by bringing the "MyValue" field to table3 or maybe table2, if you are in this kind of situation, my advice would be to use another (real) relational database like azure SQL / PostgreSQL / MY SQL you named it. - If you don't know about normalization, do not design the relational model before learning how to normalize to 3rd NF. - If your app is too complex, or if performance is a key feature of your project, consider going "from scratch, for me the best practice is never to use power apps as your default tool, if you dev skills and you and your team can build an app end to end, the default way should be going "from scratch", only use power apps if you are going to win a considerable amount of time and money by using it, like if your apps have a bunch of integrations with Microsoft apps, outlook office365, azure AD, dynamics 365..., power apps and power automate could be your best bet for this kind you scenarios, coding all the integrations yourself would take you days / weeks.
I agree a lot with your last bullet point. Power Apps should not be your #1 app tool if your app is highly complex. But it is a tool for your toolbelt and good to know. Not everyone is a senior developer and too allow citizen developers to solve problems quickly can be very beneficial to a business. Also agree that SQL is the best option down the road if you have the time and resources..
Hello man. One quick question; What is the && for?
And, And(), &&, can all be used the same. It's an AND operator. learn.microsoft.com/en-us/power-platform/power-fx/reference/operators. An example like Price < 100 && Slider1.Value = 20 or Price < 100 And Slider1.Value = 20
Thanks a lot man. I took a course on another Plattform, paid, with a 5 hour content; and I feel this 15 minute viddeo gave me more knowledge than that one. Great content, great way to explain things; new sub here. Question: do you have any online courses?
Interesting, did they teach you dataverse right away? I'm thinking of working on some courses now.
@@andrewhess123 they explained some of the major topics of what it is and how to connect to each one, but they only worked there with lists. Actually I found you because I'm trying to work on an app that uses excel as a reference and I've been struggling to make a search bar filter and referencing the columns. If you could deepen a little bit over that (formulas/functions), it would be great.
Andrew, awesome video. I have the collections but am having trouble patching the selected items to my sp list.
Hi Zac, I think I had a few videos on patching the collection, what is the issue you are facing?
Will this process work for inserting images or pictures taken through the app?
No that will not work here. But you can try using the PDF feature in power apps instead. Or premium powerapps or automate.
Hi Andrew, how can I delete all the SharePoint list items using power automate which more than 10k items
Hi MANJUNATHA, you may run into throttling issues doing this. But you will need to create a loop and increase pagination and adjust the get items. Probably would want to filter by date? then delete 5000 at a time. So you can do a get items do 5000, then do another get items and do another 5000. It may take some time to do this.
@andrewhess123 thanks. However when I am searching regarding this one of the youtuber mentioned that we can use batch api as it is very fast , I have tried similar way but unable to delete items , if we have Short video on this using batch api it is more helpful th-cam.com/video/2ImkuGpEeoo/w-d-xo.htmlsi=OqJk1NLvA9a_HTuZ BM