Power Automate with C1FlexGrid

Power Automate with C1FlexGrid

Posted by: gaiewskid on 28 September 2023, 2:46 am EST

• 

  gaiewskid

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2023, 2:46 am EST - Updated 28 September 2023, 2:51 am EST

  I am using Microsoft Power Automate for user interface testing a program that uses a C1FlexGrid. When using the program, clicking in the upper left hand cell selects the entire grid. This cell doesn’t seem to be defined. “Column 0” but many cells in the grid are Column 0.

  I’m curious if anyone has used Power Automate and could lend any advice.

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 28 September 2023, 10:44 pm EST

  Hi,

  Thank you for the details. We tested the C1FlexGrid using MS Power Automate and noticed that it is not possible to select the Cell[0,0] when selecting a “UI element to click” in the C1Flexgrid. Please see the attached video showing the behavior (Cell not Selected.zip). Is this the issue that you are talking about?

  If yes, we have already shared the observations with the development team for further investigation. If not, we request you please provide a video showing the exact steps you follow to reproduce the issue. This will greatly help us investigate the behavior further and assist you in the best way possible.

  [Internal Tracking ID: C1WIN-31137]

  Best Regards,
  
  Kartik

• 

  gaiewskid

  • Post Options:
  • Link
    Copy

  Posted 28 September 2023, 11:40 pm EST

  yes. That is exactly what I observed. Specifically, data items across the top row. It appears that Power Automate and the WinAppDriverUIRecorder can only identify cell columns and not necessarily rows.

  In code, then (VB), how would I select/highlight all cells in a FlexGrid so that I can apply Me.FlexGrid1.Copy()?

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 29 September 2023, 12:30 am EST

  Hi,

  Thank you for confirming the behavior of the C1FlexGrid with Power Automate on your end. We will let you know the updates from the development team soon.

  To select all the C1FlexGrid cells through code, you can use the C1FlexGrid.Select method as follows:

  FlexGrid1.Select(FlexGrid1.Rows.Fixed, FlexGrid1.Cols.Fixed, FlexGrid1.Rows.Count - 1, FlexGrid1.Cols.Count - 1)

  Best Regards,
  
  Kartik

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 7 December 2023, 5:18 pm EST

  Hi,

  We are glad to let you know that this issue has been fixed in the latest 2023v3(631) release. You can update using ComponentOneControlPanel or directly install the latest packages from NuGet.

  Best Regards,
  
  Kartik