Hi @Classy Powerapps, this is exactly what i need and thank you for sharing this great tutorial. Unfortuantely it is hard for me to follow if you keep skipping the important details. seeing the actual steps would be easier for us to follow and understand the concept. i hope you will take this positively, more power to your channel and i already subscribed and looking forward to your next content.
Thanks for your valuable feedback @Ralph Cabrera , i will keep this in mind and cover all the steps so that nothing will be missed in upcoming videos. Thanks Again !!
@classy PowerApps Great work, I have a question, How do you pass the Last Submit ID on NewForm, It should be a Edit Form, But on the Edit form we are unable to Add Attachment's..?
Hi @Prasad, we are submitting the newform only, and when the form is submitting we have the function .lastsubmit , And we are passing this lastsubmit function on the onsuccess event of form submission that's the reason it wouldn't be treated as editform and we get the ID of the record which is just saved in database using that function.
Variable value is coming from power app which is the ID of the list item where the excel file is uploaded as an attachment. In power App, i have used the form.lastsubmit function to get the last ID of the record which is stored into database.
Hi Classy, the app works, but it should be easier for everyone if you explain from the beginning, I mean, when you create a button, a table, the flow step by step, live, because you explain in this video what you did, but you don't show us step by step live how can do it, then its harder for us to create this app from our side while we watch the video, thanks
Hi, This is very useful. I have created the flow but I am not getting the response in PowerApps. I have used the respond action and generated the schema as well.
Try to check from the power automate whether it is sending the response to power app or not, if yes, then its all about the schema , check my another video for the same topic which explain the scheme configuration for this.
Thank you brother, I appreciate you replying to my comment. I got the solution, Power Automate was not sending the response to the PowerApps. The schema was not correct.
Hi, I wanted to fetch single column data from excel into powerapp Like i wanted to give Manager name and on submit button it should show all the employees reporting to that manager .... Can this be done in powerapp if yes how ? Please please help
lol🤣, Many people are coming with the same statement and solution is the same. In such type of problems we don't have know what can be the depth of the seniority, so start implementing the while logic in power automate. - we have direct connector available to find the counselees/reportees for any user, use that to find employee reports to him. then start writing them into the excel and later pick each row from the same excel and find its counselees and appends in the same excel, that's how you can get all people comes under one manager no matter whether directly/indirectly reporting to him or not. if you only need to find one level down employee that need not to use logic, directly user the connector. Hope that helps
Hi @Classy Powerapps, i'm really struggling to understand how you configure the import of the file and get the data from excel presented in the powerapp. Please provide more information of the import procedure
Hi Andreas , can you please check my another video on the same topic which i uploaded to support the functionality i implement inside it. If it can help somewhere.
Hi, You can call me Prashant (mentioned in the video). Well, Before the get attachment content, you might have found the get attachments for any list record, which returns the table , so get attachment needs to be present inside the apply to each step. Hope it helps
Could you please show. Get attachment content step in power automate... Want to see that stage... overall it's really helpful... I done this in my app differently
@Naveed Raza that get attachment content step is used to create the uploaded excel file into document library. At that stage, we are moving the list item attachment into document library, by filtering list item from ID coming from Powerapp and attachment identifier from get attachment connector.
For some time, I'm observing some pattern in the confusion in this video, so i m shorting publishing one more video which will explain some steps which i missed to emphasize in this video, Thanks for your query.
Hi,I need to create a button in my app to upload excel or csv data to my tblData sharepoint list inside the app. Like an Import button then it will open dialog box to choose the csv file then when the user hit Open it will save to the SharePoint list. Is that possible?
@INDIAN , you need to provide the template in the application , so that user can download the template into local system and upload data accordingly, It can help you to validate Excel
What are the steps you have added in the steps "Get attachment Content" inside apply to each. i'm getting error "The runtime value '"fSample%2bData.xlsx"' to be converted doesn't have the expected format 'Integer/int64'."
Check out the flow and find how many times you have clicked on Ask in powerapps accordingly pass the inputs. Else try re-adding of flow into powerapp or recreate the flow.
This is a very CLASSY solution thanks!
What will be the value of the initalize variable 1: RecordID ? because i am getting body , file content,id
so among these which one should i choose?
Hi @Classy Powerapps, this is exactly what i need and thank you for sharing this great tutorial. Unfortuantely it is hard for me to follow if you keep skipping the important details. seeing the actual steps would be easier for us to follow and understand the concept. i hope you will take this positively, more power to your channel and i already subscribed and looking forward to your next content.
Thanks for your valuable feedback @Ralph Cabrera , i will keep this in mind and cover all the steps so that nothing will be missed in upcoming videos.
Thanks Again !!
@@classypowerapps5169 Hi Sir, could you please make a full video for audiences, it is really hard to learn or understand your coding behind, Thanks
@classy PowerApps Great work,
I have a question, How do you pass the Last Submit ID on NewForm, It should be a Edit Form, But on the Edit form we are unable to Add Attachment's..?
Hi @Prasad,
we are submitting the newform only, and when the form is submitting we have the function .lastsubmit ,
And we are passing this lastsubmit function on the onsuccess event of form submission that's the reason it wouldn't be treated as editform and we get the ID of the record which is just saved in database using that function.
Thank you! This was incredibly helpful!
I'm so glad!
Hi Thank you for making this video I was looking for the same just need little more information on Power Automate part
Feel free to write or share on my linkedIn
Hi Can you explain how the value for variables in data flow were assigned pls. Thanks!
Variable value is coming from power app which is the ID of the list item where the excel file is uploaded as an attachment.
In power App, i have used the form.lastsubmit function to get the last ID of the record which is stored into database.
Hi Classy, the app works, but it should be easier for everyone if you explain from the beginning, I mean, when you create a button, a table, the flow step by step, live, because you explain in this video what you did, but you don't show us step by step live how can do it, then its harder for us to create this app from our side while we watch the video, thanks
@Sergio
Thanks for your honest valuable feedback. For the future videos , i definitely cover those things as well.
Hello, I was trying to make the app myself but I got lost a bit. Would you mind helping me out?
Hi @Classy Powerapps, Can you show step by step process of " power automate flow" creation
I have created the another videos which is the support for this, please check that too , it can help you
Hi, This is very useful.
I have created the flow but I am not getting the response in PowerApps. I have used the respond action and generated the schema as well.
Try to check from the power automate whether it is sending the response to power app or not, if yes, then its all about the schema , check my another video for the same topic which explain the scheme configuration for this.
Thank you brother, I appreciate you replying to my comment. I got the solution, Power Automate was not sending the response to the PowerApps. The schema was not correct.
I tried to follow your video and created my Own fllow, the only problem is that the "Response" action is now a PREMIUM connector
Hi,
I wanted to fetch single column data from excel into powerapp
Like i wanted to give Manager name and on submit button it should show all the employees reporting to that manager .... Can this be done in powerapp if yes how ?
Please please help
lol🤣, Many people are coming with the same statement and solution is the same.
In such type of problems we don't have know what can be the depth of the seniority, so start implementing the while logic in power automate.
- we have direct connector available to find the counselees/reportees for any user, use that to find employee reports to him.
then start writing them into the excel and later pick each row from the same excel and find its counselees and appends in the same excel, that's how you can get all people comes under one manager no matter whether directly/indirectly reporting to him or not.
if you only need to find one level down employee that need not to use logic, directly user the connector.
Hope that helps
Hi @Classy Powerapps, i'm really struggling to understand how you configure the import of the file and get the data from excel presented in the powerapp. Please provide more information of the import procedure
Hi Andreas , can you please check my another video on the same topic which i uploaded to support the functionality i implement inside it. If it can help somewhere.
what if we are working with the dataverse tables and not the sharepoint
Mr can you assist or give more details in power automate get attachment content step
Hi, You can call me Prashant (mentioned in the video).
Well, Before the get attachment content, you might have found the get attachments for any list record, which returns the table , so get attachment needs to be present inside the apply to each step.
Hope it helps
Could you please show. Get attachment content step in power automate... Want to see that stage... overall it's really helpful... I done this in my app differently
@Naveed Raza
that get attachment content step is used to create the uploaded excel file into document library.
At that stage, we are moving the list item attachment into document library, by filtering list item from ID coming from Powerapp and attachment identifier from get attachment connector.
@@classypowerapps5169Even I got stuck there.....but overall good Details
did you get the get attachment step sir
Hi @Classy Powerapps, i am not able to find attachment datacard in form as i have added document library for edit form source. Please help me
Please add any form of sharepoint list, then you can get the attachment, copy the control from there.
Hi classy do u have aa live video ...?
Plzzz share !
For some time, I'm observing some pattern in the confusion in this video, so i m shorting publishing one more video which will explain some steps which i missed to emphasize in this video,
Thanks for your query.
This video is helpful. Also, did u observe if the app will run slowly if the excel table has atleast 15-20 columns and a hundred of rows?.
This is great but can I update multiple tables at a time?
try adding the loops inside the power automate flow with the switch condition to handle multiple tables.
Hi,I need to create a button in my app to upload excel or csv data to my tblData sharepoint list inside the app. Like an Import button then it will open dialog box to choose the csv file then when the user hit Open it will save to the SharePoint list. Is that possible?
Not directly, that import expect the zip file which will be loaded into the collection then to sharepoint list for now
hi, great video, can you show the id and identifierer in 'Get attachment content* please?
It would be the dynamic content from the last step
Thanks man,can you also show can we validate uploaded Excel file ,like that it should contain only specified column
@INDIAN , you need to provide the template in the application , so that user can download the template into local system and upload data accordingly,
It can help you to validate Excel
@@classypowerapps5169 yeah I want to error out if user is uploading different Excel file
Hi. This is helpful. Question though, what is the maximum Excel rows that can be applied here when uploading to SharePoint List?
@Elijah, Thanks
well, honestly i don't know the maximum limit, but i have tried it with for 5k rows.
What are the steps you have added in the steps "Get attachment Content" inside apply to each. i'm getting error "The runtime value '"fSample%2bData.xlsx"' to be converted doesn't have the expected format 'Integer/int64'."
it seems some issues with your file , try again
I created the same flow and its taking forever to run how can you help
Could you please show. Get attachment content step in power automate
Yeah there's a flaw. The flow is not working, at least not anymore
Hi
Getting a error on unsuccessful of upload showing invalid number of arguments received 1 expected 2
How I can resolve this issue
Check out the flow and find how many times you have clicked on Ask in powerapps accordingly pass the inputs.
Else try re-adding of flow into powerapp or recreate the flow.
Hi sir, i'm not getting dynamic content for get attachment content id
Make sure you are finding it inside the apply to each.
This video is helpful. Also, Is there any other way when my account has no premium. Thanks
Yes, Shortly uploading the same
You could have shown the live video man
Sure, i definitely make the note of it. Thanks
Please show it live so that we can learn on the go