Unanswered

Connecting an edited form to sharepoint list data

(0) Share

Report

Posted on by KL007

Hi all,

So I've connected a PowerApp form to a SharePoint list. On the PowerApp form I've changed some of the DataCardValue to a dropdown (the SharePoint list isn't dropdown but contains the same values), by deleting the datacardvalue and replacing it with a dropdown with manual item values (["yes", "no"]). When I open the form by clicking on a gallery item I want it to prefill all the data, but the DateCardValues that I've changed to dropdown don't get prefilled. Is it possible to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @KL007 can you please tell me the datatype of the field in SharePoint and I may be able to help you understand what to do?

Thanks
Andrew

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Copy link

Link copied!
Here is an example for you I have created a Text Field in a SP List called YesNoText I have added this to my gallery and set the default to:
If(ThisItem.'Yes No Text' = "Yes","Yes","No")
If you can tell me the data type of your field then I can make this more specific for your use case
Canvas App:

SP List:
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
KL007 68 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew,

I should've explained a bit clearer, when a user clicks on the item in the gallery, PowerApps sends them to a new screen with a form. This form includes dropdown fields with columns from the SharePoint list. I want these fields in the PowerApps form to be filled in already with the values form the SharePoint list.

Do you need some more context?

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @KL007 Ok no problems then you can do something like this:
Your form Should be connected to the SP List as its Data Source:

The Item Property set to the Gallery that you have selected:

And then the Dropdown box in the field you wish to display should default to:
ThisItem.FieldName
You need to replace FieldName with your Field:
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No