User Profile
Naligurtan
Brass Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: How to show over 20000 records in a combo box field in PowerApps form
Hi ganeshsanap, Would you please be able to take me through step by step only for Customer Name filed? 1-I have a from called Contract form. 2-I want to add Customer name filed from the Customer list into this form. 3-This combo box should be searchable. 4-The customer list has over 20.000 customers. ThanksRe: How to show over 20000 records in a combo box field in PowerApps form
Thanks ganeshsanap It did not work. It is not possible to search. I only can use the dropdown selection and it shows empty scrolling down fields. What I need is: the combo box should be searchable. When users search a customer name, they can find it and select it as a value for that filed. Then at the submit, this value should be saved back into SharePoint list.How to show over 20000 records in a combo box field in PowerApps form
Hello All, I have two SharePoint lists. 1-Contract List ID Contract Name(Text filed) Customer Name(Text filed) 1 2 There are more fields/columns but I just display here 2 columns. 2-Cusomers List ID Customer Name(Text filed) 1 Dell 2 HP 3 IBM 4 Microsoft ..... over 200.000 customers Customer List has over 20.0000 items/customers. I want to create a Power App form for the Contract List. The form will be including: Contract Name Customer Name so on... I added two SharePoint lists into PowerApps. I changed the data row limit from 500 to 2000 in the PowerApps(Settings>General>Data Row limit I created a form and added data fields. I connected the value of the Customer Name from Contract list to Customer list's Customer name filed. It gives me 2000 items. However, I want to show/display all records(over 20.000) in the combo box. I know there is a delegation issue but not sure how to get around it and solve it. Eventually, I want users to be able to search in the combo box to find any customers within 20.000 records and select a customer and then fill up the rest of the form and then submit the data back into SharePoint contract list. I guess there is a way around to manipulate it with delegation. But I do not know how to do it. I would appreciate if someone could help me out on this case. ThanksLook up filed delegation issue SharePoint-PowerApp
Hello All, I have two SharePoint lists. 1-Contract List ID Contract Name Customer Name(Look Up from Customers List below) 1 2 2-Cusomers List ID Customer Name 1 Dell 2 HP 3 IBM 4 Microsoft over 200.000 customers There are over 20.0000 customers in the Customer List. I want to create a Power App form for the Contract List. I am extracting customer name data from the Customer List as look up. It gives me an error and do not let me to create the PowerApps form for the contract list. I guess there is a way around to manipulate it with delegation. But I do not know how to do it. I would appreciate if someone could help me out on this issue. ThanksPower Automate flow can skip creating the document library
Hello, I have a SharePoint list which has two custom columns: 1-Customer(drop down list/Choice) 2-Contract Title(Text filed) When an user create a new contract then a power automate flow automatically: -creates a document library with the name of the customer -breaks the permission/stopping the inheritance/create a unique permission for the document library -creates a folder in the document library with the Contract Title Those all work fine. NOTE: One Customer can have many contracts. Scenario is this: When the user creates another(second/third etc.) contract for the same customer(Document library), the power automate flow should create another contract folder in the same document library/customer. However, it does NOT create and it is running forever. Because the document library is already created. I want the power automate flow to see if the document library is already created then it should skip the document library creation and it should directly go to creating a new folder for the new contract. I hope someone can have answer for this. ThanksHow to add a MS365 group to many SharePoint sites as Site collection administrator
Hello All, I have over 500 sites in Excel file/.scv. I created a MS365 group and added several users. Now, I want to add this MS365 group to all 500 sites as Site Collection Administrator. I need to do it with PowerShell. I hope someone out there would be able to help asap. ThanksGet site owners and site admins
Hello All, There are over 5000 SharePoint sites in my MS365 Tenant. I am using SharePoint Online. I retrieved/extracted a report/list of sites that have "Everyone expect external users" group. 1000 SharePoint sites have "Everyone expect external users" group. I have this report in excel/csv. My question is this: How can get a list of site owners and site admins for those 1000 SharePoint sites that have "Everyone expect external users" group? Looking forward to hearing from you. ThanksRe: Migrate SharePoint sites libraries into one SharePoint site
Hi LeonPavesic It does not work because I might have not explained in clearly and you may not have understood me. I will try explain it here again. I am also attaching a screenshot. There are over 1000 sites on the prem with ONLY one document library (Project%20Folder). I created ONLY one site on SharePoint online. I want to move all sites’ document libraries (Project%20Folder) into the new SharePoint site as a document library with the same name of the prem sites (GP56077, GP56121). All Site names from the old sites/on prem became a document library name in the new SharePoint site. All files from the Project%20Folder document libraries needs to be moved into the new document libraries such as GP56077, GP56121 etc. Please see the screenshot below.
