Power Apps Search
Search
Re: Incompatible types for comparison - OptionSetValue & Boolean
Hi @Medoomi, Modify your formula as below: Filter( Projects_1, 'Opportunity Status' = 'Projects Home Default Display' .Yes ) Here is my testing scenario, OnDuty is a Optio...
Re: Error: Incompatible types for comparison. These types can't be compared Record , Record
Hi, Thanks for the above. However I am still getting an error Incompatible types of comparison. These types cannot be compared, Text, Record
Filter if a column has one of multiple values
Hi, I have a SP List named "Event". On that list I have a column "People" which is a multiple person field. I have another SP List named "Organization". On that list I have a column "User...
Re: how to filter gallery based on Database
Hi @PDRC , So you have a collection with all calendar events, and a database contains all events created by the App. Your purpose is to get all calendar events that are also in t...
Re: Filter by Week on gallery
That is brilliant it has taken the time away. however, I still get issues with the filtering. Not sure if you have any guesses why? Filtering code on the gallery : ...
Re: Create individual records in dataverse from a date range in Powerapps
Hi @selenimo , if i get you well, you want to update the record you get from PBI connector. so you might have to create the End Date column and validity Date column in the PBI environment ...
Re: New Editor Save As to replace different app
The issue in the case of delete and then Save As would be the loss of the AppID which would break any email deeplinks (and other automations which are not solution-aware and don't use env vars)
Re: Guest Accounts not showing up in PowerApp
The difficulty is that I'm trying to write this back to (or read it from) a Sharepoint list via a form in PowerApps. I can see all users from the Office365Users connector, but this is not the s...
Filter gallery powerApps
Hello Smart PowerApp People, I'm a big fan of yours. Coming here often and learning a lot. I struggle with this scenario: there is a gallery connected to a SP list(W1_training_list...
Re: Error: Incompatible types for comparison. These types can't be compared Record , Record
Hi Dezhili, I copied the control from my gallery for the phases to use it as filter and then the formula does not throw any error but the gallery is not getting filtered on the selections. ...
Re: PDF Viewer - Multiline Card
Hello @hcross95 How are you generating the PDF? I would like to know since this is crucial to make accurate suggestions. As of now here's what I would say: For question 1: &nbs...
Re: Patching record in collection creates unwanted new record
@Drrickryp Thanks for your suggestions so far. I did a thorough search through my code but the only place where a new line is added is definately not called (inserted a notify just to be sure).
Re: Use AI Builder to validate data entry
Hi @sophiatheresa74 , Would it be possible to provide more detail on your scenario? Thank you!
Re: Last record submitted to default in new form mode
Hi @Xoli If that's the case, You can put in Default of Start Hours Last(Sort("SharePointList", ID, Descending)).StartHours make sure You place right name for ...
Changing the View state in excel automated button
I am running several shared spreadsheets with multiple users. I have several buttons that are running scripts to show the user only what they need to see, but when 2 or more users are running t...
Re: Order of running the "OnSelect" and "OnChange" triggers
Hi Cha_Cha, I found the solution: Via the "OnChange" i would fill in the Variable Set(ReqVal02,Req02.Value) "OnSelect": UpdateContext({OnSel02: 1}) and with the OnVisible paramete...
Help with different people using a form please
Hello, I was hoping someone could help me please I have a form for people to enter monthly KPI's. I have four different groups that need to enter these KPI's. Currently , I have four button...
Re: Duration until first screen (in seconds) and general loading times suddenly extremely increased
There seems to be an issue that MS are working on, as per this thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/Since-this-morning-any-backend-connection-from-any-of-our/m-p/19095...
Compare all rows in a column in DataFlow
Hi All, I am building a solution based on SharePoint, DataFlow and Dataverse. Users can upload documents in SharePoint, the dataflow with transform the data and when it is refre...
Re: How to pull data from table in dataverse based on chosen record in form (dropdown box)?
Hello @marcy_pi You can try like LookUp(info, name = data.selected.info.name).____[info column you want to show]_______ ✔️ Just in case my response...
Re: Tutorial - How to run the sample component - fails
You kind man, lightened my burden and my day
Re: Return matched values
Hi Manoj, Sorry, its not working, i add here the formula. Can u pls have a look? = Table.AddColumn(#"Changed Type", "Custom", each List.Accumulate(Table.ToList(#"Tbl1","",(state,current)=&g...
Re: Virtual Tables in Dataverse
Did you get this to work? I've followed the directions and do not see the Primary ___ fields on the form. Tried from a couple of different lists, which resulted in the app showing t...
Re: How to run a flow from Power Apps which still runs for Blank Values in Drop downs.
Right, so there shouldn't be a navigate inside your flow run parameters as its trying to send that to flow - could you try the below and let me know what it says - I think you are still missing a par...
Calculate colours
I have 20 boxes that I need to compile into totals for different colors. It looks like the picture, there is Green, Yellow, Red and Double Red. How should I be able to check which box one has written...