web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Import from sharepoint...

Power Apps

Unanswered

Import from sharepoint only field names without values

(0) Share

Report

Report

Posted on by Antonio147

11

Hi, everyone,
I would like to create a collection with field names taken from a sharepoint list.
The end goal is to have a collection with only the records not in the list, add the missing values, and then save the collection to the previous list.
I am hoping for your help, I tried to import the list but it also contains data and when I go to check if present (with If(isBlank(LookUp(...... ), it returns me all the records in the list.
So I thought of creating the collection with only the names of the fields in the list.
Thanks for the suggestions.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Michael E. Gernaey 53,978 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Antonio147

Apologies, I am not following, this is a guess on my part, but it sounds like you want a Collection or new data only? Since you only want the column Names.

Are you ever going to write your collection of data back to the List?

I would honestly say, if you are truly never going to use the list, which is how it sounds. just create your Collection list this.
ClearCollect(MyCollection, { Column1: "MyTextValue", Column2: MyNumberValue, (0,1, 3434, whatever) Column3: MyBooleanValue (true/false/yes/no) } ) Then do Clear(MyCollection); This will have initialized it, and cleared it so you can put nothing but clean data in.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Antonio147 11 on at

Like (0)

Report
Copy link

Link copied!

thank you for your reply FLMike,
my goal is to have a collection with only the field names taken from a sharepoint list.
Once the collection is created, I enter the values from various textbox fields.
Now I created the collection with ClearCollection(<collection name>,{field1:"",field2:"",....})
By doing this, however, I have an empty row (and that is not good).
Also if a column is added to the sharepoint list, my app does not detect it since it is static; whereas if it reads the "field names" from the list, the collection will always have all the fields.
I hope I have given you a better understanding of my problem.
Thanks again

Was this reply helpful? Yes No

Join the conversation