Power Platform Community Forum Thread Details

Hi,

I just created my first flow in Power Automate Desktop and I went for the Power FX syntax.

At one step in the flow, I read a table from a webpage (20 rows X 8 columns). Then, I use a for each loop in order to access the rows. When I try to get the value of a specific column, I get into troubles. The column in named "pondere (%)", as you can see in the first screenshot. The syntax used in a "Set Variable" stage is the following: =CurrentItem.pondere (%). I assume the issue is related to the column name, because for other column it works just fine, like for this one: =CurrentItem.simbol

The first question is, can I access it without renaming the column. In the old syntax (prior to 15th of March), I can use: DataFromWebPage[0][7], for example.

Screenshot 2024-04-01 132417.png

Next, I tried to use some PowerFX functions: ShowColumns, RenameColumns.

I found the following syntax: ShowColumns( IceCreamSales, "Flavor" ), RenameColumns( IceCreamSales, "UnitPrice", "Price") in the official documentation.

Screenshot 2024-04-01 132417.png

Second question is: Why the issue and how can I solve it?

In the end, I only want to access a specific value. Doing it in the old way seems quite easy, but with PowerFX, not.

Categories:

Power Automate Desktop

@CosNit

Based on my understanding, Power Automate Desktop currently lacks support for datatable operations using Power FX. I've experimented with various formulas such as renamecolumn and dropcolumn without success.

Microsoft also mentioned some of the limitations and know issues in their portal. Screenshot attached here for your quick reference.

If you're aiming to exclusively read the datatable during each iteration of a loop, I suggest utilizing the following syntax.

If you need to perform any datatable rename operations, I recommend utilizing .NET scripts for the task. It's straightforward and requires just a few lines of code.

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $fx'C:\Deenu\data_excel.xlsx' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: $fx'=ExcelInstance' ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN $fx'=ExcelData'
 Display.ShowMessageDialog.ShowMessage Title: $fx'Alert' Message: $fx'=ReadCell(CurrentItem, 1)' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