News and Announcements icon

Power Platform CommunityForums Power Automate - Using Connectors I am trying to fill a ...

Power Automate - Using Connectors

Unanswered

I am trying to fill a cell in an existing Excel from another Excel sheet with no luck

(0) Share

Report

Report

Posted on by Ohayonson

Hey there

I have a form, i would like to add content to an Excel sheet with information from the responses and in a special column i would like to add a value from another Excel sheet with a cell that creates random isbn fx=UNIQUE(RANDBETWEEN(9788723527370120, 9788723527370990)))

What is the best way to do it?

All responses Img

All responses (1)

Answers Img

Answers (0)

abm abm 32,492 Most Valuable Professional on at

Like (0)

Report

Re: I am trying to fill a cell in an existing Excel from another Excel sheet with no luck

Hi @Ohayonson

Couple of questions:

1. You mentioned add a value from another Excel sheet with a cell that creates random isbn. Do you have more than one isbn values in this excel sheet. If you have multiple rows and going to match then you need to use the filter query for the list rows. Store the isbn in a variable.

2. Once you have the isbn then in your second excel sheet for adding the rows you need the Add rows action step where you can map your forms response values and the isbn variable.

Thanks

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans