Power Apps Search
Search
Using a path name from an SQL query to open a csv file in power query
Hello, Helping a colleague with this project. The colleague has created a SQL query that finds the path to a csv file. This path changes on a daily basis, so we need to have the path ...
Re: Edit form editable for some users from approvers list based on Title field value attached steps
Ok. Use this then If(Text(ThisItem.Status.Value) = "Approved" && Isuser1, DisplayMode.Edit, DisplayMode.Disabled )
Re: Sharepoint site differences
We solved this issue. The site administrator had initially turned off external sharing (https://learn.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off). But, once we allowed Sharepoint ...
Re: Merge Queries
Hi @Timbuktu7 , Please check the lookup file in case it has multiple rows for the same join key. Kind regards, Rohit Please mark this answer as the solution if it resolv...
Re: Sharepoint Link api skipToken not working
Hi @Jojo197 - Please use the Power Query SharePoint Online list connector - Power Query | Microsoft Learn connector instead. I also recomend using Implemention="2.0" for the best...
Powerapps and Office365users.searchv2 for guest users
We have shared a power app with guest users of our Azure AD. These users are able to open the app but when they try to use a people picker in the app, they get the following error Offi...
Re: Teradata and LDAP
Have you found any solution for this i ran into the same problem. I really apprciate if you could help with a solution for this if yous problem is fixed. Thanks
Re: Getting a Component Library Definition
Yeah, that has the ring of truth to it. I'll try cracking open a solution myself to see if I can find an OTC. maybe by exporting a table with commands, but without the component library dependency? 🤔
Re: Switch statements in a ForALL and updating two different data sourses: Only first row in gallery collection is updating the SP List
@jv123 PrCollection is a collection name or it is a gallery name? if gallery, what code is in PrCollection.items? Dropdown1 and inputitem are not in that gallery a...
Re: Ribbon Workbench issue: Custom subgrid buttons stopped working
@ScottDurow - have you seen anything similar recently?
DropColumns issues shaping Dynamic Collection
Hello, PowerApps Geniuses This has been driving me insane the last few days trying to figure out if it's a PowerApps bug or what... I have a master table that I am trying to r...
Re: Power Apps used as training app
Hello @jed99 I have created an app similar to your requirement before. I followed the ideas of Dawid Ziolkowski (@365CornerDavid). Details in here: https://www.youtube....
Re: Role based security
Hi NK711, You can try setting the permissions on the list permissions in Sharepoint list. Setting read-only access would allow the user to read the list and edit to edit the list. &nb...
Re: How to do a Date and Signature Validation
@fishtail I see no one still helped You, so I will try, It's a complex fix, that's why requires a few changes to Your code. Let's start with moving the code for capturing sig...
date data type
There is a text type Data (date) in Date data type how to convert it to date data type
Re: LookUp not working correctly?
Moving this post to "Building Power Apps' where you'll get much faster, better responses to your canvas apps questions.
Re: How to patch a lookup column in a collection
Is there a specific reason that you are using 'Employee Number' in the Patch when it appears the column is called 'Employee No'? The label in the record used for patching needs to match the column na...
Re: Can I use PowerApps to build software for a private business?
1) For user's to run a Power App they must have a Power App license. So its normally not feasible to build an app that will be used by the general public.
Extract and Categorize the remark column
Hi members, I need help on this. I have a table with a remarks column. The remarks column is unstructured with spacing, text, numbers, and symbols. This column contains many words, ...
Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?
I'll come back to you on this
Re: How to do a Date and Signature Validation
Hi Sebs, I exactly follow your guide, but it look like I still can't get it to work on the signature. The date is working fine, once I have selected the correct date, the Save button able to click ...
Re: Help with delegation in piechart
Hi @JamtMaster , If your (entire) list is less than 4k, you can do this, (without the shadow field), but if it is bigger, you are correct that the bottom filter would be ForAll( ...
Re: Set-AdminPowerAppApisToBypassConsent for MSN Weather datasource
Any updates PowerApps users? tagging a few top Kudoed to get faster reply @WarrenBelz @Drrickryp @RandyHayes @timl @TheRobRush
Re: Search / filter in multiple columns
@Drrickryp Thanks man! I build it from scratch and now everything works. Thanks for all your effort. René
Re: Extract and categorize the column
Can you give us an example of your Remarks column and how to categorize them? It will be easier for us to give the solution...
