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.

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
Users Online
Currently online: 138 members 5,462 guests
Please welcome our newest community members: