So far I've only listened to your lead-in for this video but I just have to comment. I'm formulating a Canvas App / Power Automate tool and wondered, "Maybe Shane has something on this." What you said in the lead-in is exactly what I want to do! Simpatico. Keep up the great work. And now I will watch the video.
Hi Shane, thanks a lot! Is it possible change the column Title to not required and remove from the listview, using automate? I tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...
Daniel my guess is yes but I have never tried. I imagine you would have to do a Merge action and set the required flag to false. Try searching the web for how to make a column required with the API and then do the opposite. :) I am sure you figured that out but it is best I have off the top of my head.
just an FYI , getbytitle('All Items') has a whitespace, but its not clear because of the text wrap in the video, thanks Shane , this was helpful and saved me time.
Fantastic stuff! I spent more time than I'd care to admit digging through the various documentation on this (specifically the SP HTTP request details/syntax) over the last few days for another project. There are some specifics (e.g.: how to make a "date only" date-time field, or a "person or group" person field) that were a pain to figure out.
Yes, you can create the columns. You have to make the REST API calls. You would post to _api/lists/getbytitle('ListName}')/fields The body would then look something like this { '__metadata': {'type':'SP.FieldText'}, 'FieldTypeKind': 2, 'Title': 'FirstName' } That would create a Text field named FirstName. If you sign up for my 201 training class you get the full flow that creates a whole list with a lot of different field types. training.powerapps911.com/courses/powerapps-and-flow-for-app-builders
@@ShanesCows thank you kindly for the detailed response. What I meant to ask is if you can actually populate the columns too, like add actual records to each of them from power apps. Your video showed how to create the list with columns but not how to add data to it from power apps. Is that cover in your training maybe?
Yes. You would use the flow action create item to add to the SharePoint list. Yes, my 201 class talks a lot about flow and SharePoint. You also get access to office hours where you can ask a question each month. 😎
Thanks for the video. Would this concept work for connecting azure active directory data with power apps to SharePoint list? Doesn't seem to be clear info to pull from AAD to build, say, a staff directory with AAD meta data.
To get Azure AAD info you could either try using the Azure AD or Office 365 Users connector. If they return the data you want great! If not you would need to query the Graph API to get it
Good job Shane, I'm learning a lot from your videos! A question: could it be possible to create a set of different lists for each user of the app? I mean, instead o sharing my app and 20 lists for every user of the app, on the first run of the app, create the requiered lists in the user sharepoint site. Thanks.
@@ShanesCows How would you go about doing this? Would it be in the first Http to Sharepoint? I've been trying to figure out how to edit a current list's columns for awhile. Do you have another video on this topic I could watch?
Hi Lat! i have a question. Did you solve your issue. i want add new column to my current list with powerapps as him made. Can you help me? i didnt make it ;//
So create the list and then add it to dynamically to the app? No :( You could create the list and then tell Power Automate to use it. So instead of Power Apps reading/writing the list have Power Apps send it to flow and let flow do it. It can have a Dynamic list name.
Shane, you are awesome.. thanks a lot! Do you know how to change the column Title to not required and remove from the listview, using automate? i tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...
To anyone who had this problem, it is a dropdown menu within the properties. Go to Value and select you will see two options: JSON and Title --> Select Title
My question is how this would be useful? Wouldn't it be better to make a SharePoint list in SharePoint? I'm total newbie so I apologize if this is a ridiculous question :)
It is easier in SharePoint for sure. 😎 What we see though is people want to automate it. So everytime a new project gets added automatically create a list. Automation is the key.
Hello thanks for this Advanced tutorial its awesome! if a build this app and a ADM-User can create Lists, How i can made those created lists by powerapps appear in this app, to show for other user answer the list and input information
I found the answer here: docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ee540543(v=office.14) I used FieldTypeKind 15, for a "MultiChoice" field type.
Hi Shane, this is probably what you might call a stupid question, but I'm starting literally from scratch, and there's one thing I just can't figure out, or find info on, or get an answer for from my team. I have a brief on what the app needs to do. I have to build sharepoint lists from which the app will be generated. My question is, how do I build a sharepoint list that will result in the app I need. Is there any info on sharepoint list structures for power apps? Any tutorials that start from the list building phase, that explain the fundamentals of what list structures will translate to which app structures/functions? Like, is each list a new page in the app? In power apps I see screens, forms, datacards, what are these components, what do they do, how do I write them into a list? Any help on this would be greatly appreciated, thanks!
A SharePoint list is a data source for Power Apps. You can connect as many SharePoint lists into your app as you want. But adding a SharePoint list to your app doesn't create anything in Power Apps. So your list design in no way makes Power Apps do anything special. You have to add the controls in Power Apps you want and then connect them to your SharePoint list. Maybe check out my free getting started class to walk you through building that first app? training.powerapps911.com/courses/power-apps-and-power-automate-getting-started
Hi Shane, i am following your videos and it was very helpful to me. Thanks for the videos. I have one doubt here, How can we validate if list name already exist?
All works fine and perfect. However, newly created list is not displayed by default in Quick Launch. Any chance of updating the flow to enable the List automatically being displaced?
You're my hero, Shane! Is there a way to update a list item using Power Automate without knowing the item's ID? I want to kick off a flow when an item is created in list A, then using key information from the item created have the flow create an item with the same information in list B.
Hello, from Belarus) I’m sorry about the off-topic question, but maybe you’ve had this problem or know something about it. While reducing the width of the button, the text is offset, maybe you know how can I solve this problem?
I put the right URL but UA-cam is breaking it. Maybe this one works? docs.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245640(v=office.15) If it doesn't when you clik on the one in the description add a ) to the end and it works. :)
hey, this is awesome as always! Just downloaded the app but upon running it - Type of Column do not display any choices to chose from... any idea why or is it just me (which is very possible)?
Shane if I was a millionaire I would hire you as my personal JESUS-CHRIST BECAUSE YOUR WORK IS UNBELIEVABLE AND A MASSIVE THANK YOU FOR YOUR VIDEO FOOTAGE INFO ECT AND MERRY CHRISTMAS AND HAPPY NEW YEAR.
Hey Shane! I really really like your videos! You have really helped me many times. This video has also helped me a lot with my current project. Unfortunately I can't get any further now. Maybe you can help me. My problem: I have to develop inventory software in Power Apps for a customer that is completely modular. This means that the user can define categories and fields himself (I have already done this first step - automatically creating Sharepoint lists with your video). Now I'm faced with the problem that I can't find a way to add the SharePoint lists as a dynamic data source during runtime - to use the created SharePoint lists in a meaningful way in the Power App. Do you know a way how to implement that? With kind regards Mr. Zauner
Hello, I have rebuilt the great app and flow, and everything worked fine until the last step :/ The list gets created in SharePoint and the columns are there, too. Does anyone have a tip what I'm doing wrong? The error is: "status": 400, "message": "The specified view is invalid. Thanks in advance {"host": { "connectionReferenceName": "shared_sharepointonline", "operationId": "HttpRequest" }, "parameters": { "dataset": "", "parameters/method": "POST", "parameters/uri": "_api/web/Lists/getByTitle('ALister')/views/GetByTitle('All Items')/ViewFields/AddViewField('day')", "parameters/headers": { "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" } } } Solution: My SharePoint is in German and so the Title is "Alle Elemente" and not "All Items" "parameters/uri": "_api/web/Lists/getByTitle('Alister2')/views/GetByTitle('Alle Elemente')/ViewFields/AddViewField('day')",
So far I've only listened to your lead-in for this video but I just have to comment. I'm formulating a Canvas App / Power Automate tool and wondered, "Maybe Shane has something on this." What you said in the lead-in is exactly what I want to do! Simpatico. Keep up the great work. And now I will watch the video.
Thanks. That is the goal, give you videos that solve your real problems.
Hi Shane, thanks a lot!
Is it possible change the column Title to not required and remove from the listview, using automate?
I tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...
Daniel my guess is yes but I have never tried. I imagine you would have to do a Merge action and set the required flag to false. Try searching the web for how to make a column required with the API and then do the opposite. :) I am sure you figured that out but it is best I have off the top of my head.
just an FYI , getbytitle('All Items') has a whitespace, but its not clear because of the text wrap in the video, thanks Shane , this was helpful and saved me time.
Happy to help and thanks for the tip.
This is good stuff. I am love it! Keep them coming.
Thanks, will do!
Shane, this is 👍 great.wow! Weldone
Thank you! I was really excited when it was done. 🐶
Fantastic stuff! I spent more time than I'd care to admit digging through the various documentation on this (specifically the SP HTTP request details/syntax) over the last few days for another project. There are some specifics (e.g.: how to make a "date only" date-time field, or a "person or group" person field) that were a pain to figure out.
Yeah. It is a dark hole you can get lost in. 😎
Hi Shane! Is it possible to create the list and also add a few records to it? Not just columns? If so, can you please give me general guidance
Yes, you can create the columns. You have to make the REST API calls.
You would post to
_api/lists/getbytitle('ListName}')/fields
The body would then look something like this
{
'__metadata': {'type':'SP.FieldText'},
'FieldTypeKind': 2,
'Title': 'FirstName'
}
That would create a Text field named FirstName.
If you sign up for my 201 training class you get the full flow that creates a whole list with a lot of different field types. training.powerapps911.com/courses/powerapps-and-flow-for-app-builders
@@ShanesCows thank you kindly for the detailed response. What I meant to ask is if you can actually populate the columns too, like add actual records to each of them from power apps. Your video showed how to create the list with columns but not how to add data to it from power apps.
Is that cover in your training maybe?
Yes. You would use the flow action create item to add to the SharePoint list. Yes, my 201 class talks a lot about flow and SharePoint. You also get access to office hours where you can ask a question each month. 😎
Hi Shane, is there a way to have an excel template to new sharepoint list with power automate?
you are a legend mate
Thank you. 😎
Thanks for the video. Would this concept work for connecting azure active directory data with power apps to SharePoint list? Doesn't seem to be clear info to pull from AAD to build, say, a staff directory with AAD meta data.
To get Azure AAD info you could either try using the Azure AD or Office 365 Users connector. If they return the data you want great! If not you would need to query the Graph API to get it
Awesome sauce shane
Thanks 😊
This is great, is there a way to also set an app to then use the generated list as a data source?
is there a way that created list automatically adds to data source?
@@elvispresliss I really want to know that!
Good job Shane, I'm learning a lot from your videos! A question: could it be possible to create a set of different lists for each user of the app? I mean, instead o sharing my app and 20 lists for every user of the app, on the first run of the app, create the requiered lists in the user sharepoint site. Thanks.
Not really. Having dynamic data sources isn’t really a thing. You could do it but it would be super complicated and involve lots of flows.
Brilliant as always Shane. Would this apply to simply adding a new column to a current list?
Yes, the json would be the same for adding to an existing list. 😎
@@ShanesCows What about deleting a list?
@@ShanesCows How would you go about doing this? Would it be in the first Http to Sharepoint? I've been trying to figure out how to edit a current list's columns for awhile. Do you have another video on this topic I could watch?
Hi Lat! i have a question. Did you solve your issue. i want add new column to my current list with powerapps as him made. Can you help me? i didnt make it ;//
Can you plz send me the test you used at 7:45?
This is great! Is it possible to add this list to power apps as data connector using power automate?
So create the list and then add it to dynamically to the app? No :( You could create the list and then tell Power Automate to use it. So instead of Power Apps reading/writing the list have Power Apps send it to flow and let flow do it. It can have a Dynamic list name.
Hi there, just wondering if there is a way to remove the requirement of the Title Field via Power Automate?
Shane, you are awesome.. thanks a lot!
Do you know how to change the column Title to not required and remove from the listview, using automate? i tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...
My type of column dropdown box is only showing the metadata. It won't show me the titles of the choices.
To anyone who had this problem, it is a dropdown menu within the properties. Go to Value and select you will see two options: JSON and Title --> Select Title
Thanks for sharing.
My question is how this would be useful? Wouldn't it be better to make a SharePoint list in SharePoint?
I'm total newbie so I apologize if this is a ridiculous question :)
It is easier in SharePoint for sure. 😎 What we see though is people want to automate it. So everytime a new project gets added automatically create a list. Automation is the key.
@@ShanesCows yeah that makes sense, didnt even think about the automation part, now i understand. Thank you Shane!
Hello thanks for this Advanced tutorial its awesome! if a build this app and a ADM-User can create Lists, How i can made those created lists by powerapps appear in this app, to show for other user answer the list and input information
Hello,
How many no. of collection we can create in the a Poweapps? (Maximum)
I am working with SQL table having huge data.
I don't know. I haven't found a maximum. It will depend on Browser resources (memory) and when your browser crashes from too much data.
Is there a property that I can use to enable "allow multiple selections" for choice fields?
I found the answer here: docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ee540543(v=office.14)
I used FieldTypeKind 15, for a "MultiChoice" field type.
Hi Shane, this is probably what you might call a stupid question, but I'm starting literally from scratch, and there's one thing I just can't figure out, or find info on, or get an answer for from my team. I have a brief on what the app needs to do. I have to build sharepoint lists from which the app will be generated. My question is, how do I build a sharepoint list that will result in the app I need. Is there any info on sharepoint list structures for power apps? Any tutorials that start from the list building phase, that explain the fundamentals of what list structures will translate to which app structures/functions? Like, is each list a new page in the app? In power apps I see screens, forms, datacards, what are these components, what do they do, how do I write them into a list? Any help on this would be greatly appreciated, thanks!
A SharePoint list is a data source for Power Apps. You can connect as many SharePoint lists into your app as you want. But adding a SharePoint list to your app doesn't create anything in Power Apps. So your list design in no way makes Power Apps do anything special. You have to add the controls in Power Apps you want and then connect them to your SharePoint list. Maybe check out my free getting started class to walk you through building that first app? training.powerapps911.com/courses/power-apps-and-power-automate-getting-started
Hi Shane, i am following your videos and it was very helpful to me. Thanks for the videos.
I have one doubt here, How can we validate if list name already exist?
You would have to try to get the list first. If that errors then you know it is safe to create, if it doesn't error then you need to have a plan b.
All works fine and perfect. However, newly created list is not displayed by default in Quick Launch. Any chance of updating the flow to enable the List automatically being displaced?
Thanks Shane
You are welcome Sundra! 🐶
can you do that through Graph Api ?
I would assume yes but have never looked. ChatGPT might be a great tool to ask.
You're my hero, Shane!
Is there a way to update a list item using Power Automate without knowing the item's ID? I want to kick off a flow when an item is created in list A, then using key information from the item created have the flow create an item with the same information in list B.
Hello, from Belarus) I’m sorry about the off-topic question, but maybe you’ve had this problem or know something about it. While reducing the width of the button, the text is offset, maybe you know how can I solve this problem?
Sorry, not sure on that one.
Outstanding as always! One request... Can you fix the Microsoft docs link in the description please? It doesn't work... Thanks very much!
I put the right URL but UA-cam is breaking it. Maybe this one works? docs.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245640(v=office.15) If it doesn't when you clik on the one in the description add a ) to the end and it works. :)
@@ShanesCows That worked! Thanks for the quick reply.
Hi! loved your video, already subscribed. I didn't understand though what does the "Send an HTTP request to SharePoint 3" is supposed to do?
hey, this is awesome as always! Just downloaded the app but upon running it - Type of Column do not display any choices to chose from... any idea why or is it just me (which is very possible)?
Ha! Got this sorted. There was double space in the "SortByColumns(colFieldTypes,"Title")" between colFieldTypes, AND "Title"
Shane if I was a millionaire I would hire you as my personal
JESUS-CHRIST BECAUSE YOUR WORK IS UNBELIEVABLE AND A MASSIVE THANK YOU FOR YOUR VIDEO FOOTAGE INFO ECT AND MERRY CHRISTMAS AND HAPPY NEW YEAR.
Thanks Paul 😂🤪🔥❤️🐶
Hey Shane!
I really really like your videos! You have really helped me many times.
This video has also helped me a lot with my current project. Unfortunately I can't get any further now. Maybe you can help me.
My problem: I have to develop inventory software in Power Apps for a customer that is completely modular. This means that the user can define categories and fields himself (I have already done this first step - automatically creating Sharepoint lists with your video). Now I'm faced with the problem that I can't find a way to add the SharePoint lists as a dynamic data source during runtime - to use the created SharePoint lists in a meaningful way in the Power App.
Do you know a way how to implement that?
With kind regards
Mr. Zauner
I'd love to know this as well. Or if you found a way to do it ?
Heyy ! i want to add New column to my current list. But i dont know how i should do ;// can you help me?
Shane Young
How to create people picker column
Cool thing
Thanks!
this is cool, but most people won't want to bother watching. You should start of saying why you'd do this. Why even use sharepoint?
Thanks Doug. I agree, this one is awesome but the nerdy stuff never gets as many views.
😳What?
PRetty cool stuff. :)
Hello, I have rebuilt the great app and flow, and everything worked fine until the last step :/
The list gets created in SharePoint and the columns are there, too.
Does anyone have a tip what I'm doing wrong?
The error is:
"status": 400,
"message": "The specified view is invalid.
Thanks in advance
{"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "HttpRequest"
},
"parameters": {
"dataset": "",
"parameters/method": "POST",
"parameters/uri": "_api/web/Lists/getByTitle('ALister')/views/GetByTitle('All Items')/ViewFields/AddViewField('day')",
"parameters/headers": {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose"
}
}
}
Solution:
My SharePoint is in German and so the Title is "Alle Elemente" and not "All Items"
"parameters/uri": "_api/web/Lists/getByTitle('Alister2')/views/GetByTitle('Alle Elemente')/ViewFields/AddViewField('day')",
Thanks alot! I had the same problem for days and finally got it to work thanks to your tip