web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Write to excel workshe...
Power Automate
Suggested Answer

Write to excel worksheet on a specific line

(0) ShareShare
ReportReport
Posted on by
Hello all,
 
Je fait face à un problème depuis plusieurs jours et j'espère trouver la solution ici. 

J'ai crée un flow afin d'optimiser ma veille concurrentielle, recherche de nouveaux articles sur des sites internet. 

Voici grossièrement les étapes du flow:
- lancer le VBA: qui permet de populate la table avec les noms d'entreprises
- webscrapping pour récupérer les infos
- écrire les infos de chaque entreprise sur la ligne correspondante (le problème)

Je n'arrive pas à faire en sorte d'écrire sur une ligne qui contient une valeur spécifique en colonne [nom d'entreprise].

J'ai joint des screens du flow et voici quelques indications:
- la table s'étend de la colonne A à N
- voici les l'ordre des colonnes
A: année
B: mois
C: CompanyName
D/E/F: (not important)
G: where information should be pasted
H/I : (not important)
J: where the link of the article is pasted
K/L/M/N: (not important)

- Le JSON est celui qui scrap les sites internet
Screenshot 2025-10-14 152517.png
Screenshot 2025-10-14 152527.png
I have the same question (0)
  • Suggested answer
    eetuRobo Profile Picture
    4,547 Super User 2026 Season 1 on at
    Make sure you are referencing the correct column in the CurrentRow2. Power Automate Desktop datatable column indexes are zero-based which means CurrentRow2[0] is the first column and CurrentRow2[3] is fourth column which would be D. So try changing the CurrentRow2[3] to CurrentRow2[2] so that would be the C column which has CompanyName in it.

    I suggest you add some "Set variable" -actions and break points for debuging to validate that the data is correct or that you are referencing the correct column for example. Like so:


    Then check what will be given to the DebugVariable and verify if that is correct data or not.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 376

#2
Valantis Profile Picture

Valantis 361

#3
David_MA Profile Picture

David_MA 294 Super User 2026 Season 1

Last 30 days Overall leaderboard