Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Using forms to update 1 XlSX file and create another.

Posted on by 2
We are trying to setup a work flow where users will submit and microsoft form. The information form that form will be added as a new row in one spread sheet (running log) and then create and entirely new spread that is save for our developers to use. I has to be a new spread sheet each time. So far we have it pulling the information in to the running log spread sheet just fine. We are then trying to get it to pull the last row out of the XLSX and create a new one. Ive manage to get it to do that but the information is barely read able. 
 
I am using list rows in present table followed by a compose using the following expression.
if(greater(length(outputs('List_rows_present_in_a_table')?['body/value']),0),last(outputs('List_rows_present_in_a_table')?['body/value']),null)
 
I then took that output and used it with the create sharepoint file. 
 
The file is being created but as stated before is not formatted into a table. 
 
 
  • AlexEncodian Profile Picture
    AlexEncodian 4,261 on at
    Using forms to update 1 XlSX file and create another.
    Yes - I understand the requirement. 

    If you are adding a row to a spreadsheet, then you already have the data in the flow. So the question remains, why are you pulling data out of a spreadsheet. Simply use the data in the flow to create a new separate file.
  • DA-25111639-0 Profile Picture
    DA-25111639-0 2 on at
    Using forms to update 1 XlSX file and create another.
    The devs need a new file with the most recent submission each time one is made. 
  • AlexEncodian Profile Picture
    AlexEncodian 4,261 on at
    Using forms to update 1 XlSX file and create another.
    Why pull out the last row...why not just create a new spreadsheet in the same flow in which you are updating the other spreadsheet?

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard