Thank you so much Eric. This is fantastic. Please one quick question. This works for me if there is only one prefix type (ABC-1), but if there are different types e.g. XYZ-1, etc in the same SharePoint List, if only works for the first prefix. Other prefix shows error message "cannot convert ABC-1 to number". Please can you help?
Really loved all three of these past 3 days of powerful Copilot tips and best practices! Thank you so much for sharing your expertise with us during the 25 Days of Copilots! 🥰 You are awesome!
Your video of as so comprehensive. Thabk you for sharing. However, I would love to know if I can patch an edit form and details of items in a Gallery into a dateverse table. The gallery and form are both on same screen
Yes, it actually the same formula. If I may ask, is the Gallery and form connected to the same Dataverse Table? If yes, then you can use same formula by changing the fields to the names in the textboxes on the form.
Do you think this can be used in a corporate Bank where they want to make it easier for customers to make loans and keep track of the loan details for each customer in power apps? Is that efficient for power apps? And do you have any knowledge or videos about something similar
Power Apps is very dynamic and could be employed in several business scenarios including loan management in a bank setting. I having come across a video on that but it is definitely doable with power apps
The correct is printing the error itself in the notification, not a generic message "Things didn't go well" because that doesn't help in anything to inform and fix the error.
Thank you for the video. Could you please share a copy of the app with us? It will be good to have the app and a copy of the data you made and check them out ourselves.
Hi Eric, Thank you so much this amazing video. This solution helped a lot in one of my problem statement. I need your help in one of the scenario where , I need to generate autogenerated number. The Scenario is , when i click on a button it will navigate to next page and this next page contains a submit form and has 5 fields among those one is "Auto generated number" field , current date and time field and creator name(In this case my name ). So for this auto generated number there are some conditions: 1) it contains the current year and a unique number . Suppose my last auto generated number was 22-003 , where 22 is current running year(2022-> 22) and a unique number , so if a new from will appear on a button click this auto generated number should be 22-004. 2) If suppose , the current year (2022 ) is going to end and new year (2023)is going to start, so for this new year , the auto generated number should be 23-001 for the first entry. kindly help on this scenario, Thanks.
Hi Eric, thank you for the instructions. For my app I want to reset the numbering daily. For example, on day 1 the ID would be 0101 0102... next day it would be 0201 0202... Do you have any suggestion on how to do that?
Thanks for the request. I would get back to you but can you explain the logic behind. example if the first 2 digits represent the Day, what does the other numbers represents. 0202 and 0102
@@ericentsie4015 the latter 2 digits are just the numbers that auto-increment per each ID. I got it done already (modifying your code a bit). I added one Filter function inside the Sort one. There I compare the current day with the created IDs. If they match the increment goes on, if not the counting starts over from 1. It's a bit long but at least it works. Please let me know if you have better solutions.
Is there a way to write something in data if i activate checkbox, or erase if i uncheck it? Something I would work for attendance while calling out my students, or checking what days some problem occorr.
thanks you Eric , great work. this is coming from id autoincremented column. But If i create a variable to generate 4 to 5 digit length and add a prefix to it, this result in an invoice number that I increment by 1 everytime I press new form . in my case this number is created and consumed regardless of I created / saved a record or not. Can you please tips me how I can conserve used invoice number in my case and the generated invoice is consumed when I save it to data source.
Thanks Eric. Great explanation of using Patch to combine with a checkbox control in the Gallery to add multiple records to a table via a collection. These are some interesting concepts. Thanks for sharing in this tutorial.
