I'm sorry if this sounds easy but I have searched for a while now and couldn't find an answer for it so I decided to ask for help in here.
Right now we have two sectors (let's say Sector A and Sector B) and when Sector A creates a new file and there's information that must be analyzed by Sector B, they must filter Sector A's excel file with those information, send it to sector B and then sector B must copy and paste the necessary rows in order to do their job.
So my manager decided it must now work in a specific way that sounds easy but I can't figure out how to do it, which is the following:
All the files will now be Stored in Sharepoint. There will be a Folder for Sector A and one folder for Sector B. When Sector A creates a new excel file, there will now be a new column in which they must point out with a "X" which information must go to Sector B. So when they drop this file in Sector A's folder, Flow must read through it, searching for the "X" in that column, then get those rows and create a new excel file in Sector B's folder, containing only the rows marked with an "X".
To clarify it, there's an simplified visualization bellow:
So when Sector A drops an excel file like this one on Sector A's folder on Sharepoint:
|Name||Age||Interest||Must Go To Sector B|
Flow must read through the column "Must Go to Sector B", get those rows with an "X" then create the following excel file on Sector B's folder
|Name||Age||Interest||Action Taken||Client's Answer|
Thank you very much in advance!
You need to make sure that the data will be marked in the sector A file in to a Excel Table.
If you use Excel connector you can filter the table rows with "X" to get the needed data.
The filtered data can then be passed in to a new excel file in to a new Table.
You can dynamically create the table and get the new Id of the table then pass the data into the table with Excel script or the Excel connector actions like add a row etc...
How to create in cloud a new excel file please check my post in the community:
Hope this could help 😉
Can you please give me more details about how can I filter the table rows with "X"? This is mainly where I'm struggling at right now.
Great post by the way (How to Create Excel Woorkbook in a Cloud), really helpful, thanks.
Please use the ODATA filter function like in my example 😉
In you case you need to write in the filter Column eq 'X' or Column eq 'x'
Hope this helps 😉
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.