cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Open a PowerApps form via SharePoint list ID

When we open a PowerApps form it uses Dynamics 365. How can I use a link to open a specific SharePoint list ID?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @msmith,

 

I have a list called "ListList". I added a dropdown control, and set its Items property to

 

ListList.ID

 

 

The dropdown control shows empty value. So I think PowerApps cannot read the ID of the items from SharePoint list.

1.PNG

 

But once I change the Items property of the dropdown to:

ListList.Column1

The list shows the Column1 from the data source.

 

Insert a display form. Set the DataSource property of the form to ListList and the Item property of the form to this formula:

First(Filter(ListList, Column1=Dropdown1.Selected.Value))

This formula specifies that, after you finish configuring the form, it will show the record that the user selects in Dropdown1 control.

 

Please have a test.

 

For your reference:

https://docs.microsoft.com/en-us/powerapps/add-form

 

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.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @msmith,

 

I have a list called "ListList". I added a dropdown control, and set its Items property to

 

ListList.ID

 

 

The dropdown control shows empty value. So I think PowerApps cannot read the ID of the items from SharePoint list.

1.PNG

 

But once I change the Items property of the dropdown to:

ListList.Column1

The list shows the Column1 from the data source.

 

Insert a display form. Set the DataSource property of the form to ListList and the Item property of the form to this formula:

First(Filter(ListList, Column1=Dropdown1.Selected.Value))

This formula specifies that, after you finish configuring the form, it will show the record that the user selects in Dropdown1 control.

 

Please have a test.

 

For your reference:

https://docs.microsoft.com/en-us/powerapps/add-form

 

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.

View solution in original post

Highlighted

Hello @v-monli-msft

 

I am trying to achieve this with this formula

ID=Form1.LastSubmit.ID

I am using the last submitted ID of the form, but its not populating the data.

Can u confirm this??

 

Highlighted

Thank you for this! I did get it to work with ID, simply make sure ID field is in your form before trying.  I ended up with: First(Filter('Meeting Requests',ID=59)). After creating a variable for the ID number, I can open the app based on an ID variable in a query string: First(Filter('Meeting Requests',ID=varID))

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,327)