Power Apps Search
Search
Re: Filter data to run faster
Assign the results of the ForAll() expressions to variables and see what is in the tables. The error about expecting a record doesn't make a whole lot of sense to me since Patch() does take ...
Re: Dataverse table, where are images stored and how can i access them?
How to do this within a power automate flow?
Re: Help me!
@dylandavis09 Nesting the If statements will take you closer to what you want to achieve. Note that with your current data structure, it's possible to "Turn On" both 'DHS Maintenance Window...
Re: How to set control state/visibility based on value in Dataverse?
Hello Aaron, thank you for your input. I actually solved it! When I enter a tracking number (with Patch), the record in the Database gets updated, but the record in the global variable stays t...
Re: Permission asked to Sql connector, "Allow" disabled
@LidiaEmma, please reply if you were able to resolve the issue. Thanks!
Re: Refresh page to reload app
You receive that message because you have Exit(); in your formula. Remove that bit.
Re: Sharepoint List Sum currency collum based off of filters
@CNT, That works but it returns a delegation warning. Do you have a way that won't return one?
Re: Can't get submission from ComboBox in a datacard when submitting form in Power App
Also, what is the update property of your datacard that you are trying to match the value with your combobox?
REST API web query fails to refresh when published, integrate retry
I have a function which is invoked by another query, and it repeats for each customer number, to retrieve data from an API. it works fine on desktop, but when published it throws the error: "The unde...
Re: OnSelect of my submit button failing to push data to SQL
@JemmaD Going back to SCHEDULE_ACHIEVED issue, it appears that this is boolean field. Like I said, the syntax depends on what the Items property of the radio button is. AchievedDescription is...
Re: Can't get submission from ComboBox in a datacard when submitting form in Power App
Highlight what I screenshotted and then go to update under properties. I attached screenshot of text property visible when I select my combobox.
Re: REST API web query fails to refresh when published, integrate retry
Hi @MegaOctane1 Check your returned data for something that you know should be there, if it isn't then call the function again. Something like this . . WebQuer...
Re: If & Patch
Hi @caoimhelambert , If any of the controls in the Patch are not in the Gallery, remove the _Gal. part at the front. Patch( TimesheetEntries, ForAll( Filter( gal_Ti...
Re: When I enter in a new record into my form my dropdown doesn't retrieve the new number.
The refresh() should work, where are you putting it? Also, the only other thing it could be, you aren't setting the matching GL number when saving it for it to show up in the d...
Re: Submitting the same data with 3 diferent forms
Hi @JasonCastro, Your if statement will always submit the first form if the first condition is met, that's way how if statement works, it will only operate on the first result if the first con...
Re: Taking image and settin a variable with it
Hi @Calcioscacchi , If you want to update the image to the attachment column, the data is required to have the format of Table( attachment), I have given a detailed answer on how t...
Re: Open App in Teams Error
Hi @BestJust , Please try adding users to this app's environment and assigning them the appropriate security roles. Besides, please make sure that the assigned security role ha...
Show/hide fields on a form based on data in another table
Hi all, Just wondering if it is possible to show or hide fields in a model driven app based on data which is held in another "configuration" table. I am working on an application that record...
Re: The specified column is read only and cant be modified
Thank you so much @BadriPradhan . This seemed to have fixed my issue. For everyone else tearing their hair out about this, I am not even using the Patch function so it seems that the issue ...
Re: SubmitForm submitted entry Created By is not the logged in user.
Hi @KarlinOz , What is the formula for submitting data? Pathc or SubmitForm function? Did you create another flow and add it to the app to create the record? B...
File Attachment name does not appear in Form
Hi There, I have a very designed simple dataverse table with one text column for customer Name and 3 file attachments for saving customer files in three different attachment column. I am using Canv...
Re: SubmitForm submitted entry Created By is not the logged in user.
Hi @KarlinOz , Please log in the powerapps portal (make.powerapps.com), click the 'connection' button (in the left navigation), find the wrong connection and delete it. Th...
Re: Formatting calculated fields from Sharepoint in Power Apps
I think Rechnungsbetrag Netto is text data type so you should change text to value. Text(Value(ThisItem.'Rechnungsbetrag Netto';"[$-en-US]#.00") Thanks!
Re: Display and/or update a date in an Excel file
Hi @Charline_74 , Does the date picker in a data card? Please try this: Update of data card:Text(DatePicker.SelectedDate,"dd/mm/yyyy") Best regards, Rimmon
