Power Automate - How to filter Excel rows and create new excel files and contents based on a filter?
Вставка
- Опубліковано 14 жов 2024
- This video explains how to filter Excel records and create new excel file and contents based on a filter?
Community Thread:
powerusers.mic...
Thanks! With your help now my flow works as well! 😁
Glad I could help! Thanks a lot.
Thank you very much sir for your help, video trex explanatory and instructive
Thanks Mohammad. Glad that its helpful.
Hi
Can u use the same for SharePoint for creating the Excel sheet without using one drive
It Is possible to do it that way
Trying to help me out is some emergency
Yes you can. Add a row into table action step (Excel Connector) provides the location to choose from Onedrive or SharePoint.
Thanks
Hello, thanks for the very detailed explanation. At 21:46 when you discovered something not quite right, what was it that you corrected? I am stuck at this. Thanks very much for your advice.
So for me I already run the flow in my prep video. Then when I start using the same data Dept excel sheet is already created. For the demonstration purpose I did changed the dept name. In your case close the browser sessions and leave it for few minutes. Then run the flow. It won't get locked. If you need further help in this let me know. Thanks
@@abm4975 Thank you for your reply. I understood this part. However, is there any issue with the filter array output returning Body[]?
@@abm4975 Just to add, I managed to create the new department files but their contents were empty. I wonder if it has anything to do with the filter array output returning Body[].
@@abm4975 Specifically, it is at Apply to each 2 that the Output returns Body [].
Hi Sarah
I need to check your flow. Could you check my channel about section. Send me an email. I could offer a screenshare help to progress this.
Thanks
I created a flow based on your instruction. However the output is not reflected in the new excel files.
Please help.
Can you help on the issue that I am facing this error while selecting the table name from one drive - Could not retrieve values. The dynamic invocation request failed with error:
Hi
Could you post this question in Power Automate community. I will have a look.
community.powerplatform.com/forums/thread/details/?threadid=bbcf6764-c049-ef11-a317-6045bdeef8e9
Thanks
Thank you very much. Very good video, but the files are not filling up.
Hi
Thanks for the comment. Could you please explain what you trying to filter? What's the data type of the column?
Hey. Thanks for your answer.
So the first column contains the names of my students, and I want to filter based on that
@@abm4975 I too have same problem like I can able to create new excel file but the contents are empty. Can you please help me on this
@@abm4975 hi I too have same problem I'm able to create the excel files but the excel content are empty
I too have same problem ..The excel files are getting created but the excel content are empty