Unanswered

adding data to a SharePoint LIST

(0) Share

Report

Posted on by seetharaman

i have an app like this Below ,

The source of the "some text" is from sharepoint list. also at the "attachment" section there may be an excel file , if there is an excel file we need to concatinate he excel text and " some text" and write to the same share point list in the same row which is the source of the "some text" .

is it possible to do in power apps? sorry i am new to power apps trying to still figure out how to do this . this might be a very basic stuff also.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Dominik_Nau 85 on at

Like (0)

Report
Copy link

Link copied!

Hello @seetharaman
I hope I understood your request in the right way 🙂

You can get the name of the attached file with e.g.: Last(DataCardValue4.Attachments).Name

You can use that in any combination you want to create a new text.
Let us know when you need more details.

Greetings - Dominik

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

Thanks Dominik for the reply ,
My approach :
i understand i need a power automate flow to do the
"read attachment excel and concatenate the contents of different tabs in to one string part". so my understanding is i need to pass some argument to the power automate flow (unique id of the file or uri something) which in turn makes the power automate to take that and construct the concatenated string and update the exact list item that this attachment belongs to.
regarding updating the list item : along with the uri/unique id of the file we will pass the record ID [incremental value which can uniquely locate the list ] , and use some power automate activity to update the list item with these 2 parameters (unique id of the list item and the concatenated string)

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

my question again (framing in a better way) , after reading your response is .
can Last(DataCardValue4.Attachments).Name be the unique id of the attachment which i can send to power automate to read (read the individual tabs and concatenate the tab content into string) ?
can the file id and SharePoint record list id alone alone enough to send as a argument to the power automate flow to update the SharePoint list record ? or anything else is also needed?

Was this reply helpful? Yes No
Dominik_Nau 85 on at

Like (0)

Report
Copy link

Link copied!

Could you please provide more details about the Excel file? I want to understand which data you want to read in order to create the new string. In the case you are talking about values which are stored in a Table, this can be done via Power Automate. For this you need to upload/create the file, read the values, create the new string and update the list-item. In an additional step you can respond to Power Apps with the new string. But first we would need more details about the data you want to fetch 🙂

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

First of all thanks for the quick response.
These are simple excel files. It does not have tables created inside. These are normal excel files where data is stored by rows and coloumns thats all. The whole data should be coipied in to string.
For eg take any excel workbook which has two rows and coloumns data in two different sheets if you jus open it and press ctrl A and ctrl C in another notepad how it will be..that is what i need.
May be one new line and then content of next sheet of the same workbook in the same note pad.
Finally this note pad content is what i need to update in the particular column of the record in my share point list

Was this reply helpful? Yes No
Dominik_Nau 85 on at

Like (0)

Report
Copy link

Link copied!

I'm afraid, but I think it's not possible to achieve what you want with an Excel file which does not contain defined tables.
Maybe you can think about a new version of the Excel file with defined tables and headers so you can list all rows present in a table or to target a key column.
With that in place, it would be straight forward to extract the values you need in order to create a new string from all of them.

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

I understand your point . I can also remember when i worked with PAut in writing some values from sql table to excel ,PAut demanded the excel to have table in order to write the values. But still am surprised that what will be output of "get content " action it will be string rite?
Option A,
Is it possible to read excel file in power apps or same rules applicable inside power apps also ?
Option B :
Can my app or PA flow connect to a gateway if we set up a one. Using which we can call desktop prog to read and return a string via gatway back to the flow or app ?
This is a long shot though

Was this reply helpful? Yes No
Dominik_Nau 85 on at

Like (0)

Report
Copy link

Link copied!

I've made a quick test with an Excel file (no tables!) (.xlsx) and Power Automate - Get file content.
Checking the outputs, I get a Base64 string. Unfortunately I could not manage to get a "Clean-Text" out of it while encoding.
I've made the same test but this time saved the file in upfront as .csv.
Now I can use Base64ToString and get a nearly clean output - still with a lot of commas (due to the content of my file) - but I think you can give it a try 🙂

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

yea am going to test the same thing . meanwhile the idea is to call this flow from the app "upload" button. for that we need to pass some arguments.
first , where is file is located in the microsoft sharepoint. as you said Last(DataCardValue4.Attachments).Name can serve for this purpose ? not sure can you help me in passing the right identifier ?

Was this reply helpful? Yes No
seetharaman 40 on at

Like (0)

Report
Copy link

Link copied!

Also one more way i just got to know , we can use Azure functions to host some scripts. in which case can we use some c# / python program to read the excel file and give a clean content instead of a Base 64 ?
and call the azure function via power automate.

Was this reply helpful? Yes No