Tech Space
Tech Space
  • Видео 120
  • Просмотров 134 115
PowerFx Query to Patch Record in Dataverse Table
Power Apps formula for a scenario involving project management. This formula appears to be for a button or action that checks certain conditions before allowing a project to be canceled.
Here's a breakdown of the formula:
1. The formula starts with an If statement that checks if certain fields ('Project Date', Reason, and Sponsor) are blank in the selected project item.
2. If any of these fields are blank, it triggers a notification using the Notify function, indicating which fields must contain values before canceling a project.
3. This notification is a warning type and lasts for 5000 milliseconds (5 seconds).
4. If all required fields have values, the formula proceeds to check if the proje...
Просмотров: 66

Видео

UiPath - How to get Excel Workbook Sheet names from Excel?
Просмотров 1,8 тыс.3 года назад
Steps to get Worksheet Names from Excel Use ‘Excel Application Scope’ to Open Excel Use ‘Get Workbook Sheets’ to Read Sheet Names from the Excel File Activities : Search in Activities section as “Excel Application Scope "or Under App Integration - Excel - Excel Application Scope action will be identified Link for Power Automate : ruclips.net/video/Z8ZF-uu8gyg/видео.html
Power Automate - How to get Excel Workbook Sheet names?
Просмотров 3,1 тыс.3 года назад
Steps to write data to Excel Worksheet: Launch Excel Use Action ‘Get all Excel Worksheets’ Excel Sheet Will stored on the variable produced Close Excel Action Required: Launch Excel, Get all Excel worksheets , Close Excel Link for Blue Prism same get worksheet Action: ruclips.net/video/Z8ZF-uu8gyg/видео.html
Blue Prism-How to get Excel Workbook Sheet names
Просмотров 5643 года назад
How to get workbook sheet names from Excel? Steps to write Data to Excel: Action: Create Instance Action : Open Workbook Action: Get Work sheet Names Action :Close All Instance VBO: Visual Business Object Default ‘MS Excel VBO’ is required Link for BP release : drive.google.com/file/d/1_HGxXt5SPB3wvljhAOpvl49acQiaFA03/view?usp=sharing
UiPath Vs Power Automate Vs Bluepirsm (Data Extraction from web)
Просмотров 2,7 тыс.3 года назад
Web scrapping Using Uipath , Power Automate and Blue Prism. With this video you will be able to recreate same use case using all the 3 tools .
UiPath - Extract Data from Web multiple page
Просмотров 11 тыс.3 года назад
Steps to Extract web data from Multiple pages Use ‘Open Browser’ to launch the browser and Navigate to required URL Use ‘Data Scrapping’ to Extract Table from Multiple Pages Store the Data Table as Output Use ‘Excel Application Scope’ to Open Excel Use ‘Write Range Activity ’ to Write on to the excel output file Activities : Search in Activities section as Open Browser or Under UIAutomation - B...
Power Automate - How to Write Data from Web Scrapping to Excel?
Просмотров 2,9 тыс.3 года назад
How to Write Table to Excel Worksheet? Steps to write data to Excel Worksheet: Launch Excel Use Action ‘Write to Excel Worksheet’ Use ‘Save Excel’ Action to save the file on desired location Close Excel Action Required: Launch Excel, Write to Excel worksheet , Close Excel
Power Automate - How to Extract Web Data from Multiple Pages?
Просмотров 16 тыс.3 года назад
How to do Web Scrapping with Multiple Pages? Steps to do Web Scrapping: Launch browser (IE,Chrome,Edge etc..) Use Action ‘Extract Data from Webpage’ Use Advance Option for Pager(Navigate to Next pages) Action Required: Launch Browser , Extract Data from Webpage
Blue Prism- How to Write Collection to Excel?
Просмотров 7 тыс.3 года назад
Steps to write Data to Excel: Action: Create Instance Action : Create Workbook Action: Create worksheet (Specify the path) Action: Write Collection Action: Save Current Workbook As Close All Instance VBO: Visual Business Object Default ‘MS Excel VBO’ is required Link to Download BP Release: drive.google.com/file/d/1LTbf5dzrgQnZ6MMmWCs4p2TGHND4p06B/view?usp=sharing
RPA Space - Channel Introduction
Просмотров 3723 года назад
A quick introduction about our channel and its content. It includes Tutorials for Blue Prism, UiPath and Power Automate .
Power Automate - How to Extract data from Excel?
Просмотров 10 тыс.3 года назад
Steps to Extract Data from Excel: 1.Launch Excel 2.Read Data from Excel Worksheet 3.Add Storage variable , it will be table(Excel Data - Default Variable) 4.Close Excel Action Required: Launch Excel , Read Data from Excel Worksheet ,Close Excel
Blue Prism- How to Extract Data from Excel?
Просмотров 3,3 тыс.3 года назад
How to Extract Data from Excel? What are the different options to Extract data using Blue prism? Steps to Extract Data from Excel: Action: Create Instance Action : Open Workbook (Specify the path) Action: Get Worksheet as Collection Add Storage variable , it will be Collection Close Instance VBO: Visual Business Object Default ‘MS Excel VBO’ is required Path to Download process : drive.google.c...
UiPath - Different Options to Read Excel Data
Просмотров 9213 года назад
What are the different Options to Extract Excel Data using UiPath? Steps to Extract Data from Excel: Open Excel Application Scope Add Read Range Specify if Range is Required else make it empty Add Storage variable , it will be data table Close Workbook Activities Navigation Use search pane with “Excel Application Scope” as name or Activities-App Integration-Excel-Table-Excel Application Scope L...
How to Use 'Set Variable' Action in Power Automate?
Просмотров 2753 года назад
What is the ‘Set variable, Action? Set the value of a new or existing variable, create a new variable or overwrite a previously created variable Use : If you want to store of value , variable will be useful(Type can be selected based on the input) Activities Navigation Use Action search pane with “Set variable” as name or Action-Variable-Set Variable Ref: docs.microsoft.com/en-us/power-automate...
Power Automate and Uipath Get Special Folder
Просмотров 1943 года назад
Power Automate Action Name: Get special folder Navigation: Go to Action Pane and Search for Folder and Choose Get special folder or Action-Folder-Get special folder Drag and Drop into workspace Purpose: Retrieve the path of a Windows' special folder (such as Desktop, My Pictures , etc) Irrespective of the System(Machine name) Parameters: Special Folder Name Special Folder Path Specialfolderpath...
Microsoft - Power Automate FAQ
Просмотров 663 года назад
Microsoft - Power Automate FAQ
What is Power Automate?
Просмотров 583 года назад
What is Power Automate?
RPA Intro - Power Automate
Просмотров 1313 года назад
RPA Intro - Power Automate
How to Use Repeat Number of Times and Retry in UiPath
Просмотров 1,5 тыс.3 года назад
How to Use Repeat Number of Times and Retry in UiPath
How to Use Pick Branch and Pick Activity UiPath?
Просмотров 3 тыс.3 года назад
How to Use Pick Branch and Pick Activity UiPath?
What is RPA Space all about ? - A Channel Brief note..
Просмотров 683 года назад
What is RPA Space all about ? - A Channel Brief note..
How to use For Each Activity?
Просмотров 543 года назад
How to use For Each Activity?
How to Filter Outlook Mail Message Using Uipath?
Просмотров 7313 года назад
How to Filter Outlook Mail Message Using Uipath?
UiPath Ai Fabric-Customer Feedback Analysis - Practical Session
Просмотров 2793 года назад
UiPath Ai Fabric-Customer Feedback Analysis - Practical Session
UiPath -AI Fabric - Customer Feedback Analysis
Просмотров 1333 года назад
UiPath -AI Fabric - Customer Feedback Analysis
UiPath - Activities: Filter Data Table
Просмотров 2,9 тыс.3 года назад
UiPath - Activities: Filter Data Table
UiPath Activities: Clear Data Table
Просмотров 4403 года назад
UiPath Activities: Clear Data Table
Activities Add Data Row
Просмотров 453 года назад
Activities Add Data Row
UiPath Activities: Add Data Column
Просмотров 4283 года назад
UiPath Activities: Add Data Column
LinkedIn Automation - Assistance Bot
Просмотров 1043 года назад
LinkedIn Automation - Assistance Bot

Комментарии

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

    This appears to use the Desktop version. What about the Cloud version?

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

    thank you sir. i have learned

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

    Thank you Sir

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

    Many thanks!

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

    On the last page, it keeps clicking on ext button. Why is that?

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

    In application modular when I tried to launch the application after launch the application again launch button is visible for me and I'm not able to highlight the elements. Please assist here

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

    What does UI mode do, come on

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

      bpdocs.blueprism.com/bp-6-7/en-us/uia-navigator-form.html?TocPath=Process%20studio%7CFlowcharts%7C_____7#:~:text=The%20UI%20Automation%20model%20allows,Control'%20and%20'Content'.

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

    if the webpage updated is that the details in excel file can updated?

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

    Thank you. Very valuable video!

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

    Very Useful .Thank you

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

    if we use "All Available" option why it cannot stop to click the next page?

  • @MohamedAhmed-wz9ws
    @MohamedAhmed-wz9ws Год назад

    Hey RPA Space. Thanks for this great video. I had a challenge where data extraction stops at a certain page let's say at page 34 and it'll not scrap anything beyond this page even though I can see that it's going next pages one by one until the last page I set it in the first place. Any cause and remedy for this. Thanks once again

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

      Also had this issue!!! Did you find a fix atall?

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

      me only 27 out of 1000... please help

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

    Nice video. However, why can't we get headers in excel when we extract data using Power Automate. Do we have a solution for that?

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

    How to save data different sheet?

  • @seshkamal7745
    @seshkamal7745 2 года назад

    is there any way i can read the information from excel and convert that information into pdf and send it to my email

  • @Sweeeey
    @Sweeeey 2 года назад

    Hey, I have two CSV-files that I want to merge. They have the same headers but how do I merge them in to a one collection? Thanks Best regards

  • @민호진-o5k
    @민호진-o5k 2 года назад

    you need to clarify the content

  • @GauravBhargava-RPA
    @GauravBhargava-RPA 2 года назад

    Thanks for sharing this video with clear explanation

  • @aunekhan3794
    @aunekhan3794 2 года назад

    very useful thanks

  • @Max-ci9cv
    @Max-ci9cv 2 года назад

    for some reason mine goes to second page and it just stops extracting data how can i make it extract from all pages

  • @ram9208
    @ram9208 2 года назад

    Hey/ Thanks for the video. I am trying to extract flipkart reviews, Profile name and review contents. Thanks to your video its working great. However in products where reviews are in 100+ pages, the extraction stops when the next page does not load properly or you need to refresh the page to page it load. I understand its a website related issue but can we do anything about it? Like waiting or the page to load or reload the page. Or create an excel of all the page links and then asking the robot to extract from those pages only. Pls let me know

  • @martinsimbron5118
    @martinsimbron5118 2 года назад

    Excellent!!! Great ! Magnificent !!!

  • @yashobantadash6670
    @yashobantadash6670 2 года назад

    niceee

  • @akshaypawar6224
    @akshaypawar6224 2 года назад

    Good efforts

  • @samruddhideshpande1245
    @samruddhideshpande1245 2 года назад

    the datatable at the end merges all the columns into 1 instead of 2

  • @sirisoj
    @sirisoj 2 года назад

    Beautiful! Thanks for sharing!

  • @YaGampang
    @YaGampang 2 года назад

    What if i don't see the "Next" page button, but the site has pagination, how i can navigate or "set as a pager"? thanks

    • @rrawat9026
      @rrawat9026 2 года назад

      Hi,did u get solution for this..I hv also facing same issue

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

      Buddy even I am looking out for the same solution

  • @vikaskshirsagar9599
    @vikaskshirsagar9599 2 года назад

    How to design workflow if i want to extract 5 data from 1st page, 10 data from 2nd page, all data from 3 page. Only 3 pages data

  • @ursnandal
    @ursnandal 2 года назад

    How to get and copy website URL Into Excel of different tabs already opened a chrome browser?

  • @neelimajangala2724
    @neelimajangala2724 2 года назад

    In the application modeller I have application wizard but there is no identify to give attributes

  • @irfanshaik2205
    @irfanshaik2205 2 года назад

    How can I Approach Sir I need to learn course can you please send me your mail id

  • @irfanshaik2205
    @irfanshaik2205 2 года назад

    Thank you so much explained very well ❤

  • @chakkravarthipr7026
    @chakkravarthipr7026 2 года назад

    It was a good explanation, suppose if I want to fetch and write data again will it overwrite the data? If we do not want to overwrite the data say we have to start writing from cell A11 or get the last row and write it from the next row? how can we achieve it?

  • @RajeshAttada007
    @RajeshAttada007 2 года назад

    This video content helped me today. Thank you so much for the content on LINQ queries

  • @mahathmasadineni2884
    @mahathmasadineni2884 2 года назад

    Sir when I use extract data from web page and extract entire table the table headers are not coming sir.. and the page selector is going to last page and sticking there

  • @maheshy9558
    @maheshy9558 2 года назад

    Hi How can we Export Report Data..to Excel Sheet(like How many processes are run in control room ,how many are completed or How many are terminated)

  • @Ashoks1985
    @Ashoks1985 2 года назад

    thanks,1st time able to scrap the all pages data but when i run 2nd time i got only 2nd page result instead of should be both pages

  • @hariharans1657
    @hariharans1657 2 года назад

    How to use filter data table in RE framework . It's task given for me

  • @nagarajurapa6271
    @nagarajurapa6271 2 года назад

    What is the practical use of startup parameter in real time/? Can u suggest some scenario

  • @nupurkumari6434
    @nupurkumari6434 2 года назад

    hi how can i connect with u to learn RPA// please suggest need help in learning UI path

  • @kalaivanikalaiselvan9830
    @kalaivanikalaiselvan9830 2 года назад

    Could you put videos in topics split,substring and index of

  • @kalaivanikalaiselvan9830
    @kalaivanikalaiselvan9830 2 года назад

    Excellent explanation Thank you

  • @vasanthkumar-nv8yy
    @vasanthkumar-nv8yy 2 года назад

    Hi Sir what is default max length for max length property and if i want any number of string in Cell what is max length i have to set

    • @RpaSpace
      @RpaSpace 2 года назад

      Not exactly sure , when it comes to length its 256

  • @mayankgtnd
    @mayankgtnd 2 года назад

    Is there a way to automate this report?

  • @priyambadamadhual1784
    @priyambadamadhual1784 3 года назад

    I am trying to extract data from amazon. But when I put url it showing invalid variable. Can you please suggest me how to resolve this

    • @RpaSpace
      @RpaSpace 3 года назад

      What was the exact error?

  • @bhartisharma3686
    @bhartisharma3686 3 года назад

    Can you please tell me how to extract specific text from pdf using Power Automate?

    • @RpaSpace
      @RpaSpace 3 года назад

      You have to extract entire content from PDF and use regex to split the required text

  • @radhakrishnagandla2687
    @radhakrishnagandla2687 3 года назад

    im unable to see "Excel application scope" it is showing "use excel file" can u please explain it

    • @RpaSpace
      @RpaSpace 3 года назад

      Just search as Excel in Activities list pane , you can be able to find

    • @diwagarsoundar9379
      @diwagarsoundar9379 2 года назад

      Hi bro 👋 ,I'm Diwagar this demonstration is very interesting. Thanks for this.

  • @duyNguyen-fn9rs
    @duyNguyen-fn9rs 3 года назад

    Can we input many columns?

  • @gopichandu5796
    @gopichandu5796 3 года назад

    Please explain sir, blue prism development tutorials and also projects please sir

    • @RpaSpace
      @RpaSpace 3 года назад

      Already have 85+ videos added to the channel , please refer the same. Please find the Play list Links 1. ruclips.net/p/PLVysazi4apfBDeaEdzTTaHuiGWR_6_l8T 2. ruclips.net/p/PLVysazi4apfDOl0b14p7hFQP1FeMPLyuW 3. ruclips.net/p/PLVysazi4apfD2xyTYdmWSICivzIbyM2Nz 4. ruclips.net/p/PLVysazi4apfD4AXIi2fA_VrqGVfSquc-_ 5. ruclips.net/p/PLVysazi4apfDsarvc8yRDLL5WzSMznawQ 6. ruclips.net/p/PLVysazi4apfAqaQCR1sP68HJ2UKXYMkGu 7. ruclips.net/p/PLVysazi4apfAxxBTiI1yZclp5cHrGTUbE 8. ruclips.net/p/PLVysazi4apfBr6zmt2xTboeoPDkx2JoNJ

  • @muralimohan7005
    @muralimohan7005 3 года назад

    How to filter data table with yesterday datewise