Can anyone guide me to a solution?
Currently I have a flow that collects response data via a form to an Excel file into a SPO folder.
I use Power Automate (Flow) to retrieve Company Name, and user details using the 0365 user connector.
Help: I have a translation/conversion table in a Separate Excel sheet in the doc library where Company name = Internal Company Code.
On a schedule, how can I automatically pull Internal Company code from one excel doc into the Response Data?
Thanks for your quick reply.
Please see blog
Stupid Question: How would the filter query work in this instance if Excel "A" is my Translation Table that contains the information I want to pull from, and Excel "B" has a column in the sheet that I'd like to update with info pulled from Excel "A".
If I use a filter query, it seems that it will return a row's for a specific value I query from Excel A.
Do you want to get all rows from Excel 'A'? Then use List Rows action for Excel A without any filter query. This should return all the rows. Next add a foreach loop and define the filter to query Excel B to get the items. Add another loop inside the earlier loop and do the update.
1. List Rows (Excel B)
2. For Each
3. List Rows (Excel A) with Filter using Excel B column value match
4. For Each
5. Update Excel B
6. End of Loop Step 4
7. End of Loop Step 2
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!