Hi,
I've created a flow which does the following;
The issue is, I currently have about 20 search terms and columns in the output spreadsheet, for each one I paste in the above formula and then manually type in the search term. In future this number of terms will increase and I dont want to be manually writing the formula. Is there a way I refer to the output column name in the formula as the search term, or an array or something else that would do this? Obviously the search term needs to match the output column name;
Solved! Go to Solution.
Hi @chrisingham,
You could initialize an array variable, then List all rows of the terms Excel table. Then use the Apply to each action to loop through these rows, append each item into the variable:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chrisingham,
After you get all term and put them into an array, you could use the contains condition or contains() function to determine the value from Excel whether exist in the array, for example:
If Yes, append these pieces of information into the Rows array variable:
Then loop the Rows array, input these pieces of information into the Excel table:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chrisingham,
You could initialize an array variable, then List all rows of the terms Excel table. Then use the Apply to each action to loop through these rows, append each item into the variable:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thank you for this suggestion, I see that this would allow me to have an array with each of the search terms listed in the array, however I then need to somehow run the if statements and add more values to the array which I'm not sure how to do. For example, I think the steps would be as follows;
Or
I'm not sure how to do the later steps listed above, and I'm not that familiar with arrays, I see them as a matrix of effectively columns and rows which represent values added to the array but I'm not sure if it works like that in flow.
Any suggestions or examples would be great
Thanks
Chris
Hi @chrisingham,
After you get all term and put them into an array, you could use the contains condition or contains() function to determine the value from Excel whether exist in the array, for example:
If Yes, append these pieces of information into the Rows array variable:
Then loop the Rows array, input these pieces of information into the Excel table:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
92 | |
58 | |
42 | |
40 | |
38 |
User | Count |
---|---|
84 | |
71 | |
57 | |
56 | |
42 |