Answered

Help understanding how to populate a text field from a list of %exceldata%

(0) Share

Report

Posted on by yanksy

Hello,

I am trying to use power automate for the first time. I have a flow that is working but I have hit a road block. Here is my flow:

It successfully extracts the data I need, as follows:

I need to use that list to populate a text field within a website 1 at a time. How would I get populate text for to do that? I'd assume I would need something like this but I am not familiar with how to write in the language needed:

I would need the text field to populate with #0 from "ExcelData" then create a duplicate tab and add #1 to the text field, then duplicate tab #2, etc. etc. until my list is done.

Please let me know any questions you may have and thank you for any help you try to give!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

yanksy 11 on at

Like (0)

Report

UPDATE:

I am much closer to my desired outcome now.

Using this with a 'for each' 'loop' is close. It adds the first row to the text box, then adds the second, then the third, etc. The problem is it only adds it within the first tab and doesn't recognize the duplicate tab (made with ctrl+shift+K).

So I get something that looks like this where the first tab is the only one that the text changes in:

I need the automation to populate the new tabs with the next row in the "for each" loop.

Was this reply helpful? Yes No
Verified answer

yanksy 11 on at

Like (0)

Report

SOLVED:

Works flawlessly for anyone that runs into a similar need. 👌

Was this reply helpful? Yes No