Видео

API - SharePoint - GetColumns Add Step Send an HTTP request _api/web/lists/getByTitle('10000 Sales Records')/items Initialize Variable Add Compose outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'][0] outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'][0]['Title'] outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'][0]['field_1']

Length of items using REST Add Step Send an HTTP request _api/web/lists/getByTitle('10000 Sales Records')/items Initialize Variable length( outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'])

SharePoint Large List - API Add Step Send an HTTP request to SharePoint Site Address - atcmumbai.sharepoint.com/sites/SP1000Videos method - GET Uri - _api/web/lists/getByTitle('10000 Sales Records') Headers content-type application/json;odata=nometadata run it Get JSON It will also be 100 rows

LargeList GetItems Create Flow Instant Cloud Flow Get Items Select the list 10000 Sales Records.csv Run it Download Output The last id will be 100 Put a compose expression length(outputs('Get_items')?['body/value'])

SharePoint Large List Go to excelbianalytics.com/ In Search text box type sample sales csv click Read More click 10000 Sales Records Download it extract it it will have "10000 Sales Records.csv" Go to sharepoint New List from csv select the file "10000 Sales Records.csv" Next Create

DocumentLibrary $expand=File Create DocumentLibrary TestLibrary1 Create Flow Add step Send an HTTP request to SharePoint Site Address - select custom then select variable varSiteAddress Method - GET URI - _api/web/lists/getByTitle('TestLibrary1')/items?$expand=File&$select=*,File/Name,File/ServerRelativeUrl Headers Accept application/json;odata=nometadata

Update SharePoint item by REST Site - atcmumbai.sharepoint.com/sites/SP1000Videos List - TestLibrary2 Title Create Flow Instant Cloud Flow Add Step Send an HTTP request to SharePoint Site Address - atcmumbai.sharepoint.com/sites/SP1000Videos method - POST Uri - _api/web/lists/getByTitle('TestLibrary2')/items(1) Headers content-type application/json;odata=nometadata IF-MATCH * X-HTTP-METHOD MERGE Body { "Title":"Test" }

Awesome work!!! Better than Copilot!

Excepcional! Material extraordinário! Continue com o excelente trabalho que está fazendo.

Very well Explained. Thank you.

Paging in sharepoint For Site atcmumbai.sharepoint.com/sites/SP1000Videos List LargeList Create flow Flow_paging New Step SharePoint Getitems select site and list click ... click settings pagination on threshold 100 click done Save Test click download put in json formatter last id will be 100

Can you help? I have a list and I want the list to to provide a serial number for each item and when an item is deleted I want to list to reorganize so I never have gaps in my serial numbers.

I like it. But Could you make flow for get data from excel file when upload file excel from power apps after that data in excel file will save on dataveres or sharepoint list?

Hope you make flow about get data from excel on power apps to sharepoint or dataverse

Flow to Backup SharePoint List Add Step SharePoint Get items Site Address - atcmumbai.sharepoint.com List Name - Country Add step Create CSV table From - value from Get items Compose Expresion formatDateTime(utcnow(), 'yyyy_MM_dd_HHmmss') Add Step Onedive Create file Select folder SharePointBackup FileName - Country_ then select Outputs of compose then .csv File Content Output of CSV table

JSON Nested Flow_Nested varJSON - object { "Users" : [ { "FirstName" : "Intekhab", "LastName" : "Shaikh" }, { "FirstName" : "Nikhil", "LastName" : "Dixit" } ] , "Sales" : [ { "FirstName" : "Intekhab", "Sales" : "100" }, { "FirstName" : "Nikhil", "Sales" : "200" } ], "x" : "Hi from Intekhab" } Compose concat(variables('varJSON')['Sales'],'') This will bring [{"FirstName":"Intekhab","Sales":"100"},{"FirstName":"Nikhil","Sales":"200"}] concat(variables('varJSON')['Sales'][0],'') This will bring {"FirstName":"Intekhab","Sales":"100"} concat(variables('varJSON')['x'],'') this will bring Hi from Intekhab

REST call with expand create list City Column Title CityName create list Sales column Title Amount SalesCity Power Automate Flow_ExpandLookup SharePoint _api/web/lists/GetByTitle('Sales')/items?$select=Id,Title,SalesCity/CityName&$expand=SalesCity The Format of expand is url/_api/web/lists/GetByTitle('ListA')/items?$select=Id,Title,LookupFromListB/Title&$expand=LookupFromListB

Create List Product Title ProductName UserProducts Title TheProducts (Lookup in Product multi value) Workingatcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items atcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items?$select=Title atcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items?$select=Title&$filter=Title eq 'Intekhab' atcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items?$select=Title&$filter=TheProducts eq '1' atcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items?$select=Title&$filter=TheProducts/Id eq '1' atcmumbai.sharepoint.com/sites/TheUniverse/_api/web/lists/getByTitle('UserProducts')/items?$select=Title&$filter=TheProducts/ProductName eq 'Car'

For Last Step Step Name - Set variable - varReturnJSON Name - varReturnJSON Value - concat('[', outputs('Compose__-Replace_List3'),',',outputs('Compose-__Replace_List4'),']')

JOIN SharePoint List using REST Add Initialize Variable Step Name - Initialize variable - varJSONList3 Name - varJSONList3 Type - String Add Initialize Variable Step Name - Initialize variable - varJSONList4 Name - varJSONList4 Type - String Add Initialize Variable Step Name - Initialize variable - varReturnJSON Name - varReturnJSON Type - String Add Step Scope Name - Scope - list3 Inside it add Step Send an HTTP request to SharePoint step Name - Send an HTTP request to SharePoint - list3 Site Address atcmumbai.sharepoint.com/sites/SP1000Videos Method - GET uri - _api/web/lists/getByTitle('List3')/items?$select=Title,FirstName Headers Accept application/json;odata=nometadata Add Step Set variable Step Name - Set variable - varJSONList3 Name - varJSONList3 Value - Body from step Send an HTTP request to SharePoint - list3 Add Step Compose Step Name - Compose - Replace List3 Expression replace( replace(variables('varJSONList3'), '{"value":[',''), ']}' , '') Copy Scope3 to Clipboard Add Step Paste From Clipboard Scope3 Name it Scope - List4 Rename Send an HTTP request to SharePoint - list3 2 to Send an HTTP request to SharePoint - list4 Change Uri to _api/web/lists/getByTitle('List4')/items?$select=Title,FirstName rename step Set variable - varJSONList3 2 to Set variable - varJSONList4 Name - varJSoNlist4 Value - body of Send an HTTP request to SharePoint - list4 Rename step Compose - Replace List3 2 to Compose - Replace List4 Value replace( replace(variables('varJSONList4'), '{"value":[',''), ']}' , '') Add Step set Variable Step Name - Set variable - varReturnJSON Name - varReturnJSON Value - concat('[', outputs('Compose__-Replace_List3'),',',outputs('Compose-__Replace_List4'),']')

SharePoint HTTP top 100 Power automate new Flow Flow_Top100 Add step Send an HTTP request to SharePoint Site Address - atcmumbai.sharepoint.com/sites/SP1000Videos Method - GET Get Field Name from List Settings field_2 uri _api/web/lists/getByTitle('LargeList')/items?$select=Title,field_2&$top=100 Headers Accept application/json;odata=nometadata

SharePoint HTTP In Browser atcmumbai.sharepoint.com/sites/SP1000Videos/_api/web/lists/getByTitle('MyList') Power automate new Flow Flow_SharepointHTTP1 Add step Send an HTTP request to SharePoint Site Address - atcmumbai.sharepoint.com/sites/SP1000Videos Method - GET uri _api/web/lists/getByTitle('MyList')/items?$select=Title,FirstName Headers Accept application/json;odata=nometadata

Union of Array Create Instant Cloud Flow Flow_UnionArray Add Step Initialize Variable varArray1 [1,2,3] Add Step Initialize Variable varArray2 [4,5,6] Add Step Initialize variable varArray3 expression type union( then from Dyanmic Content varArray1 then type , then from Dyanmic Content varArray2 then type ) union(variables('varArray1'),variables('varArray2'))

Join SharePoint Lists Data Create list List3 Title FirstName Enter Data 1 intekhab 2 Nikhil List4 Title FirstName Enter Data 3 Anne 4 Mike Create Flow Instance Cloud flow Flow_CombineLists1 Add Step Initialize variable varReturnJSON string Add Step Initialize variable varFinalJSON string Add Step Initialize variable varItemJSON string Add step sharepoint Get items - List3 select communication Site list3 Add step Apply to each - List3 value from Get items - List3 Set variable - varitemjSoN list3 varItemJSON { "List" : "List3", "Title" : "@{items('Apply_to_each_-_List3')?['Title']}", "FirstName" : "@{items('Apply_to_each_-_List3')?['FirstName']}" } For right hand site pick Title form Get items - List3 Add step compose - list3 concat( variables('varFinalJSON'),' , ' , variables('varItemJSON')) set variable varFinalJSON select outputs from Compose - list3 Copy Get items - List3 to clip board Add step paste from clip board rename Get items - List4 change list name to List4 Copy step apply to each - List3 and paste it and name to apply to each - List4 value - select from Get items - List4 rename to Set variable - varItemJSON list4 Change Title and FirstNaame to pick from Get items - List4 Set variable - list4 change to Outputs from Compose - list4 Set variable varReturnJSON concat( '[' , substring(variables('varFinalJSON'), 2, sub(length(variables('varFinalJSON')),2) ), ']')

Get SharePoint Data using Postman Create Flow Instant cloud flow Flow_GetSharePointUsingHttp Who can trigger flow - Anyone Add step Get items Communication Site Site Address atcmumbai.sharepoint.com List - ForPowerAutomate Run Once get JSON Put in jsonformattor.org get from { {}, {} } only Paste JSON in Payload Add step Select From Body of step ParseJSON Map Title select Title of ParseJSON FirstName select FirstName of ParseJSON Add step Response Body - output of select Save flow get url From Postman Authentication - None POST run it

SharePoint Data selected columns This is continuation of previous video Run the Flow Once and get the JSON Add Step Parse JSON Run Once Input of parseJSON Paste JSON in Payload Ad step Select From Body of step ParseJSON Map Title select Title of ParseJSON FirstName select FirstName of ParseJSON

Get SharePoint Data Go To SharePoint atcmumbai.sharepoint.com New List ForPowerAutomate Title FirstName Add Data 1 Intekhab 2 Nikhil Power Automate new flow Instant cloud Flow Manuall Trigger a flow Flow_GetSharepointData Add Step SharePoint Getitems CommunicationSite

You are very funny

Thanks for the Video! How to use Federated Identity credentials in place of secrets?

Thanks for the video. I really like your style, with other videos of this type I usually fall asleep, here I had fun and still learned what I needed to :)

