This is helpful. How could I default the Approver, so that the user can only choose from the default list instead they type in the approver name?
@RamjithMadhu-b6w Жыл бұрын
How to filter the dates? Could you be a little more elaborate on what exactly you're doing in reach of the blocks. I'm trying to replicate the same but I'm new to power automate.
@nguyenthach8103 Жыл бұрын
How can I do like this with PowerAutomate?
@KrishnaRachakonda Жыл бұрын
Power Automate may need lot of action to accomplish it and also, it may or may not be as easy as we can do it from Power apps.
@evertjanheikoop15 Жыл бұрын
What does the AddDays(...) code looks like, i was wondering since i am trying to create it this way but i keep getting errors
@katushka1999 Жыл бұрын
Thank you for the great video, but I'm really stuck and need more help 🥺 Is there a way you can export the app or send me just the code because not everything is shown in the video? Thank you in advance!
@KrishnaRachakonda Жыл бұрын
I do not have the app any more. This was an old video. if you have any questions, send me an email [email protected]
@nikkijoy226 Жыл бұрын
I get an error immediately varApprovers and it won't show up when I type it. Is the variable defined somewhere else or is it only in the ClearCollect? Thank you for your response
@yehunlavolontededieu322 Жыл бұрын
why reengine the whole power automate function in PowerApps? IF this could be done in flow easily why invest all this? But at least you could provide the code in description why everyone has to ask for the code...Too much unnecessary hassle on top of it I can't even imagine putting all this effort and finding out it doesn't work , at latest if code is was provided it does help to quickly get it done ....but thanks anyways. Pls next time post the available resources /code especially this too long one is pain in ass not everyone is coder like you
@KrishnaRachakonda Жыл бұрын
Flow has its own limitations - API Call limits, 28 day history, Task management and so on. This video provided an alternate approach. This approach was implemented for a specific use case. You do not have to use this approach if your approval process is simple. I understand your pain with video. This was my oldest video and I do not have code for this anymore. The video was created to share the users that there is an alternate approach but not to share the code. I will make this video private so that no user run into the issues you came across. This application is actively being used by the customer even today. Unfortunately, I cannot access their tenant to get the code. Appreciate your feedback.
@yehunlavolontededieu322 Жыл бұрын
@@KrishnaRachakonda thanks for the speedy response . Understood now , I didn't know you don't have the code
@user-wethe9 Жыл бұрын
geez, did you pay him for this video? Don't take things for granted and stop whining
@VictoriaTerzieva Жыл бұрын
Hi, I was wondering if your code was uploaded somewhere because not everything is visible in the video?
@KrishnaRachakonda Жыл бұрын
The code is not uploaded anywhere. Sorry for the trouble. I built more sophisticated approval process and will share the video sometime soon.
@StephanOnisick2 жыл бұрын
Can you provide an example table of the URLs working. I can get another Screen in the project to work from the detail lines but not a URL. Also, when I made my SharePoint "IsHeader" to a SharePoint "Yes/No" column, I had to change the filter to IsHeader = true. Thanks for the lessons in PowerApps I'm getting building this component.
@StephanOnisick2 жыл бұрын
Why is the FooterHeight OutPut? How does the hosting Screen use this data?
@StephanOnisick2 жыл бұрын
Really Excellent Tutorial. I had to watch 4 times to understand the Y of the Component.
@StephanOnisick2 жыл бұрын
Nice Component!
@dtodounpocomx_nl2 жыл бұрын
You are not explaining where colTechnology collection is set, I mean, where are you assigning values to that collection ?
@KrishnaRachakonda2 жыл бұрын
May I know if you still need help on this?
@palikaanusha30432 жыл бұрын
Yes mine also same doubt, please can you in that
@dtodounpocomx_nl2 жыл бұрын
@@KrishnaRachakonda yes please create another video clarifying that part
@aakashsaxena85182 жыл бұрын
Can you help me to create a weekly report from Dynamics 365 report (Excel) and i want to share it on sharepoint in excel format file
@PastulioA2 жыл бұрын
amazing video!!!!! THANK YOU!! THANK YOU!!
@KrishnaRachakonda2 жыл бұрын
Glad it helped!
@geetikabajaj96772 жыл бұрын
Wonderful Video
@KrishnaRachakonda2 жыл бұрын
Thank you very much!
@Thedancers882 жыл бұрын
how could we display like right to left, first checkbox and then text. if working on arabic
@timwaldau16492 жыл бұрын
Hello Krishna, great Job well done! ...could you please give me a hint to install your component? I'm trying to import it as component but I received an error (to import from component libraries, store your library files in the cloud ....) Thank you very much Mr. Rachakonda
@nolanfalcon12 жыл бұрын
Hello Krishna, how can the 3 approvers be static and how can each approver add their signatures as it goes through the approval process? In my case all the three approver would be the same for this approval process...finally, can I add the requestors name to automatically be added in the cc field and have a submission acknowledgement? Thank you Sandy (using Hubby's acct). Thank you!!!
@KrishnaRachakonda2 жыл бұрын
If the approvers are static, you can maintain them in a SharePoint list and refer them from the Power App everytime you are assigning a task. Absolutely, you can add requestors name automatically be added in the CC field.
@nolanfalcon12 жыл бұрын
@@KrishnaRachakonda Thank you Krishna! may I humbly ask if they are any tutorial videos that you can recommend that can walk me through it? Thank you for responding! Sandy
@maheebasyed59832 жыл бұрын
Where can I get tutorials of these plz
@KrishnaRachakonda2 жыл бұрын
If you follow other videos in the channel, you can see how we can create the apps.
@maheebasyed59832 жыл бұрын
@@KrishnaRachakonda all of them are private
@KrishnaRachakonda2 жыл бұрын
@@maheebasyed5983 Please check again. Also, you can check the videos from my site krishnarachakonda.com/video-blog/
@vennaarjunprabhakar58342 жыл бұрын
Thanks Sir, Great Video 🙂
@CaptCJ19692 жыл бұрын
Hi Krishna, I'm trying to implement and have a couple of questions. 1 - I'm not seeing the creation of the ColTechnology Collection within my app 2 - At 10:44 the OnVisible I already have in here "Collect(Collection1, 'Main Form'.Current) to bring in all the form data, how should I get the ClearCollect(ColSelectedTechnology,LookUp(Training,ID=ItemID).Technology) to interact 3 - I'm seeing an error on the datacard in the Update field with ColSelectedTechnology Thanks in advance Craig
@FazilA2 жыл бұрын
Great to see your video 😊
@saivasili46452 жыл бұрын
Sir, is it possible to connect you personally, need to run weekly status report in power automate filter. We have used for filter row Cre6_delivery manager eq to abc and state code eq 0 Could correct query if anything required to change
@saratchandra73883 жыл бұрын
Hi can we send multiple items or bulk items for approval from powerapps through powerautomate?
@mtamitolanga3 жыл бұрын
Thank you for the video!! How do I make sure that approvers only see the item they supposed to approve in the library, in a case where I have multiple items in progress that is being processed by other approvers. Only see what you suppose to approve. Thank you
@divyanair61473 жыл бұрын
Hi Krishna, Great video and well explained. I am having some issues with creating new item as the checkboxes are selected from the last item created in the Gallery. The checkbox gallery isn't cleared when hitting Add new button.
@kawtarbenkaddour89063 жыл бұрын
i have a problem, when i receive the excel file one item is repeated several times ?
@yojie1203 жыл бұрын
Hi! thanks for your helpful video. The filter query in the Get Items doesn't seem to work. Where should i get the correct source field (OrderDate) from?
@kawtarbenkaddour89063 жыл бұрын
same problem
@kevinmoore87332 жыл бұрын
Turn on - Turn on Power Automate Experimental Features
@mahalakshmi14043 жыл бұрын
Hi thanks for the information..I want to hide the another text input control based the selected value in this checkbox (inside gallery).. what should I writ in the visible property of that text input
@chetansoni1393 жыл бұрын
Sir whats this "Clean weekly report" Step ? is it a Condition? or any other operation? didn't get it by it's icon!
@chetansoni1393 жыл бұрын
ok now i got it! it's the "Scope" Operation in condition sir can you please let us know the Exact Expression in "Clean weekly report">"condition" how it's checking the Empty row or deleting the rows value.
@KrishnaRachakonda3 жыл бұрын
@@chetansoni139 Here is the expression: length(body('List_rows_present_in_a_table')?['value'])
@mickmartin51533 жыл бұрын
Great video, well explained and easy to follow, Thanks! Can you please help? I am trying to adapt this for use with a Customized SharePoint Form. I'm having an issue @10:29 getting the ID of the current selected SharePoint Item, as i can't get the ID from a different screen as in your video. Any tips would be greatly appreciated, thanks.
@KrishnaRachakonda3 жыл бұрын
@Mick, I am passing the Item ID from one screen to another screen within Navigate function. Ex: Navigate(<screen name>,<loading pattern>,{ItemID : ThisItem.ID}). In this function, ThisItem.ID refers to the SharePoint List Item's ID value. I hope this helps you.
@kulwinderrehal26882 жыл бұрын
@@KrishnaRachakonda What should we pass here if we are editing straight from Sharepoint instead of PowerApps?
@JulioBernal37122 жыл бұрын
@@KrishnaRachakonda I’m stuck here. Cannot figure out what ItemID is. Help pls
@CHAMONIX5522 жыл бұрын
@@kulwinderrehal2688 Same situation, wondering how to get selected item id
@michellekelly1704 Жыл бұрын
@@KrishnaRachakonda is there an answer to the question about ID=ItemID? ItemID is not valid, so what can we replace in this formual fir ItemID? ClearCollect(colSelectedTestbeditems,LookUp('Activity Tracker',ID =ItemID.'Test Bed Items'))
@ammarhaider2213 жыл бұрын
Hi Krishna, Thanks for making a video. this looks cool! just wondering how we are restricting the form for the specific approvers? like first approver is Smith but Krishna is approving. this shouldn't be the case right? is there a way to restrict on app load if it is not the intended approver? otherwise anyone having the link to this approval page can approve even the requestor. Just let me know the event name where we have to write the if logic to check user() with the current approver from datasource
@KrishnaRachakonda3 жыл бұрын
Thank you for reviewing my solution. Here are few recommendations: 1. When you open the Power App in the studio, you can see App in the left nav. You can define your logic for user in onstart property (OR) 2. SharePoint Integration also has properties OnEdit, OnDisplay, OnNew. Based on your requirement, you can define user check in respective properties and Navigate to appropriate screen if the current user does not match with Task Assigned user (OR) 3. On the screen's Onvisible property also you can check and navigate away if the user does not match with Assigned To user.
@ammarhaider2213 жыл бұрын
@@KrishnaRachakonda awesome! Thanks will try this.
@dileepsyed74023 жыл бұрын
hi Krishna great suggestions thank you. i looking approval system where we can send approval for multiple members using conditions. need your assistance.
@KrishnaRachakonda3 жыл бұрын
It is possible. provide your contact info by submitting the form: tinyurl.com/contactmesk
@maorifulla3 жыл бұрын
Out of all the videos on KZbin describing this functionality, this was by far the easiest to follow and the most eloquent solution. Ka tino pai rawa atu ki a koe! (Māori for you're awesome!)
@KrishnaRachakonda3 жыл бұрын
Thank you Eddie. Happy to know that this video was helpful.
@MustafaFarooq3 жыл бұрын
How much time does it take to build an approval app like this ?
@KrishnaRachakonda3 жыл бұрын
if you have all requirements finalized, then it should take 12 to 16 hours to build & validate the process max.
@richardares32553 жыл бұрын
Great suggestion! I have been playing around with several approaches for approval in recent weeks. I always hit a problem when I must consider the situation where the file being approved is modified mid-process. If I want to secure document coherence, I must manage that. The internal approval functions in SP do that with versioning. Is there a way to add that to your solution without using PA?
@vijaymalwin49203 жыл бұрын
Awesome, Krishna. Want to know couple of possibilities here: 1. Can we add the next 7 days extract, in the beginning and push the existing data below? 2. Can we insert new worksheet and name it by date range? Let me know. Thanks very much!
@gerfer62613 жыл бұрын
👍
@USMCProbie3 жыл бұрын
This works but I have Versioning on my Sharepoint List. How do I get only the Most Recent Version to populate in my table?
@elvismakuthi3 жыл бұрын
This is great however i have followed all the steps but Patch is having an error on completed approver,' indicating its expacting a Record and its getting a table"
@zafikamanzi66952 жыл бұрын
Hi Krishna I am also receiving this error. @Elvia did you come right with this?
@morygold4 жыл бұрын
always there is a problem with the variable varApprovers where did you declare it and how can you show me
@KrishnaRachakonda4 жыл бұрын
Send me an email to [email protected] . Will send the code snippets.
@AbhishekMishra-dg3dz3 жыл бұрын
Hi can you please help with the code..
@morygold4 жыл бұрын
you are the best , thanks alot for the effort made
@KrishnaRachakonda4 жыл бұрын
Check my other video for complete internal details of the approval process implementation. kzbin.info/www/bejne/i2a5qHWoitF8isk
@yehunlavolontededieu3224 жыл бұрын
So, what's the point going through without showing the real deed? I was here to see how you've achieved that not to see the cooked meal...waste of time
@KrishnaRachakonda4 жыл бұрын
I will post another video to show the logic or a blog. Thank u for the comment.
@KrishnaRachakonda4 жыл бұрын
Please check the video kzbin.info/www/bejne/i2a5qHWoitF8isk and let me know if you have any questions.
@joedunton7037 Жыл бұрын
Waste of time!
@ingridschiele14754 жыл бұрын
Hi Krishna, great video thanks. I have just one question left: Where is the logic of the workflow implemented? Where do you put the item and list modifications into? I'm a little bit confused about that.< Thanks, Ingrid
@KrishnaRachakonda4 жыл бұрын
I will post another video to show the logic or a blog. Thank u for the comment.
@KrishnaRachakonda4 жыл бұрын
Please check the video kzbin.info/www/bejne/i2a5qHWoitF8isk and let me know if you have any questions.