Hello guys, i have a simple problem, but i am begineer in Power Automate.
Data problem:
I have two dbs in SP List.
db 1 = Estrutura de Times.
db 2 = Times FTs.
Column with similar values = Title (db1), SupOrg Time (db2)
dbs Filters:
Before this, i need Filter in both lists Planta = 21. (I can only get data where in both lists Plant = 21)
And the Column = Status Time (db2) = ATIVO.
What i need:
concatenate these two lists to form one, dropping on all records from db2, bringing ONLY records from the GMIN LG column (db1).
and dump them into an online excel, with a frequency (db2) every week.
you need to remove the select action that you have, and follow the bellow scenario
Get Items
Initialize Variable
Create an array variable to hold the results from the concatenation process.
Process Items from db2
Use the "Apply to each" action to loop through the items retrieved from db 2 values.
Within this loop, implement a "Get items" action for db 1 to find entries where the Title matches the SupOrg Time from db 2 make sure to use the correct col names.
Add a condition to check if there is match or not
Collect Matching Values - Append to array variable
For each matching entry found in db 1, add the value from the GMIN LG column to the array variable.
Create Excel File
Use the "Create table" action to set up a table in an online Excel file (e.g., OneDrive or SharePoint).
Then, use the "Add a row" action to populate the table with the values stored in your array variable.
Save and Test
Save your flow and run a test to confirm everything operates as intended.
Quick question: Is there a one-to-one match between db 1 and db 2, or can there be multiple matches? How should we handle them if there are multiple?
Cheers,
Sam
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.
Share
Report
All responses (
Answers (
299
