Power Platform Community Forum Thread Details

Hi all,

I am unable to assign this table content data to variable, when I run through for each loop current item will show first row data with comma seperator then I use text split which will convert to list index and row content but now I want assign %TextList[0]% to Allowed Amount the output I am getting %TextList[0]% request to help me to get the allowed amount 441.79

Categories:

Power Automate Desktop

Hi,

Are you using Power Automate Desktop (with %VariableName% syntax)? or Power Automate Cloud (flows - with dynamic content and expressions)?

Also, if you need the value from the Allowed Amount column for each row you use DataTable actions, for example:

In your For Each loop, add the action > Get cell value from data table > DataTable: your table variable > Row: current loop index. > Collumn: Allowed Ammount (or column index 0)

In the end, store the result in a variable like %AllowedAmount%...

It gives you the correct value without extra parsing :)

BUT - if you already split into a list, make sure TextList is a List Type > USe Set Variable with %TextList[0]% - NO QUOTES!

----> Splitting text should only be a fallback when you can’t use native actions. :)

Good luck!
Rafael Felipe, Microsoft MVP.