Out of all the videos i watch to show me how yours are the simplest to follow along with keep up the great work

HTTP Action with Dataverse -Create flow Create flow instant Cloud flow HTTP Method - GET URI - orgb8e6f00c.api.crm8.dynamics.com/api/data/v9.2/cr76a_employeeses Authentication - Active Directory OAuth Tenant - d9819c96-7d31-4664-aabd-a206e8f07e0d Audience - orgb8e6f00c.api.crm8.dynamics.com Client ID - dae3c8b7-ba3b-4d10-9133-0ff70f58fd89 Credential Type - Secret Secret - omH8Q~_bs82n-CXAcqZxQAlUmaWLNT6OR3EpFcfN Run

HTTP Action with Dataverse - Create App User Admin Center Environments select ATC From top click Settings click Users and permissions click Application User New App User click add an app select DataverseAppRegisteration select Business Unit Security Roles

HTTP Action with Dataverse - App Registeration- Register App in Azure DataverseAppRegisteration Client ID - dae3c8b7-ba3b-4d10-9133-0ff70f58fd89 Tenant ID - d9819c96-7d31-4664-aabd-a206e8f07e0d Secret - omH8Q~_bs82n-CXAcqZxQAlUmaWLNT6OR3EpFcfN orgb8e6f00c.api.crm8.dynamics.com/api/data/v9.2

