Unanswered

Use form response to Delete a row in Excel (online)

(0) Share

Report

Posted on by Community Power Pla...

I have set up a database for lab inventory. Each item has a unique barcode. I created a form that staff can scan barcodes on the item. I want to set up a flow that uses this form submission data to delete the row corresponding to that particular barcode. Please help. I have tried multiple things and cant figure it out. I dont have a ton of code experience and dont believe I can use Dynamic content for all of this.

All responses (5)

Answers (0)

MafazAnsar 14 on at

Like (0)

Report

Re: Use form response to Delete a row in Excel (online)

Hi,

I'm also having a similar issue. tried the solution as above. Doesn't seems to be working out. I have a table and a form created. The idea is that, If the data entry person realises the data submitted contains an error, he will have to submit the row no via the form to delete that specific row. Below are my form, table, flow and the error message I get at the end. Appreciate your assistance.

The form
Table
The flow
The error message
GabrielStJohn on at

Like (1)

Report

Re: Use form response to Delete a row in Excel (online)

Hello, @Anonymous!

Thank you for posting to the Flow Forum! Our team is dedicated to creating a positive product experience and value your insight on how we can improve our product features! I see that one of the replies to your post may be the solution to your problem! If your needs have been met, please mark the reply as the “Accepted Solution”!

Thank You!

-Gabriel
faustocapellanj 1,662 on at

Like (0)

Report

Re: Use form response to Delete a row in Excel (online)

Hi @Anonymous

The Respose ID you get from the Dynamic content is the one you need. From there, all the data from the Microsoft Form will be available in Flow. If you look at the screenshots uploaded by @v-xida-msft, you can see in the Delete a row action that Product Barcode is being selected from the Dynamic content available from Microsoft Forms.

I can say that follow the steps provided by @v-xida-msft and they worked just fine. As for uploading screenshots to the forum, save the image file on your computer and then click on the Photos button available in the text editor where you type your response. This will walk you through how to select the file from the respective location.

Please do not hesitate to reach out if you have any questions or are experiencing any difficulties in Flow.

Regards.
Community Power Pla... on at

Like (0)

Report

Re: Use form response to Delete a row in Excel (online)

My form is through microsoft forms. I have opted to try and delete a row in google sheets rather than excel. I tried to construct the flow in the way you listed. However, in the get response details column, my only option for response id is the dynamic content option that says response id. I believe this has to somehow translate to the barcode number being submitted in the form in order for my flow to work. I am not sure how to upload screen shots in this forum.
v-xida-msft on at

Like (1)

Report
Re: Use form response to Delete a row in Excel (online)

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

Could you please show more details about the form that you mentioned? Is it a Microsoft Form?

Where does your Excel file store? Is it existed in your SharePoint?

I assume that your Excel file is existed in your SharePoint, I have created it on my side and the data structure of it as below:

I have made a test on my side and please take a try with the following workaround:

Add a "When a new response is submitted" trigger.

Add a "Apply to each" action, input parameter set to output of the trigger.

Within "Apply to each" action, add a "Get response details" action, specify Form Id and Response Id. Then add a "Delete a row" action of Excel Online (Business) connector, specify Location, Document Library, File and Table. The Key Column field set to Barcode column in your Excel table, Key Value field set to Product Barcode dynamic content of the "Get response details" action.

Note: The Product Barcode dynamic content is the answer to the Product Barcode question in my Microsoft Forms. In addition, please make sure that you have formatted the data of your Excel file stored within your SharePoint library as a table.

Image reference:

The flow works successfully as below:

Best regards,

Kris