How to update an excel row after it has been created through power automate?

(0) Share

Report

Posted on by Siyamand Rashid

366

Hello All,

if i have a flow to create an excel workbook from a template which i defined a table (the table name is tblDate), and after creating an excel workbook based on this template i want to update a raw but seems to be im missing something

the last action is updating that excel sheet which is created in the previous step, and becuase it is not exist before runing the flow it is not showing the filed to add the new value

how to work around this please?

Regards

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @SiyamandRashid ,
If you having the parameter "Provide the item properties" with required field .
It means power automate doesn't recognize the schema of your input so you need to provide input in JSON format.
Here is a test for your reference:

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the support, that is what i was looking for
thanks again.

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report
Copy link

Link copied!

But i got one issue, if i want to update more than one row .. it fails !!! please help @v-chengfen-msft

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report
Copy link

Link copied!

in the key value i also tried to put 1,2 , but didn't work

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SiyamandRashid ,
The reason why met this problem is:
[Update a row] can only update one row.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the quick respond, so there is no other way to work around this?

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @SiyamandRashid ,
If you want to update all the data dynamically, maybe you can try creating a new table to add the data in。
Here are some links for your reference:
Solved: Create Excel file and add row - Power Platform Community (microsoft.com)
Solved: Re: Updating an excel sheet which is a subject of ... - Power Platform Community (microsoft.com)
Best Regards
Cheng Feng

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report
Copy link

Link copied!

thank you very much for your helpful support.
Regards

Was this reply helpful? Yes No