Answered

read the data from SQL

(0) Share

Report

Posted on by noor12

[{"O_Inventory":[{"ItemNumber":"1020825","PrimaryQuantity":"1","Colour":"NEW","OrganizationCode":"ABC","SubInventoryCode":"Stock"},{"ItemNumber":"111111","PrimaryQuantity":"1","Colour":"SPACE GREY","OrganizationCode":"ABC","SubInventoryCode":"Stock"},{"ItemNumber":"222222","PrimaryQuantity":"2","Colour":"BLACK","OrganizationCode":"ABC","SubInventoryCode":"Stock"},{"ItemNumber":"333333","PrimaryQuantity":"1","Colour":"SILVER","OrganizationCode":"ABC","SubInventoryCode":"Stock"},{"ItemNumber":"444444","PrimaryQuantity":"1","Colour":"SPACE BLACK","OrganizationCode":"IWD","SubInventoryCode":"Stock"}],"O_ExceptionFlag":false,"O_ExceptionType":"","O_ExceptionDetails":""}]

I have retrieved data from an SQL Server database in Power Apps, how I could created a variable with all ItemNumber values, and implemented a dropdown list. When a user selects an ItemNumber from the dropdown, the app dynamically displays relevant information associated with the chosen ItemNumber

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @noor12

According to your description, do you mean you get the json(String type) from your sql server?

I create a test app like this , i create the test data from TextInput control:

Dropdown1 -items:

ForAll( Table(First( Table( ParseJSON( TextInput1.Text ) ) ).Value.O_Inventory) , {ItemNumber:Text(ThisRecord.Value.ItemNumber),PrimaryQuantity:Text(ThisRecord.Value.PrimaryQuantity),Colour:Text(ThisRecord.Value.Colour),OrganizationCode:Text(ThisRecord.Value.OrganizationCode),SubInventoryCode:Text(ThisRecord.Value.SubInventoryCode)})

Then we can select the [itemNumber] for this dropdown:

Then the Gallery1-items:

Filter( ForAll( Table(First( Table( ParseJSON( TextInput1.Text ) ) ).Value.O_Inventory) , {ItemNumber:Text(ThisRecord.Value.ItemNumber),PrimaryQuantity:Text(ThisRecord.Value.PrimaryQuantity),Colour:Text(ThisRecord.Value.Colour),OrganizationCode:Text(ThisRecord.Value.OrganizationCode),SubInventoryCode:Text(ThisRecord.Value.SubInventoryCode)}) ,ItemNumber = Dropdown1.Selected.ItemNumber)

Then we can use the dropdown1 control to filter the gallery control.

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
noor12 on at

Like
a
(0)

Report
Copy link

Link copied!

in some cases, the data I received for the item number is duplicated however the other details are different, I need to remove the duplicate item number from the drop-down list.

Was this reply helpful? Yes No