Unanswered

Apply to each error when connecting to excel online table

(0) Share

Report

Posted on by erodriguez6393

I am trying to get Power Automate to run a Power Bi report for each of the users I have listed on an excel online table. Their email address is listed in the table and I wanted the flow to go to each of the email addresses to run the report based on their log in. I keep receiving and error that the Apply to each expression failed because the value from the excel table is type string and not array. I need help to find a work around or a way to make the information on that table "array" format instead of string.

Any suggestions? Screenshots below

All responses (2)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report

Re: Apply to each error when connecting to excel online table

Hi @erodriguez6393 ,

From the screenshot, 'Apply to each 2' is iterating through each row of the table but I am not sure what 'Apply to each' is used for.

If you need to reference a particular field, you can do so within your first loop i.e. for each 2

See below of an example of what I am saying

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
tom_riha 10,127 Most Valuable Professional on at

Like (0)

Report

Re: Apply to each error when connecting to excel online table

Hello @erodriguez6393 ,

it's hard to suggest if we don't know what data it contains. But I'd check the split(...) expression that'll allow you to convert a string into an array based on some separator.