- 52
- 53 040
Sanjiv Venkatram
เข้าร่วมเมื่อ 25 ก.พ. 2009
Greetings, hope you and family are well.
Microsoft Power Platform allows us users to bring our ideas to reality on our terms and in a timeframe of our choosing. My goal is to share and learn from the community about the possibilities with Microsoft Power Platform and other related technologies.
Microsoft Power Platform allows us users to bring our ideas to reality on our terms and in a timeframe of our choosing. My goal is to share and learn from the community about the possibilities with Microsoft Power Platform and other related technologies.
Creating agents using Copilot Studio & make a complete and secure solution (emded in Power Apps)
Greetings folks,
Here's a detailed walk through of creating complete and secure solutions using the Microsoft Power Platform (Apps, Automate, Agents in Copilot Studio) and SharePoint.
I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanjiv@prudentia-consulting.
Kind regards,
Sanjiv
Here's a detailed walk through of creating complete and secure solutions using the Microsoft Power Platform (Apps, Automate, Agents in Copilot Studio) and SharePoint.
I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanjiv@prudentia-consulting.
Kind regards,
Sanjiv
มุมมอง: 268
วีดีโอ
Security & governance in Power Apps and corresponding SharePoint List (business access perspective)
มุมมอง 2422 หลายเดือนก่อน
Greetings folks, Here's a walk through of setting up business security and governance using a combination of Power Apps and SharePoint. The goal is to mimic role based access to users in Power Apps. Will do another video on SharePoint with the same perspective. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanjiv@prudentia...
Managing SharePoint documents/library with Power Apps and Automate
มุมมอง 7003 หลายเดือนก่อน
Greetings folks, Here's a walk through of managing documents in a sharepoint library using Power Apps and Automate. Power Apps gives us an elegant interface to upload, edit and delete documents securely into SharePoint. Power Automate enables the workflow behind the scenes. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at san...
Creating a 'Date Table' in Power BI / Power Query- a few ways depending on size of dataset
มุมมอง 1353 หลายเดือนก่อน
Greetings folks, creating date master tables are very important in any BI, and especially so in Power BI as it allows us to access the time intelligence functions. This inturn helps us creating measures with time dimensions such as YTD, YoY, CAGR etc. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanjiv@prudentia-consultin...
Using Python inside Excel to do text extraction/data transformation
มุมมอง 1193 หลายเดือนก่อน
Greetings folks, hope you and family are well. Here's a detailed walk through of using Python in MS Excel and the regular expressions library in python to extract text (employee ID in this case). Very helpful to do data transformations, especially for end users (finance, HR etc). I trust this helps you and if so, kindly do subscribe. If you need any consulting/training assistance, kindly do wri...
Improving personal health with Microsoft technology - Azure AI (Open AI, Doc intel) & Power Platform
มุมมอง 554 หลายเดือนก่อน
Greetings all, This is a special episode where we go over "improving personal health" and "grow younger" with MS tech. As summary: 1. We go over a few physicians who have guided me towards great heath. 2. The certified monitors, reports and metrics I use and track. 3. The MS tech platforms (Azure Open AI, Document intelligence, Python functions and Power Platform) I use to input data and manage...
Dynamic measures in Power BI visuals using parameters
มุมมอง 6464 หลายเดือนก่อน
Greetings folks, hope you and family are well. Here's a detailed walk through of creating parameters (as master tables in Power Query) and measures in Power BI to implement dynamic measures/views in Power BI visuals. Very helpful for executive reporting. I trust this helps you and if so, kindly do subscribe. If you need any consulting/training assistance, kindly do write to me at sanjiv@prudent...
Using Python in Power BI / Power Query to do text extraction
มุมมอง 2394 หลายเดือนก่อน
Greetings folks, hope you and family are well. Here's a detailed walk through of using Python inside of Power BI / Query to extract text (employee ID) in this case from a column of transactions. Works like charm. Kindly note about 2gb as the upper limit to doing this. Very helpful if you are a small and medium businesses. I trust this helps you and if so, kindly do subscribe. If you need any co...
Power Fx - Functions / Formulas in Power Apps
มุมมอง 4508 หลายเดือนก่อน
Greetings folks, Here's an introduction to functions / formulae in Power Apps. We look at these in the context of standalone functions without an parameters (such as User().Email) and in the context of controls with parameters (eg Filter). As such it also clarifies when to use a period (to access function properties in a hierarchical way) and when to use commas (as syntax for a function/formula...
Power Automate approvals with SharePoint attachments
มุมมอง 6969 หลายเดือนก่อน
Greetings folks, Here's a walk through of getting attachments in a SharePoint list item to an MS Teams approval card using Power Automate. This way approvers can view the item attached by downloading the file from Teams and verifying them prior to approving the line item. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanji...
Using Power BI bookmarks to create executive summaries:
มุมมอง 49011 หลายเดือนก่อน
Greetings folks, Creating executive summaries in Power BI is critical to focusing the attention of executives to the actions you'd like their assistance on and to get to this as quickly as possible. The idea is to peel the onion by using bookmarks in Power BI and get the "asks" asap. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to...
Creating "Master Date Tables" in Power BI using Power Query.
มุมมอง 698ปีที่แล้ว
Greetings folks, creating date master tables are very important in any BI, and especially so in Power BI as it allows us to access the time intelligence functions. This inturn helps us creating measures with time dimensions such as YTD, YoY, CAGR etc. I trust this helps you and if so, kindly do subscribe. If you need any consulting assistance, kindly do write to me at sanjiv@prudentia-consultin...
Chat GPT integrated with Microsoft Power Virtual Agent and Teams
มุมมอง 2.6Kปีที่แล้ว
Greetings, this video helps you get kickstarted with #microsoft Power Virtual Agent (an easy to design/use chatbot) and connect this to ChatGPT. This way we can query ChatGPT with what we want to learn on any device and literally anywhere. Further, you can send the results to Microsoft Teams so that your manager can review the results, potentially modify the output and approve the content for f...
Digital signatures in Power Apps - sign directly on a form or upload from your computer!
มุมมอง 5Kปีที่แล้ว
Greetings folks. Getting your digital signatures has been made pretty simple in Microsoft Power Apps. One can use the peninput control or upload images directly on a form control and approve information. This could be stored in a SharePoint list or Dataverse or other sources for further processing. Kind regards, Sanjiv
Power Apps - creating a simple Power Apps using Dataverse as the datasource.
มุมมอง 4382 ปีที่แล้ว
Greetings folks, Here's a detailed walk through of creating a simple Power Apps using Dataverse as the source. Kind regards, Sanjiv
Taxonomy charts in Power BI (de-composition tree)
มุมมอง 3572 ปีที่แล้ว
Taxonomy charts in Power BI (de-composition tree)
Unpivoting data in Power Query (normalizing data)
มุมมอง 5492 ปีที่แล้ว
Unpivoting data in Power Query (normalizing data)
Merge operations in Power Query (in Power BI or in Excel)
มุมมอง 2092 ปีที่แล้ว
Merge operations in Power Query (in Power BI or in Excel)
Selecting specific columns in Power Query (in Power BI or in Excel)
มุมมอง 13K2 ปีที่แล้ว
Selecting specific columns in Power Query (in Power BI or in Excel)
Appending data in Power Query (in either Power BI or in Excel)
มุมมอง 392 ปีที่แล้ว
Appending data in Power Query (in either Power BI or in Excel)
Text Extraction in Power Query (in Power BI or in Excel)
มุมมอง 1542 ปีที่แล้ว
Text Extraction in Power Query (in Power BI or in Excel)
Microsoft Viva Learning intro, setup and integration on Teams
มุมมอง 2K2 ปีที่แล้ว
Microsoft Viva Learning intro, setup and integration on Teams
Training/Workshop assessment made simple with Microsoft Cross Platforms (Forms, Power Automate & BI)
มุมมอง 1402 ปีที่แล้ว
Training/Workshop assessment made simple with Microsoft Cross Platforms (Forms, Power Automate & BI)
Power Apps with Barcodes auto generated in a SharePoint Online List
มุมมอง 5K2 ปีที่แล้ว
Power Apps with Barcodes auto generated in a SharePoint Online List
PowerApps Images - Using Azure Data Lake for real time storage & retrieval of images/3D files.
มุมมอง 1.8K2 ปีที่แล้ว
PowerApps Images - Using Azure Data Lake for real time storage & retrieval of images/3D files.
Excel Power Query & extracting strings from a column of text in Excel
มุมมอง 1663 ปีที่แล้ว
Excel Power Query & extracting strings from a column of text in Excel
Connected field service - from Microsoft Teams to Power Apps to WhatsApp!
มุมมอง 2K3 ปีที่แล้ว
Connected field service - from Microsoft Teams to Power Apps to WhatsApp!
Can I be able to apply the same logic if I want to break it down by month1, churn, reactivated customers and Month2,…
Can you please explain how to build a field service app in power apps canvas
Hi
Thanks for these instructions! I'm using a BrowseGallery view and the bar codes are showing up on the View and Edit forms on my web browser, but when I open the app on my phone (iOS) the barcode image does not display. Do you have any idea why and are you able to assist?
Here is the translation: "Excellent! If I want to click on the attachment in the Approval to view it directly without downloading, how can I do that?"
Thank you!! If I want to show data labels but remove the "-" sign. How can I achieve the same? please suggest
How can I customize the input of the adjusted barcode value?
Does it need premium license or without
Hi sanjiv . I saw your videos regarding data lake .so i have a requirement to solve & little to no knowledge about data Lake with powerapps.My requirement is : i need to connect azure data Lake tables with powerapps directly(example,similar scenarios like SharePoint tables connection with powerapps)so that i can do CRUD operation into those data lake tables.How can i achieve this ?? If you can guide.
Greetings Paromita. Thanks much for go through the video. I'd need to check this as I've not used tables in data lake (typically use Dataverse/SPOL). Let me take a look and will come back. Kindly give me until weekend as in the midst of workshops now. Kind regards...
Thank you for the video. How do I add the Signature to Form.valid, Displaymode. I want to make it a required column bfr submit.
Greetings and my pleasure Sir! One idea in this case is to make the field in the DB (SharePoint/DV etc) a required one. This way the form in PowerApps has a "star" that tells the user that this is a required field and does not let the user submit data. You can even show a message saying the signature is required. Trust this helps...kind regards
@@SanjivVenkatram Thank you. I have one more question sir. I have a flow that update all the fields to Template Populate Word document in Power Automate. And I'm unable to add the signature.
Greetings and most welcome. For that you'd need to store the signature in an image column. You then use get file content in power automate (after the trigger) and then pass this file content to your word document template (kindly add an image in your word template using the developer tab, the same way you've added text) and then create a new file. Should work without issues. Kindly let me know as to how you go. Kind regards...
Good sir can you help me in power apps Regards
Greetings Sir, thanks much for reaching out and for sure could try to assist. Would be kind to know what you are trying to do and as to what I could assist with. Kind regards...
Sir I want to learn power apps patch function especially lookup column and person group column please teach me regards
@tausifshaikh312 For sure bud and I am on travel now and will back on Tuesday. Would that be OK for you?
Yes sir I am ok
Your videos are awesome specially for me
I want to rename the "Total" column. How to achieve that? Pls help
You are best, I was trying to create calculated columns and measure to achieve my requirement but this was the best solution which worked for me. Great video ! (Can you help if there is any way to create stacked waterfall in bi?)
Greetings and very kind words my friend! For sure can and will create a video in the near future. Kind regards..
I can't seem to make this work with an excel backend, but maybe I'll try share-point lists.
Greetings and thanks for reaching out. Yes indeed, kindly use SharePoint. I'd not recommend using Excel as a datasource. Wish you the best! Kind regards, Sanjiv
Hi, If I use Power Automate in a Power Apps application where I will be sending a template PDF for signature to new users and, for example, I have 20,000 users, how much do I need to pay for the license? Do you have information on that? Thank you!
Greetings and thanks for asking. So licensing needs to be looking in the context of your firms enterprise agreement (EA) with MS. Kindly check with your IT procurement about this. Kind regards...
Hi there, great video. I am a subscriber. How did you get the picture of the signature into SharePoint?
Greetings and thanks for asking. So you would add a button & submit the form to SharePoint. As the list would have an image field, the signature image would be submitted to this field along with the rest of the datapoints. Trust this help! Kind regards...
Thank you
Dear Sir, Thank you for the video. I came across your video while looking for "how to find out whether a certain column in data table is used in Power BI reports". Appreciate if you could provide a brief answer. Thank You.
Greetings and thanks for asking. I believe Dax studio has a column usage feature that would be pertinent. Hope this helps. Kind regards..
This is very wonderful ,step by step to setup the pva with ChatGPT,but I want to modify someone step,when I trigger the pva to ChatGPT after asked to get the answer,when I want to continue to ask,have any tip don’t need trigger the ChatGPT ,just first need trigger to ChatGPT,after just like in ChatGPT website smoothly taking.
very less volume..difficult to hear
In this workflow you are presenting the response all at once which most of the case cause long delay on gpt answer whereas normally chat gpt is streaming answers word by word to avoid that user experience. Is there a way to stream in to PVA?
whats the function and formula on onselect property of "Approve" buttom
Greetings, thanks for reaching out and in this case the approve button does not do anything as the focus was on signatures. If you have to, I'd add a flow to the approve button and trigger an approval flow. You could then capture the approval and comments in SharerPoint/Dataverse and show this in a datatable in Power Apps. Trust this helps. Kind regards, Sanjiv
Thanks
Buen día, muchas gracias por la información, saludos desde Colombia. Good morning, thank you very much for the information, greetings from Colombia.
Greetings Frank, my sincere pleasure my friend. Glad it comes in handy and wishing you and family the very best! Kind regards...
Hi There..thank you for sharing..i tried however the test run failed with a message'"We could not parse the JSON body of your request' even before i could parse with the body content as a next step..can you help?
Greetings and most welcome. Kindly check tge completion uri in chatgpt. There is chance you might have the incorrect one. Kind regards...
Unable to view the barcode. Everything works well. No errors, nothing. But the barcode just isn't showing up.
Greetings and a bit odd. One idea is to add the link to a variable and refresh it when the item in database is clicked. Trust this helps. Kind regards...
@@SanjivVenkatram i have exatly same problem. I can see the barcode in Power app launched from Windows-client. But from mobile device, it wont display. Have you tried your app with mobile device and confirm this?
Awesome Sir, thank you so much!
This is great! thank you for sharing. How can i do this but with a predermined prompt?
Greetings and my pleasure! So you could load prompts into a SharePoint table and pick these up in powerautonate (get item) and surface them in PVA. Trust this helps, kind regards...
Is necessary to have a paid version of chatGPT?, I have this error in my flow: : { "message": "You exceeded your current quota, please check your plan and billing details.", "type": "insufficient_quota", "param": null, "code": "insufficient_quota" } } I have Power automate with Pro License
Greetings Yasir, hope all well bud. Thanks for trying and do you mean tye Power BI pro license? I think a Power Apps trial license should be good to run this workflow without an issues. And from what you describe it doesn't seem a ChatGPT issue and is a Power Automate license issue. Kind regards...
Very good, other channels sharing methods low eficient's. For exemple ins necessary utilization one auxiliar web site for generatod BR CODE
barcode is not displaying
Greetings folks, hope all well. If you folks are looking to adding digital signatures (an option of signing in directly or uploading a pic) here's a video that walks you though that. Kindly find the link here : th-cam.com/video/oDkYUO0eXc8/w-d-xo.html
Greetings folks, hope all well. If you folks are looking to adding digital signatures (an option of signing in directly or uploading a pic) here's a video that walks you though that. Kindly find the link here : th-cam.com/video/oDkYUO0eXc8/w-d-xo.html
Thank you for your detailed video. I am able to connect Power App to Data Lake. Do you have any idea on reading parquet file in datalake?
This was SUPER helpful! Worked perfectly! Thank you!
Thanks, Sanjiv, I was struggling in making customize waterfall chart, Now I made it
Hello, I have an inventory list on microsoft lists with a barcode column. The barcodes shows up as both image and number in Lists fine. I can click it and it previews in the browser as an image. However, I can't get that barcode image to show up in Power Apps. The image field in Power App allows me to set the Barcode column from Lists but it won't show the image. The barcodes were auto-generated using Lists. I am using Gallery in Power Apps. Any solutions? I'm trying to make printable labels from the inventory list using the Power App. Thanks
Is there a way to write (in real time) this Excel streaming data into a database for storage and access at a later time? Would love to see a video on that.
Greetings & thanks for asking. Frankly for anything database related, I'd use what is called as Azure IoT hub or Central and direct the stream to a DB. While this might seem daunting, it is actually relatively simple to do. Here's an example with a SharePoint table as a datasource : www.linkedin.com/posts/sanjiv-venkatram_aseansmsbizappsug-aseansmswomenintech-powerapps-activity-6777762733678043138-tOCA? . Will do a post on something like this soon. Kind regards, Sanjiv
Please make video about dataflow
Thanks Sanjiv. It's great help. But what if we have interim sub-totals? Thank you.
Greetings bud, hope all well & thanks for asking. I suppose you could add a variable to capture the sub-total and display that as well. Kind regards.
ᴘʀᴏᴍᴏsᴍ
Greetings and btw folks, as an aside, if you are interested in auto generating barcodes and developing an inventory mgmt app in Microsoft Power Apps (very very simple) , kindly see the link below: th-cam.com/video/Mzo4CWiGpoU/w-d-xo.html
Greetings folks, along above lines if you are interested in auto generating barcodes in SharePoint, viewing them in Power Apps and creating master tables of these (with respective images) kindly see below a link to a detailed video: th-cam.com/video/Mzo4CWiGpoU/w-d-xo.html
Hi i am planning to build a visitor registration app.. can you please guide me how i can generate barcode based on user sign in and use the same barcode to sign out user when the user scans again after the visit?
Greetings & thanks for asking Kiran. So one idea is to capture the login of the person as the user clicks a button called "login". Then you save the information to a SharePoint list and the barcode is auto generated. Now that the user ID and barcode are associated, you can use this do whatever else you plan to do. I'd use a separate table for this and call it a "transaction table". I trust this helps. Kind regards...
@@SanjivVenkatram do you have Facebook or somewhere that I can contact you? Incase I am stuck?
@@kns4945 bud just accepted your FB invite and we can connect over whatsapp. Kind regards
audio sucks!
Greetings & much appreciate the feedback and yes indeed! Will do better with other videos. Kind regards.
Hi, Thank you for the valuable video, I could connect excel to Arduino using "connect device" button but when I press start data , nothing happens. Do you have any idea why I can not start data? Arduino is working properly
Dear Nadia, greetings & hope you & family are well. Thanks much for the kind words. I assume you are using the Arduino Uno Wifi Rev2? Kindly confirm. If so, there I've faced an issue connecting this to the datastreamer. The Arduino Uno has no issues. Kind regards.
cool ! never knew!
Greetings Mr Imbert and thanks so much! Very kind of you!
How can I get the time stamp in the recorded data
Dear Kanchana, greetings, sorry for the delayed response and I havent been too active here. Kindly do send me a note on sanjiv.venkatram@hotmail.com and would be happy to assist. Kind regards.
Hi sir i need your help in doing a project.
Dear Vigneshwaran, greetings. My apologies and I havent been too active here. Kindly let me know if you still are looking for ideas and would be happy to share what I know. Kind regards.
@@SanjivVenkatram Thank you sir.. i did my project...Your video helped me a lot....
Hi sir can you make a video on gprs connectivity with gsm for Arduino
Very helpfull to me thanks. Can u tell me please how to change the range from 0-127 to 0-255?