Unanswered

How to add script in the "Run Script" step?

(0) Share

Report

Posted on by EvaSantos

Hello everyone. I'm new to power automate and I'm encountering some issues with the Run script step. I'm trying to add a script in this step to create an excel from from a template. How am I supposed to add the script? I have it in a SharePoint folder as a script.txt, but I don't see options to include it.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

creativeopinion

10,508 Moderator on at

Like (0)

Report

Copy link

Link copied!

@EvaSantos You need to add the script in Excel via the Automate tab.

You might be interested in this YT Tutorial: ✌️TWO WAYS to Get Data from Excel into a SharePoint List

There are two ways to get your data from Excel into a SharePoint List:

1️⃣ Copy and paste

2️⃣ Automatically with a Power Automate flow

In this video tutorial I will show you how to get your Excel data into a SharePoint List using the two methods listed above. I’ll cover how to format your data for complex columns such as a multi-choice and multi-person columns.

---

IN THIS VIDEO:

✅How to copy and paste data from Excel into a SharePoint List

✅How to format Excel data for multi-choice columns in a SharePoint List

✅How to import data from Excel into a SharePoint List with a Power Automate Flow

✅How to use the Select action in Power Automate

✅How to use the Create Item action in Power Automate

✅Enabling the Concurrency Control to Optimize Flow Performance

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No

EvaSantos 49 on at

Like (0)

Report
Copy link

Link copied!

Lo siento, tal vez no me expliqué bien. No quiero exportar datos de un Excel a una lista, quiero crear un archivo de Excel basado en una plantilla. Como se muestra en este tutorial:
🚀Power Apps, Exportar registros a Excel con Power Automate - YouTube
El guión está aquí:
https://learn.microsoft.com/es-es/office/dev/scripts/resources/samples/convert-csv
Este es mi flujo hasta ahora. Por el momento, solo se generan archivos vacíos.

Was this reply helpful? Yes No