Answered

Populating Key Column field while creating Table

(0) Share

Report

Posted on by Community Power Pla...

I have a flow that runs once a week and creates a worksheet in an Excel document, which has a name based on the date. It then creates a table also with a dynamic name. I need to populate the created table, but I can't figure out how to populate the key column. I am trying to move data from Sharepoint list into this Excel document so using the List ID would work I believe,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

PrasadAthalye on at

Like (0)

Report

Yes ID column is like a primary key for list Item. You can use that

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Ok, so how do I structure this? I can set the Key Column to be the Sharepoint List ID, but since it isn't in there it errors with this "No row was found with Id '1'."
I have this Update Row action

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

The key column and the key value is used to find the special row when use the Update row action, so you couldn't update the key value when use the update a row action.

You could only add a row with key value when use the add a row action.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No