cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tsunatsuna
Level: Powered On

how to get data in view form from SP list

please tell me;

How to get the data from SP list.

I want to make some screen regarding to new, edit and view. And if it make new file or title, it effect on view screen.

 

here are details;

I insert Forms, then choose data source:SP list, and i select Fields.

I added field, but it seems it can't have the data.

3 REPLIES 3
Community Support Team
Community Support Team

Re: how to get data in view form from SP list

Hi @tsunatsuna ,

 

It seems that you are using the custom form created from SharePoint list. If so, may I know why you want to have 3 screens just for different display mode of Form control? Because by default, the custom form should have one form, and it will change its mode to View/Edit/New according to what user select on SharePoint list interface.

 

See more information about custom form here:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration

 

But if you insist to do so, you could follow below steps to achieve this:

1. Set below formula in the OnView property of SharePointIntegration control:

ViewForm(SharePointForm1);Navigate(showscreen,None)

2. Then set below formula in the Item property of FormViewer1:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('YourListName'),SharePointIntegration.Selected)

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tsunatsuna
Level: Powered On

Re: how to get data in view form from SP list

Thank you so much!@

 

I would like ask you two more things;

1.

I made a FormViewer, and I set action (sharepointintegration>advanced>action>ViewForm).

But error occur like this;

 the function expects an editable form as its input,

 the function has some invalid arguments.

 

2.

I set OnSelect action which Launch(ListBox1.Selected.AbsoluteUri & "?web=1"), meaning I can open attached file in online.

But I think it depends on whether Form and action. I made two form and two action.

sharepointintegration>advanced>action>ViewForm(Formname): not available Onselect(I can't click and can't open file)

sharepointintegration>advanced>action>EditForm(Formname): available Onselect(I can click and open file)

I want to use ViewForm and when I click attached file I can open the file online.

please tell me how to solve this.

Highlighted
tsunatsuna
Level: Powered On

Re: how to get data in view form from SP list

@v-monli-msft 

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,936)