You’re offline. This is a read only version of the page.
Announcements
112
Hi all,
I'm having an absolute nightmare with something I feel should be fairly simple.
I've created a Power Automate Desktop flow that executes a SQL statement and returns a set of results (50-100 rows, 16 Columns) and should then perform a series of actions for each item. The first of these items is to input the traderid into a field on the UI. The trouble I'm having is the error "Variable 'CurrentItem' doesn't have a property 'traderid'. Everything I can see clearly indicates that it does have this property. (Screenshots below of the CurrentItem, and the error received.
Step that's failing:
Current Item information:
Error Message:
I've convinced myself that this is something really obvious that I'm doing wrong, but I absolutely cannot figure out what it is! Any help would be greatly appreciated.
Update: I figured it out! Annoyingly, it turns out you can't reference the Current Item by it's column name. Changing it to a column Number in the 'send keys' seems to have worked:
%CurrentItem[0]% successfully inputs the correct value. (Tested this with the other values I needed and it's worked consistently with using the column number.
Share
Report
All responses (
Answers (
