Hi Andrew, you have explained a lot within 12 minutes of video, appreciate it. This method can be applied in may different apps, I have learned many things from your videos and have taken to the next level, thanks again!! 👍👍
Wow!! ❤ it so much! Thank you @Andew for answering my query. I will apply it now to my work as improvement. More power on your videos that I am closely monitoring. ❤❤ you man!
Thanks for watching Mike! It was a good question. There's actually a 2nd way to do it using Json and power automate too. But I think just using power apps is great option too.
I usually would use a JSON function in Power Apps to send the collection to Power Automate. I would them Parse the JSON and create an HTML table and or a csv file
If you have categoires that are the same say two rows with burger, how would you merge them in the HTML table. I've tried rowspan but realised its a concatinated string..
Hello Andrew, Got a challenge for you. I have a gallery 186 items from an excel file loaded as a collection. I run some code to add row numbers to the collection. When I filter the list I'd like the showing numbers to start at 1 instead of the range they are in from the 1-186 total item list number. Is that something you have been able to accomplish? For example, I filter to show items 25 to 35: I'd like the display numbers to start at 1 and go to 10.
@@andrewhess123 I pull the raw data from excel file onVisible and make the full collection, then filter on change of a combobox selecedItems. My excel table first column is a category, (its power app function types). The filter shows only the rows with the matching category to the cb.SelectedItems. I'm not sure how to create a collection with just the results of the filter. I suppose put an if statement to check the row to the cb and only if true, add to collection. I'll make a stab at it. Thank you for the quick reply. Keep up the awesome videos. You're super helpful. It's like normal helpful, but with a cape. :)
@@andrewhess123 Kinda took easier route. Since the data is static (just a reference table) I added 2 columns manually, 1 for All Functions (1 to 186) and 1 for Group Functions ( 1 to group length) then use an if statement to display the number column for AllNum if no filters are on and the GroupNum filter number column if the gallery is filtered. I was hoping to use dynamic numbering as I have other apps that the data changes and numbering manually would not be an option, but this works. If you have time to play with building the collection on filter change hit me up. Warm regards.
@@andrewhess123 Actually made some progress on dynamic numbering. start Code: With({_myFilter: With({_items: Filter(WOList, Or( IsBlank(cbWOList_EMP.SelectedItems), IsEmpty(cbWOList_EMP.SelectedItems), EMP in cbWOList_EMP.SelectedItems && Or( IsBlank(tSearch.Text), false, tSearch.Text in Notes, tSearch.Text in System, tSearch.Text in WO, tSearch.Text in 'Work Instructions' ) ) )}, SortByColumns(_items, varSortChoice, varSortOrder))}, ForAll(Sequence(CountRows(_myFilter)), Patch(Last(FirstN(_myFilter, Value)), {RowNum:Value} ) )) end code new issue is the form datasource is not compatible. Changed from the excel table (WOList) to the variable created when selecting the gallery item (varRecord). this fills the form, but wont submit. I almost got it. At least the numbering works :)
Hi Andrew, you have explained a lot within 12 minutes of video, appreciate it. This method can be applied in may different apps, I have learned many things from your videos and have taken to the next level, thanks again!! 👍👍
Level up!
Great video, I was able to replicate while watching!
Woot woot! Nice! So I wasn't going to fast then?
Wow!! ❤ it so much! Thank you @Andew for answering my query. I will apply it now to my work as improvement. More power on your videos that I am closely monitoring. ❤❤ you man!
Thanks for watching Mike! It was a good question. There's actually a 2nd way to do it using Json and power automate too. But I think just using power apps is great option too.
Thank you so much for this video! It was very helpful.
Thanks for watching Lucas!!
Thanks for this video. How do I show an image in the table?
I tried but nothing got displayed.
Good information here
Thanks for the continuous support Bshep!
@@andrewhess123 No problem, I'm starting to use Power Automate and Power BI for work so this is good stuff.
I usually would use a JSON function in Power Apps to send the collection to Power Automate. I would them Parse the JSON and create an HTML table and or a csv file
True that is an option, and I love sending JSON to Power Automate using Power Apps, but trying to cut out the whole Power Automate was my goal here.
Thanks for the input, maybe that is another video how to do it!
@@andrewhess123 if time allows 😍
If you have categoires that are the same say two rows with burger, how would you merge them in the HTML table. I've tried rowspan but realised its a concatinated string..
Probably not try to do it on the HTML side, and do it on the Power Apps side during the collection.
Hello Andrew, Got a challenge for you. I have a gallery 186 items from an excel file loaded as a collection. I run some code to add row numbers to the collection. When I filter the list I'd like the showing numbers to start at 1 instead of the range they are in from the 1-186 total item list number. Is that something you have been able to accomplish? For example, I filter to show items 25 to 35: I'd like the display numbers to start at 1 and go to 10.
Sounds like it could be possible, but you would have to recollect everytime you filter, and then you display the collection in your gallery.
@@andrewhess123 I pull the raw data from excel file onVisible and make the full collection, then filter on change of a combobox selecedItems. My excel table first column is a category, (its power app function types). The filter shows only the rows with the matching category to the cb.SelectedItems. I'm not sure how to create a collection with just the results of the filter. I suppose put an if statement to check the row to the cb and only if true, add to collection. I'll make a stab at it. Thank you for the quick reply. Keep up the awesome videos. You're super helpful. It's like normal helpful, but with a cape. :)
@@andrewhess123 Kinda took easier route. Since the data is static (just a reference table) I added 2 columns manually, 1 for All Functions (1 to 186) and 1 for Group Functions ( 1 to group length) then use an if statement to display the number column for AllNum if no filters are on and the GroupNum filter number column if the gallery is filtered. I was hoping to use dynamic numbering as I have other apps that the data changes and numbering manually would not be an option, but this works. If you have time to play with building the collection on filter change hit me up. Warm regards.
Very interesting the way you did this, thanks for sharing Mark!@@markperrah186
@@andrewhess123 Actually made some progress on dynamic numbering.
start Code:
With({_myFilter:
With({_items:
Filter(WOList,
Or(
IsBlank(cbWOList_EMP.SelectedItems),
IsEmpty(cbWOList_EMP.SelectedItems),
EMP in cbWOList_EMP.SelectedItems
&&
Or(
IsBlank(tSearch.Text),
false,
tSearch.Text in Notes,
tSearch.Text in System,
tSearch.Text in WO,
tSearch.Text in 'Work Instructions'
)
)
)},
SortByColumns(_items,
varSortChoice,
varSortOrder))},
ForAll(Sequence(CountRows(_myFilter)),
Patch(Last(FirstN(_myFilter, Value)),
{RowNum:Value}
)
))
end code
new issue is the form datasource is not compatible. Changed from the excel table (WOList) to the variable created when selecting the gallery item (varRecord). this fills the form, but wont submit. I almost got it. At least the numbering works :)