Great video! Thanks a lot for this content. It helped me a lot on a flow I'm creating to import itens from a Gallery (in power apps) to Excel Online(for business) !
Thanks Gerard, I’m really excited by this video. There is a lot of learning and ideas that can be taken from it. Glad you enjoyed it and thanks for the feedback. 👍
Hi Damien, you are a genious, this video inspire me to implement a solution in my flows because I had a lot of nested Conditions, this is really easy and great, I'm very grateful with you because all your videos are so interesting and I've been learning a lot with your content. At the begining I didn't understand but I keep triying and I did it. Cheers from Mexico, and I hope you are feeling ok this days :)
You could. It’s about creating an object. A select will give you an array but you can remove the square brackets and replace with squiggly. I do similar in other videos. I like your thinking.
This is fantastic! Just one question about the use of the Get items action (around 7:15)...is that basically just a means to the end of converting the array (of items returned) into an object? I'm a big fan of using dynamic data for these types of flows, usually storing it in a SharePoint list and then Get items with a filter query to return just the relevant item based on the response in the form. If that list were large (many items or many columns or both), that apply to each action could slow things down and (in extreme cases) bump into the API call threshold. Thank you for all the amazing content you've created and I hope you have a chance to relax over the holidays!
The alternative is indeed a filter array or an odata filter on get items for a single dynamic status/option. I’ve a similar video for that too ua-cam.com/video/OEk6RMLQ89s/v-deo.html if it was a list of 100s/1000s items, I would agree that the apply to each would be inefficient. You can achieve the same repurpose using a single select and concat. If your data was being used dynamically multiple times across the flow, like the following www.reddit.com/r/MicrosoftFlow/comments/zr2xm7/power_automate_multiple_nested_if_statement this would work better as the values can be referenced directly with an expression.
It really depends on the use case. If you’ve got multiple dynamic values, this will allow you to use them all. It’s a progressive solution, use an object for fixed dynamic values, potentially use an odata for a single value, or repurpose and call the data based on name. This video is similar to what you have suggested ua-cam.com/video/OEk6RMLQ89s/v-deo.html
A fantastic Idea and Content!! 👌🏽 I have a quick question, I am trying to extract Site pages using "Get files (properties only)" but then there are around 7 columns having Managed Metadata (lookup columns). So I wasn't able to pull those 7 columns data. I then used "Get Items" action and tried to pull the values using "Select" and whenever I selected the lookup column values the "apply to each" started nesting on each value that I applied. My question here is, if I initialise the variable for each column and use "add property" expression, will I be able to bypass the apply to each nesting?
I am trying to extract the whole site pages (we have 1000s of solution catalogs as pages) list into the Excel. I know we have "export to excel" button but wanted to automate. Will GET from "send an Http request to SharePoint" work?
Hi Chandrasekar, quite a question. I wonder if you could post this with screenshots on the forum? Much easier to discuss there powerusers.microsoft.com/
I wondered why you inserted a space into an expression around the five minute mark of this video AND THEN you explained why around the eight to ten minute mark of the video linked below, thx!!! ua-cam.com/video/p26sL3qHmfs/v-deo.html
It’s a clever little trick. I used to copy / paste the pills to get the expressions or peek at the code but then learned this trick. I suspect the expression editor will change soon but it’s handy for grabbing those expressions of existing dynamic content 👍
Great use of / in order to bypass an error.
Brilliant, and a merry Xmas to you. Keep on the good job 👍👍
Cheers Frank. Merry Xmas to you too.
Great video! Thanks a lot for this content. It helped me a lot on a flow I'm creating to import itens from a Gallery (in power apps) to Excel Online(for business) !
Thank you for this rich and valuable content - so many applications for the methods you have explained so well - thank you.
Thanks Gerard, I’m really excited by this video. There is a lot of learning and ideas that can be taken from it. Glad you enjoyed it and thanks for the feedback. 👍
Hi Damien, you are a genious, this video inspire me to implement a solution in my flows because I had a lot of nested Conditions, this is really easy and great, I'm very grateful with you because all your videos are so interesting and I've been learning a lot with your content. At the begining I didn't understand but I keep triying and I did it. Cheers from Mexico, and I hope you are feeling ok this days :)
Amazing Ana, thank you so much for your comment 👍 I love hearing how this has helped folk with their solutions.
@@DamoBird365 As I said before, you are a great teacher!!! Thanks again 😃
Grateful for your videos
I’m going to try this out.
Can the 'apply to each' action be replaced with 'filter and select' actions. Thanks for sharing.
You could. It’s about creating an object. A select will give you an array but you can remove the square brackets and replace with squiggly. I do similar in other videos. I like your thinking.
This is fantastic! Just one question about the use of the Get items action (around 7:15)...is that basically just a means to the end of converting the array (of items returned) into an object? I'm a big fan of using dynamic data for these types of flows, usually storing it in a SharePoint list and then Get items with a filter query to return just the relevant item based on the response in the form. If that list were large (many items or many columns or both), that apply to each action could slow things down and (in extreme cases) bump into the API call threshold.
Thank you for all the amazing content you've created and I hope you have a chance to relax over the holidays!
The alternative is indeed a filter array or an odata filter on get items for a single dynamic status/option. I’ve a similar video for that too ua-cam.com/video/OEk6RMLQ89s/v-deo.html if it was a list of 100s/1000s items, I would agree that the apply to each would be inefficient. You can achieve the same repurpose using a single select and concat. If your data was being used dynamically multiple times across the flow, like the following www.reddit.com/r/MicrosoftFlow/comments/zr2xm7/power_automate_multiple_nested_if_statement this would work better as the values can be referenced directly with an expression.
Why can't we just oData filter query instead ?
It really depends on the use case. If you’ve got multiple dynamic values, this will allow you to use them all. It’s a progressive solution, use an object for fixed dynamic values, potentially use an odata for a single value, or repurpose and call the data based on name. This video is similar to what you have suggested
ua-cam.com/video/OEk6RMLQ89s/v-deo.html
A fantastic Idea and Content!! 👌🏽 I have a quick question,
I am trying to extract Site pages using "Get files (properties only)" but then there are around 7 columns having Managed Metadata (lookup columns). So I wasn't able to pull those 7 columns data. I then used "Get Items" action and tried to pull the values using "Select" and whenever I selected the lookup column values the "apply to each" started nesting on each value that I applied. My question here is, if I initialise the variable for each column and use "add property" expression, will I be able to bypass the apply to each nesting?
I am trying to extract the whole site pages (we have 1000s of solution catalogs as pages) list into the Excel. I know we have "export to excel" button but wanted to automate. Will GET from "send an Http request to SharePoint" work?
Hi Chandrasekar, quite a question. I wonder if you could post this with screenshots on the forum? Much easier to discuss there powerusers.microsoft.com/
I wondered why you inserted a space into an expression around the five minute mark of this video AND THEN you explained why around the eight to ten minute mark of the video linked below, thx!!! ua-cam.com/video/p26sL3qHmfs/v-deo.html
It’s a clever little trick. I used to copy / paste the pills to get the expressions or peek at the code but then learned this trick. I suspect the expression editor will change soon but it’s handy for grabbing those expressions of existing dynamic content 👍