Data is King
Data is King
  • Видео 145
  • Просмотров 523 759
How to Use Power Apps Gallery to Match and Display Part Numbers from Two Dataverse Tables
In this tutorial, we’ll walk you through how to display matching part numbers from two separate Dataverse tables in a Power Apps gallery. Whether you are a beginner or an experienced Power Apps user, this step-by-step guide will help you leverage Dataverse's data connectivity and Power Apps' gallery functionality to create dynamic, filtered views of your data.
Key Points Covered in the Video:
Understanding the Dataverse Structure:
Learn how to set up your two Dataverse tables that contain the part numbers you wish to match.
We'll show you how to import your data, ensuring the relevant fields (part numbers) are correctly formatted and ready for comparison.
Creating a Power App Gallery:
Discover ...
Просмотров: 49

Видео

How to Create Roulette in Power Apps
Просмотров 129Месяц назад
Have you ever wondered how you can create the game of Roulette at the Casino in Power Apps? Click the link below for access to the Full Course www.udemy.com/course/how-to-build-a-roulette-table-in-power-apps/learn/lecture/47340563#overview Disclaimer: All the uploaded videos are 100% copyright protected and no one can reuse them without my permission. They are just self-created and uploaded for...
How to Play Roulette (Overview)
Просмотров 522 месяца назад
How to Play Roulette (Overview)
Vote on the Next Power Apps Game to Build
Просмотров 292 месяца назад
Vote on the Next Power Apps Game to Build
How to Create 10 Calendar Queries in Power Query
Просмотров 1167 месяцев назад
How to Create 10 Calendar Queries in Power Query
Power Query Deep Dive - List Functions
Просмотров 1479 месяцев назад
Power Query Deep Dive - List Functions
Unleash the power of custom functions in Power Query
Просмотров 2209 месяцев назад
Unleash the power of custom functions in Power Query
Python Bar Chart Tutorial for Beginners
Просмотров 3511 месяцев назад
Python Bar Chart Tutorial for Beginners
Unleash Your Creativity: Build an Exciting Roulette App in Power Apps
Просмотров 288Год назад
Unleash Your Creativity: Build an Exciting Roulette App in Power Apps
I Only Use Excel Once I Learned THIS
Просмотров 94Год назад
I Only Use Excel Once I Learned THIS
Move a Dialog Box with Ease using the Slider Control in Power Apps
Просмотров 1,6 тыс.Год назад
Move a Dialog Box with Ease using the Slider Control in Power Apps
Create Dataverse Views for EASIER Power Apps Filtering
Просмотров 1,2 тыс.Год назад
Create Dataverse Views for EASIER Power Apps Filtering
Power Up Your Power Apps: How to Include 'All' Option in Dropdown Filters
Просмотров 4,9 тыс.Год назад
Power Up Your Power Apps: How to Include 'All' Option in Dropdown Filters
How to Filter a PowerApps Gallery by Date
Просмотров 3,6 тыс.Год назад
How to Filter a PowerApps Gallery by Date
"Fixing PowerApps Delegation: How to Return More than 2000 Items in One Query" A Comprehensive Guide
Просмотров 4,5 тыс.2 года назад
"Fixing PowerApps Delegation: How to Return More than 2000 Items in One Query" A Comprehensive Guide
How to Add Days to Your Flow in Power Automate
Просмотров 4 тыс.2 года назад
How to Add Days to Your Flow in Power Automate
PowerApps Timesheet - Save Hours Breakdown
Просмотров 2,4 тыс.2 года назад
PowerApps Timesheet - Save Hours Breakdown
Power Apps Timesheet - Entering and Saving Hours
Просмотров 2,5 тыс.2 года назад
Power Apps Timesheet - Entering and Saving Hours
Supercharge Your Workflow: Automate Excel Data to SharePoint
Просмотров 15 тыс.2 года назад
Supercharge Your Workflow: Automate Excel Data to SharePoint
Don't Let This Surprise Your Employees
Просмотров 9742 года назад
Don't Let This Surprise Your Employees
How to Create a Parallel Branch Flow in Power Automate
Просмотров 3,7 тыс.2 года назад
How to Create a Parallel Branch Flow in Power Automate
How to Create an Excel table DYNAMICALLY using Power Automate
Просмотров 4102 года назад
How to Create an Excel table DYNAMICALLY using Power Automate
How to Replace Text from a File from OneDrive Using Power Automate
Просмотров 4,1 тыс.2 года назад
How to Replace Text from a File from OneDrive Using Power Automate
How to Migrate from Microsoft Access to Dataverse
Просмотров 2,7 тыс.2 года назад
How to Migrate from Microsoft Access to Dataverse
How to Connect a Dataverse Table to PowerApps
Просмотров 4,9 тыс.2 года назад
How to Connect a Dataverse Table to PowerApps
How to Create a Collection in Microsoft Power Apps
Просмотров 2402 года назад
How to Create a Collection in Microsoft Power Apps
Power Query Quiz Challenge - Test Your Knowledge
Просмотров 1,2 тыс.2 года назад
Power Query Quiz Challenge - Test Your Knowledge
Power Apps Timesheet Creator Part 12
Просмотров 1,5 тыс.2 года назад
Power Apps Timesheet Creator Part 12
Power Apps TimeSheet Creator Current Week
Просмотров 3 тыс.2 года назад
Power Apps TimeSheet Creator Current Week
Power Apps TimeSheet Creator Word Document
Просмотров 4,2 тыс.2 года назад
Power Apps TimeSheet Creator Word Document

