Power Apps Search
Search
Re: SortbyColumns - Prioritize Letter then Numbers and allow Empty Selection
Hi, You can achieve this by making a two-step collect like in this example : ClearCollect(_colDemo ,Blank(), "All") ; Collect(_colDemo, SortByColumns( ["256", "1" , "88"] , "Value" )) ...
Re: Need help in building a gallery which show item attachments and info from 2 SharePoint lists
@v-yueyun-msft it worked very well thanks, but can you advice on what does this formula exactly do :- Set(OrderDetails3 ,Filter( Ungroup( AddColumns(OrderDetails2, "testTable",ForAll(Se...
Re: Gallery Selected to Icon Change based Upon an SP column (Complex)
I have tried adding the Is blank but i now have another error?
Re: Question - Only show items in gallery of todays date
Hi, If you're using the field CreatedOn (or any other system filled field), you can filter by using this formula as an example : Filter([DATASOURCE] , [DATE] >= Today() And [DATE] ...
Re: The ol' "An entry is required or has an invalid value" issue
So I found the issue, was to check the update property of any datacard classed as required. When I switched the display mode from view to edit for the required datacards this message popped up ...
pac cli command response in powershell
Hi, I am wondering what is the best way to process the results of pac cli command in a powershell script? For example: $importResult = pac solution import -f -s -wt 240 --...
Radiobutton modern control going horizontal
I just started to see this behavior today with using the modern radiobutton control. For some reason when I select Horizontal, the padding seems to be way out of place. Any suggestions? ...
How to generate auto increment reference number format RS-Year/00x in power apps?
How to generate auto increment reference number: I have a single line of text column. the column is used to save a reference number of each row. in the default value of the the text I assigne...
Document Editing through the Workflow
Is it possible to edit Word documents without using SharePoint? All the paths I know connect me to SharePoint.
Re: Help with dialog component
No, in the Spanish version of PowerApps, use two ";" to continue with the next instruction. If you put the cursor over the error it indicates that it expects a text field, this did not happen before,...
Customise Record Assignment Process/Form
Hi, I have a Model Driven Power App in which a user will have to assign records to an AAD Security Group Team. To do this takes 10 clicks with the default forms and process for assi...
Re: Write New Query to return Maximum Date from table
Use this: List.Max(#"Case List"[End Date])
Taking image and settin a variable with it
Hi there. I have to play with pictures today 🙂 Situation: I have a form in a view, which is compiled using variables setted in other views. The reason to do this is unknown ...
Re: Passing a list into a people picker control
My pleasure! Great, thanks. If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. Follow me online.
Formatting calculated fields from Sharepoint in Power Apps
I have an invoiced field in Sharepoint with the column heading Net Invoice Amount. This is formatted as currency. Unfortunately, in Power Apps the correct value is displayed in the form during the c...
Re: Passing a list into a people picker control
Confirmed that data is being passed to the gblDebug variable. I'll try more than one address, hang fire. No I won't because it won't work.
Re: what will happen if i have 5 Patch functions inside IfError
@johnjohnPter please let me know if you have further questions.
Re: Created by user showiing same user account
I too am having this issue. I have heavily customised a SharePoint list form, and whenever I interact with any data that resides in a SharePoint list, the service account user is identified as ...
login screen navigation
Hello, I'm creating a management application. In that i have three screens login screen, manager screen and employee screen. Is it possible that when a manager enters their email id it should naviga...
Re: BUG - component Event not being triggered since update
Found this out the hard way!
Combing data from multiple rows based on a certain field
Hi, I'm new to Power BI and Power Query and am looking for some help. With my data, each quote has a unique sales ID but the information in excel is broken out per line item. This means th...
Re: search bar on app only filters items starting A
Can you show us what code is doing the filtering?
Refresh page to reload app
Can someone explain how I can automatically reload the page/clear the form without manually doing it via the browser (see attached)? I've tried ResetForm and Exit but none of them reload the ap...
Re: Using a datacardvalue to populate a choice dropdown field
So there is no way to just add the requester email from DataCardValue42_1 to the dropdown list in DataCardValue73? The code above only changes the update action, it does not give the user to select o...
