- Видео 145
- Просмотров 523 759
Data is King
США
Добавлен 20 авг 2021
Data is King is a RUclips Channel that is Dedicated to Provide Extensive Training and Support in Power BI, Power Query, Data Modeling, Power Apps, Power Automate, and other applications. Please Like, Share, and Subscribe to the Channel
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 ...
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...
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
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
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
Excellent! Your clear explanations, examples, slower pace, and exact results are super helpful, thanks so much!
thank you, this helped!
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.
what are the difference between the values for initialize variables and set variables?
You make my life easier.. Thumbs up for a straightforward steps... I love you for this
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.
@@sarahsmile57545 I can create another video on how to set up cascading parameters
This video was beneficial. I used the transcript to follow along because everything was not displayed while you were performing each task. Very insightful!
think the screen share was not working
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.
I think this is possible. I haven't tried it, but it's a great video idea
@ 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.
I love this video so easy to follow. What do we do with 0?
0 is not used
I really appreciate your capturing and going over all of the details, thank you very much.
Great! Your video help me a lot, thank you.
Can you send me this lol, seriously
What is your email?
creepy.
was thinking exactly the same thing...
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
How can I get the tbl_Calendar list properties?
Thanks for sharing!
Thank you. the date code doesn't work Text(Now(),"[$-en-GB]dddd, dd mmm yyyy") or am i missing somthing cheers
Love this app well done. Not sure of your name but appreciate the knowledge
Thank you very much for a very clear explanation, easy to replicate and generalise.
@ Data is king can you please drop a copy of this timesheet and sharepoint lists
Thankyou so much ❤
please share the code on Save button which saves the data in Sharepoint list
Can you please give me the code? Will it track template download as per user login?
Very Cool! Thanks for sharing!
Do you think this would work if you wanted to move a program written in access over to power apps ?
Yes I've done it before
Please share the Workweek formula 10:20 in SharePoint list
=CONCATENATE(TEXT([Start Date],"mm/dd/yyyy"),"-",TEXT([End Date],"mm/dd/yyyy"))
Thanks. I've been after a basic intro for a while, just to help me to put the various bits together.
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 :)
Your videos are amazing. I really like it. I am a new subscriber to your channel. Can I talk with you Data is king?
WHICH POWER AUTOMATE SOFT IS THIS ? POWER AUTOMATE FOR DESKTOP OR any other?
Everything well explained,but how the data is getting saved in SharePoint list using collection is not shown?
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?
Thank you so much for going step by step and by explaining all the details. How could we please get the timesheet from you?
Can you share where the tbl_timcard came from. How do you direct the patch to the timecard list?
How would I create voice-activated input in place of typing?
This girl isn't real, isn't?
Hi Data Is King, is it possible to save and export all the data include detail of in time, lunch in, leaves out, etc?
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.
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.
Change the format of the textbox to Number
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 )
So does this mean if my original excel file changes then my List will be updated?
No your original file is not linked to SharePoint
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
Is it possible to use excel instead of Sharepoint List?