Updating Items in SharePoint list within flow and write to New Excel File

Like (0) Share

Report

Posted on 28 May 2020 03:03:37 by apadill4

I have a working flow that takes items from a sharepoint list, updates one of the columns with a new value if the new items in the sharepoint list is approved. There are three approvals. Each time the items are approved they are updated to a new value. Basically, I have a certain amount of records and I am updating one column three times after each approval. After that process, which works, I want those said records to be written to a new excel spreadsheet, which also works. The problem that the only fields that are not being written to the excel spreadsheet is the column that I am updating within the flow. If you need more details please let me know.

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

v-alzhan-msft on 28 May 2020 at 07:31:57

Like (0)

Report

Re: Updating Items in SharePoint list within flow and write to New Excel File

Hi @apadill4 ,

You need to add a Get item action before the "Add a row into a table" action in the Apply to each 3, the get item action would get the new column s value in the item and you need to add the column dynamic content from the Get item action in the "Add a row into a table 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.