This is what I was looking for, Shane ! I really appreciate your efforts. Thanks to you! Tips: + Two underscores before the metadata. + If you want to recover the list, send an HTTP request with the same parameters, adjusting : 'Hidden':false, 'NoCrawl':false
@ShanesCows Жыл бұрын
Thanks for sharing
@mrstevennewmanEDU Жыл бұрын
I so should have read this comment.
@bartoszwisniewski8042 Жыл бұрын
Great tips, thank you :)
@elinagash13 жыл бұрын
As usual your videos are excellent. You can also do this in two steps without FLOW. 1. through the SharePoint designer in list settings Check the option - hide from browser 2. in list settings set Allow items from this list to appear in search results? NO
@ShanesCows3 жыл бұрын
Thanks for sharing! :)
@komanglayang78612 жыл бұрын
Can you please elaborate more on how to achieve this? I can't seem to find the Sharepoint designer in list settings
@nandhakumar6480 Жыл бұрын
Hi Where i can see point number 2
@NKBobcat3 жыл бұрын
In the past I always had to use a rest call to do this and was always worried about breaking things. This is much easier and explains it well! Thank you Shane! 😁
@ShanesCows3 жыл бұрын
Glad it helped!
@volkersteltenkamp35543 жыл бұрын
Thanks for the video, great as always. Just tested this and noticed that it is important to write "IF-MATCH" and "MERGE" in uppercase characters. Otherwise you will receive an error stating the the "__metadata" (yes, you have to use two underscores!) parameter does not exist is the getByTtitle method!
@ShanesCows3 жыл бұрын
Great tip!
@aliendb3 жыл бұрын
I have spent a day troubleshooting this error. thought I posted a message here yesterday but - who knows... seems to have dissappeared. I could not solve this problem and even after realizing MERGE was "Merge"... still. but... THANK YOU FOR POSTING YOUR VERSION OF the _ _ double underscore... apparently mine was not the right kind of double underscore. Looked right but nope!!! a day of that garbage - and copying your tag - - worked. phew! if I wasn't clear... thank you again!!! and Shane - another great video as we were just looking to get this included in our "non-security" solution.... I'm still trying to figure out if there is a good way for better security solution to allow members to have access to lists (for powerapps) but NOT allow them to open them in Sharepoint. I know it seems weird but like you mentioned in one of your other videos about security... they might need access to the data (in formulas or other purposes)... i Just don't want them to see the raw data!!! But I digress. Thanks both of you!!! saved the day.
@davidmckenzie18893 жыл бұрын
@@aliendb I have previously used a method to 'hide' a list from users in SharePoint that allows Power Apps to access the data. There are a few steps: 1. Set user access to the list to exclude the ability to create views on the list. 2. Make sure there is only one view on the list and set this to filter for something that returns no rows (I use ID=0) 3. Customise the list forms with Power Apps and remove all fields and replace with a label saying "no access" - this stops user from using EditForm.aspx etc. I also create a personal view to show the data if I need to see it. This doesn't stop a user viewing the data using Excel, or another Power App, but adds another layer of obscurity.
@doganmentese60592 жыл бұрын
Thank you very much :) ""__metadata" (yes, you have to use two underscores!)" save my life this information :)
@WillyEckerslyke5 күн бұрын
Shane - a recent discovery I've made is that if you remove the View Application Pages permission from users and then stop inheriting permissions on all lists, the lists are hidden from users, but still accessible to site owners and in apps and flows. I've used this on a couple of my sites and it has hidden all data from users (even with a direct link to a list) with no other downside that I've found.
@ShanesCows4 күн бұрын
Cool. Thanks for sharing
@GregCo723 жыл бұрын
Perfect timing on this Video. Getting ready to release an app and was worried about users going in and trying to edit in datasheet mode. Could take it a step further and create a list of lists with bool values and tie it to dynamic values in the flow to turn on and multiple lists at will.
@ShanesCows3 жыл бұрын
I like the idea Greg 😀
@cvkealey3 жыл бұрын
This is great information, and good to know I can do it through Power Automate (since Powershell has been a little wonky for me since switching to the latest version). When MS Lists first rolled out, the "Hide from browser"/"Hidden" option didn't seem to impact visibility in the Lists app, but checking some of my "known hidden" lists now, it seems like they closed that loophole. What's nice, though, is that if you "favorite" a hidden list, it will show up in the Lists app for you, but still be hidden from others.
@ShanesCows3 жыл бұрын
Very cool Chad!
@anthonyleduc3 жыл бұрын
You rocks...a must to see for all powerapps makers who works with SP list like me
@ShanesCows3 жыл бұрын
Thanks :)
@vishaljhaveri7565 Жыл бұрын
WHAT I FOUND IS : If the user has the right to create a page in SharePoint site and then if he creates one and if he wants to add component and where he adds the list, he will get access to names of all the List present in the SharePoint Site.
@robertmcghee68153 жыл бұрын
Hi Shane, thanks, this is super helpful! However, I cannot seem to reverse the post and set the values to "false", it still does not appear in my sharepoint site 😅 Any thoughts/ideas how to reverse it? I just tried changing the body to the following, the flow ran successfully, but the list is still hidden. {'__metadata': {'type': 'SP.List'}, 'Hidden': false, 'NoCrawl':false }
@zanrleonardo2 жыл бұрын
I wanna know too
@CreativeCloud-x6e Жыл бұрын
Double underscore!! Who'd have thought it - I really should subscribe and download the templates rather than copying from my screen. Another brilliant video Shane - thank you :)
@ShanesCows Жыл бұрын
Glad you got it working. 🤩
@shivsuresh15583 жыл бұрын
Thanks Shane. But if the SharePoint form is made out of power apps and new link will open save / cancel Option. If you cancel the form it will take you to the SharePoint list page. So anyway they can find easily.. is there any way to hide it?
@saharhussein70432 жыл бұрын
Thank you so much Shane, My app has gone so far because of your tips and tricks. YOU ARE AWESOME!!
@ShanesCows2 жыл бұрын
Appreciate that 😎
@markpalisoc48683 жыл бұрын
Thank you for this! I'm exactly at this phase where I need to justify the the security of my app to my boss (for audit purposes) and this definitely adds to it.
@ShanesCows3 жыл бұрын
Awesome!
@dimitrioschasanidis55103 жыл бұрын
Hi Shane, a fantastic video again! I don't want to be off topic but I would like to ask what naming convention you use for control names in bigger projects? Do you follow Microsoft guide (btn: button, txt: textbox etc)? Maybe that could be a nice idea for another short video. Thanks!
@ShanesCows3 жыл бұрын
Thanks. I do use btn and inp and dd for Dropdown and dp for date picker 😎
@rinturaju92882 жыл бұрын
Thank you so much Shane, me and my senior was searching this for a long time. YOU ROCK (as always)
@ShanesCows2 жыл бұрын
You are welcome.
@starmole50003 жыл бұрын
Yo @Shane Young and the following, do you think it seems like MS are investing in the Model-Driven app side of the equation? I'm worried that PowerApps Canvas apps features aren't being pushed forward as much as they could be... although they have done a lot of the pro-dev deployment stuff (convert msapps file to code etc.), not so much on the general experience side...
@mdhidayat57062 жыл бұрын
thanks Shane! Using it right away in production. Able to hide and unhide SP list when required. 👍
@ShanesCows2 жыл бұрын
Excellent!
@benjamincpetersen3 жыл бұрын
AWESOME!!! - Also, easy to reverse by setting both "true" 's to "false" in the body
@ShanesCows3 жыл бұрын
Yup. Nice point!
@VildMedBacon3 жыл бұрын
Hi, have you gotten the reverse to work? The reverse flow runs successfully, but the list remains hidden on my end 😥
@shingomcleod3 жыл бұрын
Hi Shane, thanks for this video - great to know there's a quick way to do this instead of asking our IT support to run Powershell scripts. You asked is there another way to find this list and the answer is inevitably yes, as David McKenzie eluded to... PowerBI desktop > connect to the SharePoint site and you'll see all the lists hidden or not 🙁. Wish Microsoft could close that loop!
@ShanesCows3 жыл бұрын
Ugh, that is annoying.
@natcongreso2763 Жыл бұрын
This is what i was looking for. Thank you so much Shane!!!
@ShanesCows Жыл бұрын
Happy to help Nat!
@willieklein67073 жыл бұрын
Was there a new Power App update recently? I noticed I can now edit an excel sheet from a power app, while the excel sheet is still open. Thanks!
@ShanesCows3 жыл бұрын
I heard they were changing it but not sure how the rules with Excel changed.
@Mx813 жыл бұрын
Yes, it has been changed. You can also access excel files in a document library. 👍🏻
@KeithWilliamsbangor3 жыл бұрын
Great help as always Shane! Worked perfectly first time
@ShanesCows3 жыл бұрын
Great to hear!
@n.p.garcia8956 Жыл бұрын
Hi Shane, thanks for this quick but very crucial lesson! Just wondering if I want to hide multiple lists in a SharePoint, can I just use 1 flow with multiple Send an HTTP request to SharePoint actions? Your response would be greatly appreciated!
@TheRemyRomano2 жыл бұрын
What I like to do is keep my data sets in a separate SharePoint and share only the custom lists without sharing access to the SharePoint. The users don’t get an invite when I add them. I think for the most part this keeps anyone from poking around and stumbling into the data and it’s dead simple. Makes keeping track of all of my data sources dead simple too.
@CarolPetersen-f8e Жыл бұрын
Hi Shane! I may be a little late to the party on this and not sure how to proceed. I have my Sharepoint list which includes some sensitive information on my items. I only want my co-workers to only see a specific view. I added a web part to my SharePoint page and removed the hide the Command Bar and "See All" option so they can't change/edit/add views and gain access if they wish to this sensitive info. However, they now can't export the list which is necessary. Is there a possible work around so I can restrict their access but still export to Excel?
@ShanesCows Жыл бұрын
They only sure fire answer is to set Item Level Permissions. kzbin.info/www/bejne/rHi2f6WgbZd9mas
@CarolPetersen-f8e Жыл бұрын
@@ShanesCows Ok, so if I understand correctly there is no way to restrict users from creating their own views or switching views on the SP list? I want them to have access to the items (new employees), but not all the columns on the items (i.e.; salary)? I tested with a "View Only" permission for the list and the test person was still able to gain access to create their own view and was able to select the columns they wanted.
@junbecks11 ай бұрын
Awesome tutorial Shane! Quick one, wont users see the list name when they go ahead and open the app and the app prompts them to agree to connect to the data sources etc?
@jamiemcgrath33053 жыл бұрын
I normally create my lists and break off permission to the main site. Then only give people access to the list itself (with reduced view options depending on the data). From testing it seems that the site level security stops them from accessing the list but might need to retest!
@ShanesCows3 жыл бұрын
I like it. 😀
@Excel-power-users2 жыл бұрын
Lucky to get this video. Thanks for sharing. How to make the list back to visible is to change the true to false. Correct me if I am wrong
@komanglayang78612 жыл бұрын
Hi Shane, is it also possible to use the same method to hide the Recycle bin from appearing in the quick launch navigation for instance?
@ShanesCows2 жыл бұрын
Sorry, I am not sure. But it is worth a try.
@FairgoldTraining3 жыл бұрын
@shane you are often asking for suggestions for ideas for videos. We have a real issue with MS Forms not allowing externally shared forms to upload attachments. Can you suggest anything with flows/apps?
@ShanesCows3 жыл бұрын
I don’t have any good answers for that challenge. 😔
@lfish894 Жыл бұрын
Brilliant as always Shane. Always makes me laugh to lol. Quick unrelated question, can you assign a mail enabled security group permissions to send on behalf of a shared mailbox?
@ShanesCows Жыл бұрын
I am not sure, I haven't tried. Sorry
@jamesambrose2834 Жыл бұрын
Amazing video as always! Although I did find that the POST method no longer works and I have to use the PATCH method. I don't know if that was something that changed when Microsoft changed the API?
@ShanesCows Жыл бұрын
Interesting. i will try to take a peek, not sure.
@jamesambrose2834 Жыл бұрын
@@ShanesCows I’m starting to think it might be a region thing. I recently watched your video about converting date/times into the local style where you showed the code syntax is different. I’ve been noticing for a while that some of the syntax of a lot of formulae on PP that interact with the Rest API are very slightly different even when I copy an example from Learn.Microsoft. I’m in the UK so am starting to think the API language is localised. 🤔💭
@stephenuk6490 Жыл бұрын
Great video, I tend to hide lists using Sharepoint Designer (list/properties/hide from browser).
@ShanesCows Жыл бұрын
Great tip!
@killedgamer50112 жыл бұрын
Hey Shane, perfectly good video, love your channel and all of your tutorials! I have a question regarding the invitations of Microsoft List: In the past, if I added Users to my Microsoft List which holds the raw data of an app, I could deselect the notification of the user so that they don't get any mails about this list. Unfortunately today I found out that this is not longer possible and you will send an invitation mail to a new user every time you add them. Is there a work around solution to add user "secretly" to a list without any notification? Best regards, Robin
@glaringmind-rq8xu Жыл бұрын
as always great video Shane.! Thank you! how to add multiple list to hide and hide it only to certain user group e.g. site visitor?
@ShanesCows Жыл бұрын
Sorry, I haven't tried either of those scenarios.
@jameslbetteridge3 жыл бұрын
Hi Shane, as always, great video! Quick question, most of this relies on remembering what the list was called or being able to spot it in a PS output. Is there a way to output the lists that have been hidden? That should give a much smaller list to search through if your memory is as shockingly bad as mine :-)
@ShanesCows3 жыл бұрын
You could filter it. Hidden = true or something like that is returned on the data. If i remember Monday I will try to find the syntax but it is possible to find.
@remitirfoin84003 жыл бұрын
Great videos! loving those by the way. One quick question: will that also hide it from Delve? thanks
@anandasanyal2 жыл бұрын
Hi Shane, as always, great video, and implemented same in few solutions. But for SharePoint search, using Flow, Search API, Search is not returning data, As scheduled crawl not considering the hidden folder. How to handle this use case? Thanks.
@ShanesCows2 жыл бұрын
Not sure, I haven't tried to get the hidden folder to search.
@simmyjer Жыл бұрын
Hi Shane! Love your videos. How do I unhide the SP list?
@ShanesCows Жыл бұрын
Run the http action again but change the hide property from true to false.
@vladlapets7650 Жыл бұрын
@@ShanesCowsbut when you run this flow again, action 'get all lists and libraries' doesn't return any lists because you've hidden them
@leonelbraga54273 жыл бұрын
Shanne, please, i'm getting this error message: The property '_metadata' does not exist on type 'SP.List'. Make sure to only use property names that are defined by the type.
@ShanesCows3 жыл бұрын
That is usually a typo. Check your URL, headers, and then all of the JSON. It is two __ not one. That may be your challenge.
@mblherry3 жыл бұрын
I got the same error. I eventually just removed '__metadata': {'type': 'SP.List'}, from the body and it worked.
@ReiBalboa2 жыл бұрын
hi shane more power on your videos, really helped me a lot, quick question how can i filter office365user to access by my closed group and only permit that closed group to my powerapps?
@ShanesCows2 жыл бұрын
This video I talk about using Azure Groups kzbin.info/www/bejne/hl6rkIiChbNleK8 or this video SharePoint groups kzbin.info/www/bejne/qIPRk5hneMuEaZI
@Danielx643 жыл бұрын
Hi Shane, Thank you for the tip, I just finished building a large repeating table system with 2 SharePoint lists. In the video you mentioned that if someone knows the full correct name of the list, they can use it as a data source in power apps, can the same be true for power automate? Thank you
@vishaljhaveri7565 Жыл бұрын
WHAT I FOUND IS : If the user has the right to create a page in SharePoint site and then if he creates one and if he wants to add component and where he adds the list, he will get access to names of all the List present in the SharePoint Site.
3 жыл бұрын
Great way to hide Document Libraries and List from SharePoint site :) Awesome possum. Thanks for sharing Shane 👍
@ShanesCows3 жыл бұрын
My pleasure!
@wendymason32633 жыл бұрын
Awesome Shane, this is exactly what I needed right now. Thanks yet again
@ShanesCows3 жыл бұрын
Happy to help
@pathimohanadurgasai78163 жыл бұрын
Much awaited video.. Thanks
@ShanesCows3 жыл бұрын
Most welcome 😊
@JayGeiger3 жыл бұрын
Does preventing the search crawl affect "Filter/Search" in PowerApps?
@ShanesCows3 жыл бұрын
It does not.
@bogusawkresowiak7426 Жыл бұрын
Thanks Shane, you helped me a lot today :) Keep up the good work
@ShanesCows Жыл бұрын
Will do, I appreciate the support.
@ilisten24103 жыл бұрын
hi Shane, great video, useful as usual, is it possible to hide multiple lists in one step?
@ShanesCows3 жыл бұрын
You would have to just make the call one after another. :)
@Worrelpa3 жыл бұрын
Hi Shane, Does this hide work with the lists app? Found it to be tricky because it uses programmatic access to the lists. I found it to work for a while and then the lists came back again. What I found that works and no credit to me for it. Set up a custom permission level for your users accessing the app. Remove the view application page permission. That means if you know the url it won't display gives you an error. ;) Bit of an admin task. You can also amend all the views to all items remove all the list items from view. Also if you need to search on a list in the app and it is removed from search index does search still work inside? not sure on that one not been able to test. Which ever way you look at it users need programmatic access. Same with any data source if you know what to do you can get to data if you have access.
@ShanesCows3 жыл бұрын
Hey Phil - For Lists another commenter (Chad maybe?) said that this was working with Lists for him. Seemed like he had done some testing so might ask him. I think if you remove the list from Search then search is gone but didn't test. 😀
@ashikshaik12053 жыл бұрын
Can we hide the list only for few users with help of powerapps and powerautomate? Please help
@ShanesCows3 жыл бұрын
Not that I know of.
@donerwinsaunar42183 жыл бұрын
got a 401 unauthorized, anything else needed to be done? thanks
@RowDogSA3 жыл бұрын
I couldn't understand why it wasn't working for me. There is a double underscore before metadata! Reading comments below, how do you reverse this? Apparently setting Hidden and NoCrawl to false does not work.
@robertmcghee68153 жыл бұрын
I have the same issue regarding reversing it, would be so convenient to simply change the "true" values to "false"
@RowDogSA3 жыл бұрын
@@robertmcghee6815 One of the comments below explains how to do it with SharePoint Designer.
@zakmdot3 жыл бұрын
What web browser is that with the open tabs on the side?
@ShanesCows3 жыл бұрын
The new version of Edge. It is a setting now to have vertical tabs. 😎
@zakmdot3 жыл бұрын
@@ShanesCows it's gorgeous! Love the content sir!
@rayromych55343 жыл бұрын
Great trick! Thanks a lot :) One question though - how do I get to hidden list settings?
@ShanesCows3 жыл бұрын
You need to use the url directly. Maybe un hide it and then save the url so you can get back later.
@davidmaher28053 жыл бұрын
Awesome, thanks Shane. Just what I needed and easy to do.
@heathfindsvideos3 жыл бұрын
How can you hide the lists in the Microsoft lists app? This looks like it hides from the site contents, but I'm not sure if this still shows in the lists app or not?
@heathfindsvideos3 жыл бұрын
Never mind - for anyone with this question, it looks like it does hide it from lists but it takes 20 minutes or so to synx with the change in settings. I'm not expert as I had this question just one hour ago, but my test lists for this scenario are not searchable or visible in Microsoft lists app now either.
@ShanesCows3 жыл бұрын
Thanks for sharing. 😀
@heathfindsvideos3 жыл бұрын
@@ShanesCows No problem Shane, really enjoying the more intermediate and advanced type stuff lately. This video and others on security you've posted lately have helped out a lot!
@expandlearning1009 ай бұрын
great explanation for the most needed scenario. Thanks @Shane
@ShanesCows9 ай бұрын
Happy to help
@laszlogyor6628 Жыл бұрын
Excellent video
@ShanesCows Жыл бұрын
Thank you!
@dwittle85643 жыл бұрын
Great video as alway. Is there a way to prevent someone from getting Sharepoint data through an Access database?
@ShanesCows3 жыл бұрын
I don't know... Sorry, haven't tried that.
@nocodecreative2 жыл бұрын
I get an error when I run the flow: "An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified". :(
@ShanesCows2 жыл бұрын
Sorry Wayne, I have never seen that error. Not sure why you got it.
@traveldirt3 жыл бұрын
Will this work for Document Libraries too?
@ShanesCows3 жыл бұрын
I am 99% sure yes.
@traveldirt3 жыл бұрын
@@ShanesCows Great thanks Shane. Love your videos :)
@3Stefan73 жыл бұрын
Does this also hide it from MS Lists Overview? Any chance to hide it there?
@ShanesCows3 жыл бұрын
I haven’t checked but I would hope so.
@ILifeToEnjoy Жыл бұрын
I used the second step to get the list that i was hiding and the flow worked succesfully. But even tho I was able to find the name of the list via the search function, the list didn´t show up on SharePoint again. Is there a way to make a list visible on the SharePoint navigation and site content again?
@ricolaterreur73392 жыл бұрын
Hello! Thank you VERY MUCH for this great help !! :) I have an additional question: is this way also possible with Sharepoint Folders ?... Best regards from France !
@ricolaterreur73392 жыл бұрын
no sorry - i mean libraries... :D
@davidmckenzie18893 жыл бұрын
Does this also hide it from Power Query (Excel and Power BI)? I use a different way of hiding the data from users, but this is easier and better. Thanks Shane
@ShanesCows3 жыл бұрын
I am not sure. Will you check and let me know? 😀
@davidmckenzie18893 жыл бұрын
@@ShanesCows Didn't hide the list in Power Query in Excel (so suspect same in Power BI). These are read only so user can't change or add to the data, but suspect it doesn't hide from Access (sorry, I don't have Access to check)
@johnbrennan8442 Жыл бұрын
@@davidmckenzie1889 @Shane Young any update on this one as it is an issue
@johnbrennan8442 Жыл бұрын
@@ShanesCows Any update please on how to hide from Excel and Power Bi ?
@Jakubnohava110 ай бұрын
Is someone getting this error? For both POST and PATCH Parsing JSON Light feeds or entries in requests without entity set is not supported. Pass in the entity set as a parameter to ODataMessageReader.CreateODataEntryReader or ODataMessageReader.CreateODataFeedReader method.
@keshavanveeraragava76902 жыл бұрын
You are genius
@ShanesCows2 жыл бұрын
Thanks
@dianecochran11753 жыл бұрын
I'm very new to Power Automate. I followed your steps but I'm getting the following error message when I run my flow: "An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified." I've retyped the text within the flow several times to no avail. Any idea what might cause this?
@eupascani3 жыл бұрын
In front of metadata there are 2 underscores :)
@dianecochran11753 жыл бұрын
@@eupascani That's it!!! Thank you so very much, Avel Stefan!
@1986tobik2 жыл бұрын
Hey Shane, thanks for sharing. Is this http request currently working? I tested it and get an error code 400: an entry without a type name was found...... So the 'type' SP.List in the body is right entered. Could you check it?
@shenalhooks Жыл бұрын
I received the same error. Any update?
@big1975E8 ай бұрын
I followed this example but my SharePoint list doesn't hide. I'm a site owner and created the list. Why would t it hide?
@ShanesCows7 ай бұрын
I am not sure, I would check your Body again and make sure it is all correct. I have never not seen this work.
@rockerbeck6022 Жыл бұрын
My flow ran successfully but my sharepoint search was able to find the list. Any suggestions?
@S.IervolinoAEC Жыл бұрын
Hi Shane. This solved a big issue for me. Thank you!... Only... How do I undo it? 😞... I assumed I'd change NoCrawl and Hidden to false in the flow and the list would magically come back... and it didn't... I got the poison but not the antidote! 🙂. Thanks again!
@S.IervolinoAEC Жыл бұрын
Update: after tinkering a bit with it I was able to restore the list but also, unfortunately, wasn't able to hide the list again. Here's what happened: changed Hidden and NoCrawl properties to 'false' in the flow and ran it. Links to the list that were used in the site still gave '404 NOT FOUND' error, however now the list could be found in Site Contents. Copied the url from there and replaced it in the links on the site and everything went back to normal only, when I changed Hidden and NoCrawl back to 'true' and ran the workflow, the list disappeared from Site Contents but any links published on the site will still work and take user to the list... It's like the flow stopped working...
@ShanesCows Жыл бұрын
That is super weird. I have been able to toggle from True to False without issue. I do it all of the time. Not sure why it isn't working fo you :(
@mrstevennewmanEDU Жыл бұрын
Hi Team, sorry but this does not work for me :( I keep getting " An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified." I've double checked, triple checked all my code, but alas to no avail :( Could my admin have stopped me somehow?
@mrstevennewmanEDU Жыл бұрын
OMG- I did not put a double underscore "__metadata" I'm so ashamed!!
@lakshminarayananr2992 Жыл бұрын
@@mrstevennewmanEDU Don't be, this really helped me. I was trying to find what went wrong and finally I found this comment. Thanks!
@mrstevennewmanEDU Жыл бұрын
@@lakshminarayananr2992, see failure is not always a bad thing. Sometimes we need to share our mistakes as it helps others. Glad mine helped you :)
@ShanesCows Жыл бұрын
Thanks for sharing. 😀 I agree no shame in making mistakes. Glad you got it fixed.
@mariomr10003 жыл бұрын
Does anyone know how to hide or remove a gallery record from a button submit without it being removed in share point list?
@ShanesCows3 жыл бұрын
Filter is your best option. Filter(datasource, hide = "Yes") then set the column hide to yes when you want to hide it.
@mariomr10003 жыл бұрын
@@ShanesCows so I’ve added a column that is completed which is yes or no in my sharepoint list and added the formula but it’s not hiding the record in the gallery is this what you meant to do or have I missed something sorry I’m a novice at this atm?
@vishaljhaveri7565 Жыл бұрын
WHAT I FOUND IS : If the user has the right to create a page in SharePoint site and then if he creates one and if he wants to add component and where he adds the list, he will get access to names of all the List present in the SharePoint Site.
@Dannickized Жыл бұрын
Brilliant
@ShanesCows Жыл бұрын
Thank you
@viky94630 Жыл бұрын
out of four list, not working on two list
@ShanesCows Жыл бұрын
Not sure why, it has always worked for me. 🫤
@viky94630 Жыл бұрын
@@ShanesCows thanks for your replay. List is not appearing in site content or in search bar, but appearing in left side navigation bar. I have removed it manually. Problem solved. Thanks for your great video and support.
@lcdillard2 жыл бұрын
Worked like a charm and hid items from MS Lists in the SharePoint App bar - BUT my Power Automate can't find the lists! Help?
@lcdillard2 жыл бұрын
NVM - used the list ID to find them. duh
@vishaljhaveri7565 Жыл бұрын
WHAT I FOUND IS : If the user has the right to create a page in SharePoint site and then if he creates one and if he wants to add component and where he adds the list, he will get access to names of all the List present in the SharePoint Site.
@seamusobric3 жыл бұрын
Thanks you a million for this youre some legend! I have been trying in vain to leverage Sharepoint Permissions to deny access to Sharepoint List while allowing PowerApps access, and now this!! super! does it work for Excel files? i can't get it to call the excel file, Help!
@Guilherme-oz7zr2 жыл бұрын
you're amazing
@JFDicer9273 жыл бұрын
Someone got some sun.
@ShanesCows3 жыл бұрын
Yeah. Kid's soccer matches. I put on sun screen TWICE still didn't matter. UGH. 🌞
@cheeseyburger94053 жыл бұрын
@ShanesCows3 жыл бұрын
🐶
@Excel-power-users2 жыл бұрын
I am getting this error message : An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified. clientRequestId: 6bbde2ac-2497-4a3d-9181-676c9d2c9315 serviceRequestId: 0cdc7aa0-6035-5000-9fb1-8a889f1f6c92 Please help :(
@ShanesCows2 жыл бұрын
I am not sure, sorry.
@Sherinvk-ly6bu Жыл бұрын
Invalid JSON. The property name '' is not valid. The name of a property cannot be empty. clientRequestId: 5fb30e74-cb53-4488-ae24-e37b2a69d2db serviceRequestId: 6e63bda0-d0dc-6000-bb5b-ad33a039678a I am getting this error. Can resolve it please