User Profile
Youngwong
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Only share out one list instead of the entire site
Hi all, We have several different lists in our team SharePoint site, we may want to share different list to different partner, as we don’t expect them to share their data each other. For example: List-1: only to partner A List-2: only to partner B List-3: only to partner C Does anyone know how to do this? Is it available? Thank you!Solved1.8KViews0likes2CommentsInitialization of the data source failed
Hi all, In Excel 2016, we built a data model with Power Pivot in our dashboard, and then shared to our users, who may be using Excel 2010/2013/2016. When they want to interact with a PivotTable that uses the workbook Data Model as a data source in the dashboard, the error "Initialization of the data source failed” will happen. And we found below link to know about this error: https://support.microsoft.com/en-us/office/power-pivot-error-initialization-of-the-data-source-failed-55d6b559-3124-4583-85fb-deb2fa1c098b It mentions that “To work around this error, upgrade to Excel 2013, Office Professional Plus edition. Data Models created in Excel 2013 will run only in workbooks that are also opened in Excel 2013.” My question is that our Excel is built in 2016 version, so do our users also need to upgrade to Excel 2016? Or is the Excel 2013 enough for them to run our data model in the dashboard? Thank you!2.4KViews0likes0CommentsDropdown lists and hiding columns in phone version
Hi all, We have a SharePoint list, and we have customized its form by Power Apps to collect information from our partners. We intend to publish the phone version to make it convenient for them to submit the data to us. But there are below problems: 1. There’re around 50 columns in the list, but only 20 columns require our partners to enter data, the others are for our recording and calculation. We can hide those columns that we don’t want to show to our partners in the browser version, but we don’t know how to do the same thing in the phone version, which just shows us all columns every time. Is there a way to hide columns in phone version? 2. For some columns in the list, we set dropdown lists for our users to select their answers. This function works in browser version, but doesn’t in the phone version, whose questions with dropdown list seem invalid and impossible to select answer or enter data. How can we make them valid to select answers? If any potential method or advice for our problems, pls feel free to let me know, thank you very much!372Views0likes0CommentsSearching Engine in Power Apps
Hi all, We have generated a Power App from one of our SharePoint lists, collecting information from our partners. For one question in the app, we set a dropdown list of factory names for the users to select their names, as the list is a long one, they always need to search their name before choosing. But it seems that it’s only possible to search the name from the beginning of the factory name, if we search its middle name, it doesn’t work. For example, the factory name is “ABCD XYZ Factory”, searching ABCD works, but searching XYZ doesn’t. We also have more dropdown lists for the other questions, the same problem also happens. Is there any method to fix this problem to make it possible to search any key words in the lists? Thank you!Re: Unable to upload a video to SharePoint list
Paul de Jong Thanks for your advice! I have customized my list format via “Customize Forms” under Power Apps, at the same time I created a Power App of this list for our users. Yesterday I doubted this problem might be caused by the different parameters setting between Customize Forms and Apps, so I made lots of testings and set all attachment parameters the same, unfortunately it still failed in the end. This morning I tried to upload videos, sometimes it worked but most of times it didn't work. For example: For an existing item of the existing list, the 1st video uploading succeeded, but the following trials failed; For a new item of the existing list, the 1st uploading failed, second one succeeded, but the following ones failed again; Then I tried more than 20 times, it seemed that only 2 times succeeded, both for the MP4 videos and MOV videos, which means all formats of video have the similar problem; I created a list, there's no any problems for uploading videos. I think the problem only happens in my existing list, it seems that the video uploading function is unstable in our site or our existing list, but I don't know what its cause is and how to fix it. It seems that my only option is that creating a new list to replace this old one which has more than 50 columns and a linkage with a Power Apps and an Automate Flow, it would be a huge trouble for me!!! Do you know any other method to find out this problem cause? Thanks!6.8KViews0likes1CommentRe: Unable to upload a video to SharePoint list
Thanks Paul de Jong In my understanding, the 250 MB limit is only for the total attachments size of a single item instead of the whole size of the list, is it correct? I have set the size limit as 50 MB for a single attachment via customizing my list, and the max attachments is only 4. My video size is around 7 MB but it failed to upload, in contrast a 10 MB picture is able to upload as usual, it also works for PDF file. It seems a conflict of video uploading. Then I tried to upload videos to my other lists, some worked but some didn't. The list that worked is just a simple one which is only for my previous testing. Do you know is there any other factor that impact this video uploading function? Thanks!6.9KViews0likes3CommentsUnable to upload a video to SharePoint list
Hi all, We have a SharePoint list and one column is used to upload the attachments, such videos and pictures. In these few days the speed of uploading a video to this column was very slow and failed most of times, it seemed that it's unable to upload any video. But 2 weeks ago our last submission in this list was okay without any problem. By the way, for the pictures uploading, it still works at this moment and there's no any impact. I have tried to upload videos to my others SharePoint lists, the same things happened. Does anyone know what the problem is? Or how can I fix it? Thanks!Solved7.1KViews0likes5CommentsRe: Columns for attachment in SharePoint list
Hi Sudharsan K, thanks for your advice. Actually we are using an customized Power Apps to collect data from our suppliers, they need to submit different types of files to us, around 10 files for each submission, and we think it's inconvenient for them to save files to library first and then set the link to the corresponding column in the SharePoint list. We know the Microsoft Form is able to design different questions to upload different files, at the same time we may develop an Automate flow to capture the data and files from Form, but the question still is that there's only 1 column is available for attachments in SharePoint list, that means it's impossible to transfer the files from Form to SharePoint list, am I right? We're intending to use the SharePoint list for our database, it's easy for us to review the submissions if the different files can be saved in the different columns. Do you have any other advice for this idea? Thanks in advance!56KViews0likes3CommentsColumns for attachment in SharePoint list
Hi all, I want to have several columns for different attachments in a SharePoint list, for example, one column for pictures, one for videos and one for PDFs. But it seems only 1 column is available for attaching all types of files. Is there any method to realize my idea? Thanks!Solved57KViews0likes5Comments
Recent Blog Articles
No content to show