Unanswered

Increase Variable

(0) Share

Report

Posted on by GenAi

I created a flow that stores a list as a variable and for each of the list item, extract certain data and export it to excel csv file. I can't seem to get the variable increment to work and keep getting the error " Argument Value must be Numeric value". Could you please look at my flow and help? Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I think the value you are getting for NewVar before the ForEach is text.

Use a Convert Text to Number action to make it a number, then you can increase it.

Good luck!

Was this reply helpful? Yes No
GenAi 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Would the value of the variable cause this error considering that I referred to the index of the variable "DataFromWebPage[0]"?. I did however tried what you suggested and got the error" Can't convert text'Corporate...8 into a valid number. Below is the information in the DataFromWebPage, if it helps. Thank you

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@GenAi

The value which you assigned before the for each loop for Newvar is looks like datatable. If you check it, it’s holding your DataFromWebPage[0] —> it means which contains your datatable with first column.

So first decide what value you want to assign into Newvar variable and make sure it’s in number format.

In case if you want to assign datatable row count into your Newvar variable you can assign like this

%DataFromWebPage.RowsCount%

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 🚀

Was this reply helpful? Yes No
GenAi 80 on at

Like
a
(0)

Report
Copy link

Link copied!

I couldn't get it to work that work. I ended up changing my logic how to build the entire flow. Thank you

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GenAi ,

Your Newvar(DataFromWebPage[0]) is in string format ven though you use Convert text to number it wont work as it wont convert the string to a number,so increase variable also dont work.

Instead you need to set a variable as a RowValue and Increase that as shown in below image.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No