Questions tagged [powerapps-datatable]

7 questions
1
vote
0 answers

PowerApps: How to Patch multiple CDS entities with 1:N relationship?

Need to insert a new record in parent entity with lookup fields. After the insert use the value of one column of the new record to insert the child entity which uses the column as a lookup field as well. I am designing a PowerApps Canvas Form to…
Arthur Zhu
  • 21
  • 2
1
vote
1 answer

PowerApps datatable lookup column won't show choices

We are building a PowerApps screen with a data table using a collection as the data source for the Items property. In our onVisible event of the screen we create the collection like this: ClearCollect( collTrackedSales, Filter( …
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
1 answer

Dropdowns populated from Excel tables not getting selected properly

I have a powerapp with dropdowns that are being populated from Excel tables in a separate sheet from the Excel data. Please see attached images of Excel data and tables in two separate sheets. [Excel data][1] [1]:…
Burak
  • 300
  • 2
  • 14
0
votes
1 answer

How can I sortbycolumns with a conditional 'if' before the sort?

I want to sort a list gallery ordening by date with the formula: SortByColumns( AddColumns( Tabela4; "CalcDate"; Max( DateValue(Data)+Qtde_dias_para_contato; …
0
votes
1 answer

Powerapps - Dynamically adding columns (Input Text Boxes) to a table

I am trying to build a Power App that creates Input text boxes dynamically. This is my data. Category Name Product 1 Product 2 Product 3 Product 4 Marketing Center 1 1 1 2 2 Marketing…
0
votes
1 answer

Connect Microsoft Powerapps to PostgreSQL

I'm trying to connect a PowerApps application to my database in PostgreSQL but it won'tt let me, the error it gives me is: PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'. I have installed a gateway. Thank you in…
0
votes
3 answers

Prompt me a requested input field when add datasource in power app

I need to create a custom connector which will prompt me a input field so that I can pass parameter value to get my actual data from data sources. It'll prompt me input field when I try to add a data sources from power apps. Here I attached a…