PowerApps - Add data from Dropdpwn to form

 Hi all,

To be able to submit data from a self created form in which drop down is present and submit to database use COLLECT function in PowerApps

Collect('[dbo].[POS_Target]',{POS_ID:Value(POSID.Text),Country_Name:Market.Text,POS_Name:POSName.Text,MONTH_NAME:Month.Selected.Value,Year_Detail:Value(Year.Selected.Value)})

A drop down would require Selected.Value and if it is a number then it requires cast and hence bound it by (Value)

PowerApps - "Add a DataSource" option is missing

 Hi All,

Here is a error which took me more than an hour to fix.

I wanted to add another table in PowerApps and I could not find "Add New Data Source Tab". To get the list of tables from which you can choose

Click on View, In search bar of Data tab type sql, click on your datasource name and to your right hand side, you would find the list of tables

Phew!!Wonder whether coding or finding is difficult ??

PowerApps - Insert a collection

Hi All,

Find below the formula to insert a collection in PowerApps. This can be used in places where data is limited

ClearCollect

(

CurrencyDetail,

{

AUD:"AUD",

CHF:"CHF",

CNY:"CNY",

EUR:"EUR",

GBP:"GBP",

HKD:"HKD",

IDR:"IDR",

INR:"INR",

JPY:"JPY",

}

)

Enjoy coding!!

PowerApps - the type of this argument does not match the expected type "number". found type "text"

 Hi All,

The fix for the above error is to use the Value

Codefix - 

Patch('[dbo].[Staff_Target]',ThisItem,{Staff_ID:Value(TextInput3.Text)})

Instead of (i,e earlier code)

Patch('[dbo].[Staff_Target]',ThisItem,{Staff_ID:TextInput3.Text})

Change Height and width of canvas in PowerApps

Hi All,

Follow the below steps to change the height and width of canvas in PowerApps

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/set-aspect-ratio-portrait-landscape

 

PowerApp - The Specified record was not found/Resource not fo...

 Hi All,

I was trying to add new form and include new data and I encountered the above error. To resolve the error, simply refresh the entire PowerApp screen....Yipee issue is now resolved

PowerAPP does not show EDIT Screen, when connected to SQL Table

 Hi All,

To resolve the above error, please ensure that  a primary key is set to the table that you are connecting.

Bingo! Enjoy developing

PowerApps - Please enable third party-cookies and site data in your browser settings. If you are using Chrome's Incognito mode, you can uncheck the 'Block third-party cookies' option on the Incognito langing page. Try again

 Hi All,

To resolve the above error, perform below steps

1. Select Settings.
2. Select Cookies and site permissions.
3. Expand Cookies and site data.
4. Click on "Add" under Block third-party cookies as shown below
5. Add [*.]powerapps.com and while adding this, put a check mark for "Including third-party cookies on this site"

Bingo, issue is fixed