I did everything you mentioned. My webpage has 19 pages, my whole pages run through the flow but when the flow ends i get data only for the 1st page, why so? Please please help

Worked perfectly, and you are completely right, it isn't as easy as you could think to make a flow fail for testing; I couldn't find anything like this anywhere else, thanks!!!

Thank you so much! you explained all very well and I like how you broke down each function.

Thanks for creating informative video. I have a query I am following same steps. My data on web page is in tabular format. I am selecting entire table where the data is present. It previews correctly. However when I run flow it gives error Unable to fetch data fro web page. Please help me where am I incorrect.

Excellent video, saved my work! Tip: Here there was a duplication error for columns with the same name between collections. Those who work with lists in Sharepoint may have difficulty, especially with the automatic list columns that are loaded into the collection. As a solution, I created other collections by adjusting the name of the duplicate columns and leaving only the columns that did not have the same name.

Hi, thank you for this video. I'm currently facing the same issue. I'm doing ClearCollect(SharepointListName, LocalCollection) and in studio the data gets retrieved properly, but when using the app normally many columns are blank. This doesn't make any sense, the only thing I do in my gallery control is to show ThisItem.ColumnName. It worked fine for 3+ months now. All I did yesterday was to clean the data and add new one. Any idea what it could be ? I'm suspecting Microsoft broke PowerApps again as for the past 2 weeks there are a lot of caching problems

Why do my videos always have bad fps? when im actually recording the fps is fine but the video ends up really bad (im recording roblox btw)

Thanks. This was clear and helpful

Thank you sir for explaining the concept. This give the idea to export my filtered choice columns by replacing Lookup to filter, Hope it works. Thanks again.

Hoping someone can please help me, I have a multi tab form in powerapps and a dashboard that displays the list items created. When I select the form to edit it and make any updates and save it, it then creates a new Item instead of updating the selected item! Edit button is currently- OnSelect - EditForm(Form1); EditForm(Form2); EditForm(Form3); EditForm(Form4);Navigate(Non Fraud New’,ScreenTransition.Fade) And Submit button is - OnSelect- ‘Patch( ‘Disputes List 2.0’, Defaults(‘Disputes List 2.0’), Form1.Updates, Form2.Updates, Form3.Updates, Form4.Updates); Notify( “data submitted” Notification type.Success); I don’t know what to do I’ve tried everything 😢

Ok, I'm going to try again. The issue is what if the value for this field is populated when you click on a gallery that contains a lot of different values for the field. Each time you click on the SharePoint it populates the text field with the value the numeric value that was stored. However, it doesn't format it because there isn't an OnChange fired. Would love to know how to use this solution when you aren't starting out with a blank.

How do you get this to work on a value that is store in a SharePoint list. In other words, the value of the text box is populated with different values as you click on a gallery, which pulls in the Sharepoint record. The formatting only happens on a change and so setting the default to the value from the SP List (number only) you don't get the formatting.

this is only working when I add User to the Security Role but when add a ADD Security Group (user belongs to this group) it not working.

Was looking for a solution on this specific scenario online...for hours!! You saved my night and gave me peace. THANK YOU!

Thanks a lot for this. Bonus points would be for including the text of the 2 expressions :-)

I did the same , during testing i am getting the form with data , but while preparing the link , i am not getting the Order value in the label

Thank you so much!!!

Cześć, wygląda na to że jesteś Polakiem (w końcu imię i nazwisko jak najbardziej polskie) więc po polsku będzie prościej. Na filmie pokazane jest jak otworzyć plik Mpeg4 ale co w przypadku jeszcze innych formatów takich jak np.: WMV, AVI, FLV czy innych? Poza tym będąc CAŁKOWITYM LAIKIEM W SPRAWACH OBRÓBKI DŹWIĘKU chciałem się upewnić czy mp3 dotyczy tylko plików audio? Jeżeli chodzi o obróbkę dźwięku to głównie chodzi o dźwięk w filmach więc audio-video ale filmy to np. wspomniany mp4 i tutaj pytanie o mp3, w Audacity można otworzyć tylko np. mp3 ale trzeba mieć odpowiednią bibliotekę, o mp4 i innych formatach nic nie jest wspominane w różnych samouczkach, jak to więc wygląda? Samo otwarcie pliku to nie wszystko, o ile wiem można nawet przekonwertować pliki innego formatu na mp3 ale ja np. chcę zachować film w formacie mp4, jak sprawa wygląda w Audacity?

