Hi flow joe, im trying to get the value of a cell from a speceific row, for example, i need to extrarct the value of the column 3 where the value of the column 1 is a specific name. Can u help me with this? thanks
Is this from dataverse? You could use odata to filter the column. For example; column1 eq ‘whatever’ Then cycle through and get the third column. If you have a list already and you just want to check column1 add an apply to each, the use a condition of column1 equals ‘whatever’ then if true you can get column 3
You need to count duplicates in an array, I have a video coming out for this in a couple of weeks, but here’s a post about it; powerusers.microsoft.com/t5/Building-Flows/Count-Duplicates-in-Array/td-p/748045
This was a great solution, helped me over a similar problem. I'd really like to be able to do this within the table and save the rank as a new column in the table. Calculated columns and formulas don't seem to cut it. Using this method and writing back but feels unnecessarily clunky.
@FlowJowVideos, thanks for covering this topic. Any tips on multiple sorts. For instance, sort by country of origin (assuming three from Canada) and then further sort Canadian cats (or any other country grouping) by weight. I tried a sort(sort( variation. The flow ran successfully but did not produce expected result. Additionally, any tips on reverse sort? Thx, stay dry - Gerald from Winnipeg. ❄️⛄️
Hi flow joe, im trying to get the value of a cell from a speceific row, for example, i need to extrarct the value of the column 3 where the value of the column 1 is a specific name.
Can u help me with this? thanks
Is this from dataverse? You could use odata to filter the column. For example; column1 eq ‘whatever’
Then cycle through and get the third column.
If you have a list already and you just want to check column1 add an apply to each, the use a condition of column1 equals ‘whatever’ then if true you can get column 3
I'm trying to get a running count of items in a column. Example: Apple 1 Grape 1 Apple 2 Banana 1 Apple 3 Grape 2. How can I do this?
You need to count duplicates in an array, I have a video coming out for this in a couple of weeks, but here’s a post about it; powerusers.microsoft.com/t5/Building-Flows/Count-Duplicates-in-Array/td-p/748045
@@FlowJoeVideos I don't want to group the number of items. I want to show each item/record with the number of occurances of the item.
This was a great solution, helped me over a similar problem. I'd really like to be able to do this within the table and save the rank as a new column in the table. Calculated columns and formulas don't seem to cut it. Using this method and writing back but feels unnecessarily clunky.
@FlowJowVideos, thanks for covering this topic. Any tips on multiple sorts. For instance, sort by country of origin (assuming three from Canada) and then further sort Canadian cats (or any other country grouping) by weight. I tried a sort(sort( variation. The flow ran successfully but did not produce expected result. Additionally, any tips on reverse sort? Thx, stay dry - Gerald from Winnipeg. ❄️⛄️
What if I would like to sort descending?