cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RodM
Helper III
Helper III

Form data source as SharePoint, with datacard questions from Excel rows?

I would like to create a form which stores data in SharePoint, but acquires SOME of the datacard fields from Excel table rows. Would this be possible? Please see below for more details:

 

Example Excel Table structure:

Questions
Phrase 1
Phrase 2

 

 

Example SharePoint list structure:

People PickDateQuestion 1Answer 1 Question 2Answer 2
John Smith1/5/2022Phrase 1YesPhrase 2Yes

 

Example PowerApp form:

Datacard QuestionsFields
People PickJohn Smith
Date1/5/2022
Phrase 1Yes
Phrase 2Yes

 

1 ACCEPTED SOLUTION

Accepted Solutions
RodM
Helper III
Helper III

I've decided to just use a lookup from a second SharePoint list instead of trying to overcomplicate this solution.

View solution in original post

1 REPLY 1
RodM
Helper III
Helper III

I've decided to just use a lookup from a second SharePoint list instead of trying to overcomplicate this solution.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (4,082)