Hello Community!
I am trying to make a flow with Power Automate Desktop, and stuck with issue.
I have my invoice numbers and statuses in Datatable read from Excel into variable.
After processing invoice in for each loop I should update status row in Datatable to writeback to Excel file.
%CurrentItem% variable not seems to be working, at least I can't update a row referencing with %CurrentItem%.
Data structure is this simple:
invoice status
1
2
3
...
Any suggestions how to keep a track of what invoices(rows) were processed?
Thanks!