PowerApps and Board games, my two favorite things : D

ClearCollect(CombinedCol,DropColumns(Ungroup(AddColumns(Coll1,'S_no',Filter(Result1,ID1=Value(Coll1[@ID]))),'S_no'),ID1)); hii i have 2 collections Coll1,Result1(has 2 columns ID1,Confirmation) in the CombinedCol The Confirmation column is empty. anyone please help me, its an urgent issue need to be solved

thanks you !!!!

Could we use this to then create a csv in Excel?

Spot on solution!

It seems so many of Power Apps maker really want to a solution to this problem. This works perfectly in standalone text input control but not if the control is part of a gallery, would you be knowing how to set up this in a gallery?

Hi, I tried to follow your tutorial but had no Success, I have a datacard called 'dcardSelectedUsers' with a combo box items = Choices([@'Users-DocLibApp'].Group). The SharePoint list 'Users-DocLibApp' has a column called 'Group' which is a multiple selected people column. I can see the selected users in the combo-box drop-down however, the label wont show the selected users. The fx syntax is underlined with red. When I type Value in the formula bar, the auto-complete wants to add a '(' after the word Value. What to do? Thanks

thx - worked for me

This is exactly what I'm trying to accomplish so thank you for taking the time to create this video. I've liked and subbed. But could you help explain how to do this within a form with the Default property of the input field is Parent.Default since it's getting it from a datacard?

Dzięki za ten trik z UpdateIf, mega się przydało mi :D

Hey, what if we have a text label not inside the same data card, a different container maybe

Hi, thanks for your video. You know if it's possible to do sums or other operations and using this text format?

What to do if next page is "Load More" and not page?

Hi! What to do when the last page has less data than the rest of the pages and gives me an error?

is this Switch fungtion can use for Search text in Tabbed Galley ?

stupid stupid stupid error

Great video, Only person I found online who explained what Entity1RelatedTable was actually looking for and showed the syntax. Thank you

Thanks a million for this. Also, your Do Until loop was simple to implement.

Is it also works with editor ?

Hi Thanks for this video ! I kept triggering errors on PowerApps. I put the code in ChatGPT and it told me there was a minor error by including the alias. ChatGPT suggested to write the code like this and it worked: //Join 2 collection together **Inner Join ClearCollect( colQuantitywithNames, DropColumns( Filter( Ungroup( AddColumns( colOrders, "tempRecordHolder", Filter( colBoardGames, ID = BoardGameID ) ), "tempRecordHolder" ), !IsBlank(ThisRecord.ID) ), "ID" ) ) Thank you again this video was very helpful; I am using a collection from SQL to create drop downs but I have NULLs in my table. This will help create a collection where I am not including the NULL values. Thanks !!!!

this is for only one control what if we use textinput control inside a gallery and on change if we write it displays for all records as the variable set to default

Thank you for the sharing. However, I want to ask if I am doing it in the form and have tried to submit the form. But when using the new form, the formatted data is not reset even though I have using the NewForm and ResetForm function. Can I know why?

Hi bro, thanks for this good content. I am also facing the same issue

Thanks, super helpful!

Man, thank you so much for making this video! I would never have been able to figure out this complex path to finding and eliminating the dependency for the column I needed to delete!

Was excited to try this but I'm getting an error where it says "Enter a valid boolean" and it will not let me save. Just thought you should know. Thanks

My flow was part of the solution, but lately there seems to be something weird going on when objects are both in the solution and not in the solution. Thanks to your tip I removed flow from solution and re-added and that fixed it. Thanks!

thank you my friend. I didn't know what to do here and this helped me a lot.

Super helpful 🙂. One question, though: what if the default property of the text input is a lookup?

What if we have a integer instead of null, will it be the same?

Hi Zbigniew, may I know how you make the mouse click on page 2 at first and automatically move to page 3 and so on, cause I only able to move 1 step (from page 1 to page 2) and it is stop moving and keep extract the data from page 2 after that......