Комментарии

  • @awakenedsight
    @awakenedsight 6 дней назад

    is it possible that you still have the excel format for the tbl_calendar that you have formated into a table or you just created a new list form sharepoint. if you have an excel file can you share it

  • @dustymandan2488
    @dustymandan2488 11 дней назад

    Excellent! Your clear explanations, examples, slower pace, and exact results are super helpful, thanks so much!

  • @samsuvak
    @samsuvak 22 дня назад

    thank you, this helped!

  • @morganmetzger5832
    @morganmetzger5832 Месяц назад

    ugh I'm doing this from Dataverse on Account ID and nothing seems to pass correctly. I can see the gallery doing the correct thing with the blank photo. I try everything. PowerBIIntegration.Data.'account'[Account], PowerBIIntegration.Data.accountid, PowerBIIntegration.Data.account, etc. Nothing seems to work. blankity blank blank. Super unintuitive Integration.

  • @ha5izmutali8
    @ha5izmutali8 Месяц назад

    what are the difference between the values for initialize variables and set variables?

  • @jekboy2003
    @jekboy2003 2 месяца назад

    You make my life easier.. Thumbs up for a straightforward steps... I love you for this

  • @sarahsmile57545
    @sarahsmile57545 2 месяца назад

    Can you have cascading parameters with this same exercise? Because you do not have access to SQL(Query Designer) for your parameters in this case.

    • @DataisKing
      @DataisKing 2 месяца назад

      @@sarahsmile57545 I can create another video on how to set up cascading parameters

  • @sarahsmile57545
    @sarahsmile57545 2 месяца назад

    This video was beneficial. I used the transcript to follow along because everything was not displayed while you were performing each task. Very insightful!

  • @kaplanjason
    @kaplanjason 2 месяца назад

    think the screen share was not working

  • @jazlynhernandez1642
    @jazlynhernandez1642 2 месяца назад

    This is very helpful! Thank you so much. Question: Will this work with multiple combo boxes on the same form instead of separate using a line graph? For example, say you wanted to filter your data (allowing multiselect as well) by year, month, and specific IDs, all created by individual queries and grouping the ID, month or year to extract unique data.

    • @DataisKing
      @DataisKing 2 месяца назад

      I think this is possible. I haven't tried it, but it's a great video idea

    • @jazlynhernandez1642
      @jazlynhernandez1642 2 месяца назад

      @ I tried yesterday without the button and it didn’t work for me. I’ll keep trying but until then I am looking forward to your video.

  • @benoau
    @benoau 3 месяца назад

    I love this video so easy to follow. What do we do with 0?

  • @alejandromiranda8211
    @alejandromiranda8211 3 месяца назад

    I really appreciate your capturing and going over all of the details, thank you very much.

  • @elianaazeredo4013
    @elianaazeredo4013 3 месяца назад

    Great! Your video help me a lot, thank you.

  • @smartmoneyorbuyersremorse8228
    @smartmoneyorbuyersremorse8228 3 месяца назад

    Can you send me this lol, seriously

    • @koutlaw30
      @koutlaw30 3 месяца назад

      What is your email?

  • @DrSeethe
    @DrSeethe 4 месяца назад

    creepy.

    • @psla2592
      @psla2592 3 месяца назад

      was thinking exactly the same thing...

  • @finnaspam
    @finnaspam 4 месяца назад

    adding a line button adds into timesheetlines, but does not add on the screen, hitting the clearing button does not clear rows on screen but instead clears in timesheetlines collections, help pls

  • @chartwellstaffing4379
    @chartwellstaffing4379 4 месяца назад

    How can I get the tbl_Calendar list properties?

  • @picapica9
    @picapica9 5 месяцев назад

    Thanks for sharing!

  • @jacobornman455
    @jacobornman455 6 месяцев назад

    Thank you. the date code doesn't work Text(Now(),"[$-en-GB]dddd, dd mmm yyyy") or am i missing somthing cheers

  • @makdaddy8888
    @makdaddy8888 7 месяцев назад

    Love this app well done. Not sure of your name but appreciate the knowledge

  • @marctrudeau9811
    @marctrudeau9811 7 месяцев назад

    Thank you very much for a very clear explanation, easy to replicate and generalise.

  • @karthiktinku5378
    @karthiktinku5378 8 месяцев назад

    @ Data is king can you please drop a copy of this timesheet and sharepoint lists

  • @alcopopgaming7601
    @alcopopgaming7601 8 месяцев назад

    Thankyou so much ❤

  • @yashchopra8824
    @yashchopra8824 9 месяцев назад

    please share the code on Save button which saves the data in Sharepoint list

  • @ajayrathod7777
    @ajayrathod7777 9 месяцев назад

    Can you please give me the code? Will it track template download as per user login?

  • @EpicBizHero
    @EpicBizHero 9 месяцев назад

    Very Cool! Thanks for sharing!

  • @sdotcam1
    @sdotcam1 9 месяцев назад

    Do you think this would work if you wanted to move a program written in access over to power apps ?

    • @DataisKing
      @DataisKing 9 месяцев назад

      Yes I've done it before

  • @Myshudhage
    @Myshudhage 10 месяцев назад

    Please share the Workweek formula 10:20 in SharePoint list

    • @gvdlaarse
      @gvdlaarse 6 месяцев назад

      =CONCATENATE(TEXT([Start Date],"mm/dd/yyyy"),"-",TEXT([End Date],"mm/dd/yyyy"))

  • @matthewpage4706
    @matthewpage4706 10 месяцев назад

    Thanks. I've been after a basic intro for a while, just to help me to put the various bits together.

  • @juanhaces3501
    @juanhaces3501 10 месяцев назад

    Helloooo! i dont see the moment when you create variable for add a line (total Line) can u say me how u created? thank you very much for the video :)

  • @anikdasdigital
    @anikdasdigital 10 месяцев назад

    Your videos are amazing. I really like it. I am a new subscriber to your channel. Can I talk with you Data is king?

  • @keepitsimple7394
    @keepitsimple7394 10 месяцев назад

    WHICH POWER AUTOMATE SOFT IS THIS ? POWER AUTOMATE FOR DESKTOP OR any other?

  • @bharathraj8296
    @bharathraj8296 11 месяцев назад

    Everything well explained,but how the data is getting saved in SharePoint list using collection is not shown?

  • @lutzknabel3141
    @lutzknabel3141 11 месяцев назад

    This works fine for bar charts, but if I want to use a stacked bar chart it does not accept the filter from the form in the query anymore. Any Ideas?

  • @BacharIbrahim-c4s
    @BacharIbrahim-c4s Год назад

    Thank you so much for going step by step and by explaining all the details. How could we please get the timesheet from you?

  • @darr1892
    @darr1892 Год назад

    Can you share where the tbl_timcard came from. How do you direct the patch to the timecard list?

  • @112584061
    @112584061 Год назад

    How would I create voice-activated input in place of typing?

  • @ibrames3
    @ibrames3 Год назад

    This girl isn't real, isn't?

  • @yanika4031
    @yanika4031 Год назад

    Hi Data Is King, is it possible to save and export all the data include detail of in time, lunch in, leaves out, etc?

  • @FatimaAlly-pw1ef
    @FatimaAlly-pw1ef Год назад

    was @diparnaadhikary7648 comment about "connecting the data from the collection upon clicking on the "submit" option to the list in the sharepoint list tbl_TimeCard" attended to. Please help as i am unsure where else to reference the sharepoint list to be able to save data from the app to it. Ive watched both parts 1 and 2 of the series and am unable to write the data to the sharepoint list (tbl_TimeCard) after clicking on "save" button.

  • @lijunchen
    @lijunchen Год назад

    This is a very good tutorial with detailed instructions. I can follow without problem until halfway when the "With" function is used to add up the hours for Total Hours text input. I was told the argument type is invalid in the formula of "with" function. The list of 7 input values MondayHours+TuesdayHours ... are red underlined. It shows their data type as "control" instead of "number". I already set their default values as 0 with number format. I am baffled by this. Can you advice what can be the problem? Thanks.

    • @DataisKing
      @DataisKing Год назад

      Change the format of the textbox to Number

    • @overheadpotato
      @overheadpotato 6 месяцев назад

      This worked for me: With( { mon: InputHours_Day_1.Text, tue: InputHours_Day_2.Text, wed: InputHours_Day_3.Text, thu: InputHours_Day_4.Text, fri: InputHours_Day_5.Text, sat: InputHours_Day_6.Text, sun: InputHours_Day.Text }, mon+tue+wed+thu+fri+sat )

  • @rmjaln
    @rmjaln Год назад

    So does this mean if my original excel file changes then my List will be updated?

    • @DataisKing
      @DataisKing Год назад

      No your original file is not linked to SharePoint

  • @johnnykal
    @johnnykal Год назад

    When I add new Line to Gallery, thee Total Hours is copied from the line above it and clicking on Reset does not Delete the Total Hours in Line 1

  • @JKo-t5o
    @JKo-t5o Год назад

    Is it possible to use excel instead of Sharepoint List?