Index array using Skip and First Create flow Flow_SkipInArray3 Add Step Compose Inputs expression put split('1,2,3', ',') Put Compose skip(outputs('Compose_-_Split_And_Create_The_Array'),1) This will bring [2,3] Now add compose first(outputs('Compose_-_Skip')) In Short first(skip(split('1,2,3', ','),1 )) This will bring second element first(skip(split('1,2,3', ','),2 )) This will bring third element

Add Step RegEx Check whether text matches the specified pattern ^(?:(?:\+?1\s*(?:[.-]\s*)?)?(?:\(\s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])\s*\)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\s*(?:[.-]\s*)?)?([2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})\s*(?:[.-]\s*)?([0-9]{4})(?:\s*(?:#|x\.?|ext\.?|extension)\s*(\d+))?$

is it mandatory to create a reminder with a sharepoint ?

Relate Tables - flow to Update related data Take an ID from Table-Master2 3d1ff481-56c0-ee11-9078-000d3af2e28f Create Flow Flow_UpdateMasterInslave Put list rows Table_Master2 List rows Select Table_master2 Run it Show raw output Look For @odata.editLink You will see cr76a_table_master2s(7b3541b0-8438-ef11-a316-000d3af2bdc5) Get the name cr76a_table_master2s Update a row Show Advanced Option For Table_Master2 cr76a_table_master2s(3d1ff481-56c0-ee11-9078-000d3af2e28f)

Flow Azure key vault - Create the flow make.powerautomate.com From left click ... More select connections New connection search Azure Key Vault Kay vault name - IntekhabFirstKey click create New Instant cloud flow Add Step Azure Key Vault select Get Secret chose IntekhabSecret1 Save Run

Flow Azure key vault - Role Assignment and Create Secret Go To key Vault click Access control from Left add role assignment select key Vault administrator click Next click Select members add aalum@atcmumbai.onmicrosoft.com Review + assign from left click secret click Generate/import Name - IntekhabSecret Secret value - 123456789 click Create

Flow Azure key vault - Create key Vault portal.azure.com search key vault create select resource group Key vault name - IntekhabFirstKey Next Next Next Next Create

Thanks a lot very clean and nice explanation 🎉

Flow to write to Azure SQL - Create flow create flow Instant cloud flow Flow_WriteToAzureSQL add step Insert row(V2) server - dbserverpowerautomate.database.windows.net for database name click > arrow Add the Firewall rule DataBase - DBPowerAutomate Table name - MyTable1

Flow to write to Azure SQL - Create table Go to Azure dbserverpowerautomate Public access Selected networks click Add your client ipV4 address Install SSMS (Sql Server management Studio) Start SSMS server - dbserverpowerautomate.database.windows.net DataBase - DBPowerAutomate In Connection Properties Connect to database - DBPowerAutomate Authentication - SQL Server Authentication login - shaikh_intekhab Password - same with 99 Create table create table MyTable1( id int, firstname varchar(20) ) insert into MyTable1 values(10,'Aalum') insert into MyTable1 (id, firstnamename) values(11,'khan')

Flow to write to Azure SQL - Create Azure Database Go To Azure portal.azure.com Create ResourceGroup ResourcePowerAutomate Create SQL Server Databae Database DBPowerAutomate Create SQL Database Server dbserverpowerautomate Use both SQL and Microsoft Entra authentication Set Microsoft Entra admin aalum@atcmumbai.onmicrosoft.com server admin login login - shaikh_intekhab Password - same with 99

Thanks, it was useful.

Please add more video for this playlist it's good

Please continue your series, it is very helpful

Explore the related table data The table name is cr76a_tablemeeting7_systemuser Primary Key - cr76a_tablemeeting7_systemuserid Foreign Key - cr76a_tablemeeting7id Foreign Key - systemuserid Run App_TableMeeting7 Get id of an item 4de5ba25-65f5-ee11-a1fe-000d3a0a5000 Flow Instant Cloud Flow Flow_GetUsersData1 List Rows Table name - cr76a_tablemeeting7_systemuserset *** yes there is set at end In filter rows cr76a_tablemeeting7id eq '4de5ba25-65f5-ee11-a1fe-000d3a0a5000' Initialize Variable UserID string Initialize Variable varEmail string Set Variable select output from previous steps value Set variable Name - UserID Value - systemuserid Get Row by ID Table - Users Row ID - UserID Set variable varEmail Select Primary Email

Can select PeopleColumn/Email?