Power Automate - MS Forms Excel File Upload, read contents and append rows into another excel file

This video explains Microsoft Forms Excel file upload, read the contents and insert into another excel file.
Expression I used under the Create table action step is as follows:
=OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),2)

[@nguyenmanhtuan1772]

Thank you Sir! I did it. Its save a lot of time in my job

[@abm4975]

You are welcome

[@sanjjoyrio3745]

Thanks for the support nice video

[@abm4975]

No worries. Glad to hear that it was helpful.

[@abongilembete9349]

I love this work you doing sir Will you please help me with creating a flow that's going to extract the name of the file from a virtual machine and the username first Secondly take that extracted file name and username and populate it to an excel sheet where again within onedrive it would do the same flow extract the name of the person who created the file and dump it again to the same excel sheet. I believe in your expertise 🙏

[@abm4975]

Hi For the cloud flows you need a location/endpoint to access the data. Check the desktop flow. That might be a possibility for your requirement. Thanks

[@reneenyong4638]

Hiii sir ! thanks for the great video! wanted to ask is there any way to generate template based on user choice 1. user fill up a microsoft form to select which template they want 2. there is a sharepoint that will locate over 1000 of word templates 3. based on user choice, the word template will be populated with their information And the placeholder for all templates is the same i am facing trouble to handle the dynamicfileschema, it would be great if you can do a vid on this topic! thanks a lot

[@abm4975]

Hi So is that choice populated under form? If it is populated under the form then you can collect the response, add an IF condition in your flow and use the right word template to populate the responses from the form. Thanks

[@danielfuentes2548]

Can you design a Power Automate workflow to extract specific columns from an Excel file uploaded via MS Forms (not formatted as a table) and populate a CSV template?

[@abm4975]

Hi Thanks for the question. There are few videos about how to create a table dynamically and read the contents of an excel file. You can create comma separated rows using a compose action step and append the values. Thanks

[@manilaphilippines8285]

Hello sir! May I know if this can be done even if you have multiple excel templates uploaded? Ex. File 1 contains emp name, emp no. File 2 contains department name, dept nos. Goal is to have 2 master file

[@abm4975]

Hi I need to check this. Thanks

[@ENCRYPTECHkalashkala]

Hello, this is not working, I tried adding ID to the create table but it is showing that the resource cannot be found. But when I use get file content one drive then it is able to detect the file using ID. If you know how to solve this then please let me know !!

[@saurabhtalele1537]

how can i know who sent us response.... how to get it without responder put his response on Microsoft form if we send Microsoft form by email to responder....

[@abm4975]

You can get the responder's email from the Get Response step. Thanks

[@DheerajKumar-ym9ei]

Hello sir, I have a problem in power automate. Problem statement: create a job to monitor the SharePoint folder on daily basis or monthly basis and if the file is not uploaded for the day then send email to me that file has not upload today. Please help me to create this job. Thanks and regards Dheeraj

[@abm4975]

Hi Apologies for the late reply. Do you still need help in this? Please let me know. Thanks

[@DheerajKumar-ym9ei]

@@abm4975 Hello sir, I still need your help

[@abm4975]

Hi Use the schedule trigger and add the SharePoint connector List Items query against the created on date matching todays date (utcnow). Thanks

[@DheerajKumar-ym9ei]

@@abm4975 would you please say the filter query of get files property(SharePoint) to search for past 90 days files

[@abm4975]

Look for addDays() expression. addDays(utcNow(), -90) will give you the date which is from today'date minus 90 days. Use that in your filter.

[@shimaaal_harbi4155]

is body id same as id? is not working

[@abm4975]

I am not sure what you meant by? Which output body you referring to? Thanks

[@pralaynipane4947]

Can I get a sample json .. I am not a cs guy

[@abm4975]

Which JSON you after?

[@pralaynipane4947]

@@abm4975 not a doubt anymore , but your video was really helpful

[@abm4975]

Thanks

[@Naveenkumar-db4pj]

Hi sir, i have doubt and could not get solution.. The problem is..i need to schedule a flow by getting a email with respective subject and sender and then if yes send an email to specific person has mail received and if not send as mail not received in outlook. I tried but condition is not getting value from get emails(v3) section.... If possible please upload a solution thanks.

[@abm4975]

Hi Could you contact me via teams? Happy to do a screenshare and help. See my Channel about section for details. Thanks

[@Naveenkumar-db4pj]

@@abm4975 sorry I do not get anything..is there any other way to connect?

[@abm4975]

Check my channel about section and contact me via teams. I will have a look. Thanks

[@Naveenkumar-db4pj]

I've seen but i couldn't find if possible please share the link directly.thanks.

[@abm4975]

www.youtube.com/@abm4975/about See at the last section