Unanswered

Import from sharepoint only field names without values

(0) Share

Report

Posted on by Antonio147

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 (2)

Answers (0)

Sort by

Michael E. Gernaey 53,963 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