Comments for SharePoint & Microsoft Power Platform Tutorials – SPGuides

Comment on 8 Various Power Apps Sum Column Examples by Another lost PowerApper

Another lost PowerApper — Fri, 27 Sep 2024 18:17:10 +0000

The only Sum() function I get doesn’t allow have the second format, with a datasource parameter. Where/how does one get that override of the function?

Comment on How to Use The Power Apps Combo Box Control? by Debbi

Debbi — Mon, 16 Sep 2024 16:46:01 +0000

What about the “Depends on” fields? I can’t find any documentation about deleting them. I have an independent combo box, and PowerApps sets them to something totally random!

Comment on Gallery Control in Power Apps [How to use with examples] by jordey van Zelst

jordey van Zelst — Fri, 13 Sep 2024 04:48:47 +0000

Hello Bijay,
Thank you for this nice tutorial!
I have created a product selector with in columns the store locations.
Now i want to create a drop down or other selection were i can Show or hide the store location colums depending on my selection. I am able to hide columns but the spaces renmain. Is there a way i can do this so that you could make a selection and only those colums will show in the results. I really am looking to create an Excel kind of view.

Comment on Pagination in Power Apps Gallery – How to Create by Tim

Tim — Tue, 10 Sep 2024 11:26:59 +0000

This article is brilliant and just what I needed to progress my app. However I noticed that as I cycle through the pages, the last page contains data from the last but one page (i.e. if there were 10 records and each page shows 8 then page 1 will show records 1-8 and page 2 will show records 3-10 so there is an overlap. Is it possible to only show the remaining 2 items on page 2?

Comment on How to Use Power Apps Search Function + 6 Various Examples by BB

BB — Wed, 14 Aug 2024 14:39:20 +0000

This formula you provided just fixed my entire App. I couldn’t get the search and combo box to work together properly, as most instructions seem to only use filter instead of filter and search. Thank you! Items = Search(
Filter(
colEmployee,
Department = drp_EmpDepartment.Selected.Value
),
Text(txt_EmpID.Value),
EmployeeID
)

Comment on SharePoint Calculated Column [Complete Tutorial] by Angela Mulligan

Angela Mulligan — Thu, 01 Aug 2024 10:10:11 +0000

Hi, I need to calculate number of days from the date the entry was made to ‘Todays date’, is there a formula to use ‘Todays date’ please? Currently I have this
=DATEDIF([Date reported],[today],”d”) but Sharepoint is not recognising [today] as a date. Many thanks

Comment on SPFx Environment Setup Step By Step Guide – 2024 by Diptesh

Diptesh — Thu, 18 Jul 2024 09:22:18 +0000

I have followed all the steps and it is working fine but after adding the webpart on sharepoint page, I am getting

Something went wrong
If the problem persists, contact the site administrator and give them the information in Technical Details.
TECHNICAL DETAILS
ERROR:
Script error for: 5e53f0dc-de0c-4224-aeb0-f27fe39e7654_0.0.1/NewWebPartWebPartStrings
http://requirejs.org/docs/errors.html#scripterror

CALL STACK:
Error: Script error for: 5e53f0dc-de0c-4224-aeb0-f27fe39e7654_0.0.1/NewWebPartWebPartStrings
http://requirejs.org/docs/errors.html#scripterror
at B (eval at e (https://res-1.cdn.office.net/files/sp-client/sp-pages-assembly_en-us_76321800eff580162db09111ef3c3533.js:198:10299), :8:252)
at HTMLScriptElement.onScriptError (eval at e (https://res-1.cdn.office.net/files/sp-client/sp-pages-assembly_en-us_76321800eff580162db09111ef3c3533.js:198:10299), :30:244)

Comment on SharePoint Document Set vs Folder: Organizing Your Documents Effectively by Adam Hecktman

Adam Hecktman — Thu, 11 Jul 2024 16:39:51 +0000

This is a fantastic article. Has the way you add from existing site content types” under Content Types changed? I do not see it. Could it be Add from existing site columns?

Comment on Pagination in Power Apps Gallery – How to Create by YH

YH — Thu, 04 Jul 2024 05:05:22 +0000

Great! How can we add for example, the filter or search function to the Power Apps Gallery Pagination Using Dropdown? I have no idea where to add.

Comment on Power Apps Toggle Control + 10 Examples by Preeti Sahu

Preeti Sahu — Mon, 01 Jul 2024 04:54:39 +0000

In reply to Guenni. Hi Guenni, Select the Classic toggle control -> expand the Property menu. You can specify the Default property as true or false like below: